Archive for Excel
You are browsing the archives of Excel.
You are browsing the archives of Excel.
I use a pretty large Excel Workbook every day in my job. I thought it might be nice to have a “motivational” phrase show each time the workbook was opened. Something to start the day out on the right foot.
In my workbook I created a worksheet called phrases that simply consist of a motivational [...]
When using Excel I find that I will often times want to setup a worksheet that I can use as a template. For example I might have some monthly sales or inventory tracking that I do and I want to use the same format each month, but I want each month to be on a separate [...]
This is the first in a series of a few articles that I will be sharing on little tips and tricks in Microsoft Excel that I have accumulated or built over the last few months. I’ve incorporated most of these into an Excel workbook or two to meet my specific needs. I’m not really a [...]
As a project manager, I am always looking for great tools and utilities that will help me to become more productive and improve customer (internal and external) experience.
I know about the standard stuff that we use like Microsoft Project, Mindmapper, Excel, Outlook and the like. What I would be interested in is hearing what you’ve [...]
There are a LOT of theories and ideas floating around to help with time management and productivity. Classes and seminars are offered, books are published, and websites and blogs are posted all to try to help us better manage our lives. For this author there has been no one method to help with time and productivity [...]
By my own admission I am NOT a Microsoft Excel expert. I know enough about the application to make me dangerous.
I use Excel pretty extensively in my day to day work activities, and in my continuing effort to streamline my day I decided that I needed to add some functionality to my project management spreadsheet. This [...]
I have a HUGE spreadsheet that I use for work where each customer gets 2 individual worksheets and there are rollup totals for those worksheets, etc… Navigating through this was initially a problem for me then I found out about Hyperlinking… I started out real simple… I created a blank worksheet, entered my customer names [...]
In my job it is not uncommon for me to visit with customers and need to be able to access the functionality of Microsoft Office Word or Excel only to find that my customer does not own the Office Suite. To handle this situation I can either get what I need and email it to myself so [...]