Busy, Busy, Busy. These days, life is busy and particularly, work life can be very busy. Most of us are juggling multiple tasks and time sensitive deadlines on a regular basis. Who has time to waste spending more energy on any given task than is necessary? Not me, I’ve got better things to do with my time! I have literally been in situations where the courier is waiting at the door to take a competitive proposal and the clock is ticking. Miss the deadline, miss the opportunity for the work. Can you spell stress? Honey, I know your pain.
To that end, I am starting a new series on the top streamliners and timesavers in Excel, Word, PowerPoint and Outlook. We’ll start with the basics and then move on to the features that can really simplify workflow and make your working life a lot easier. Although not an exhaustive list, these features of the Microsoft Office program go a long way to streamlining workflow and increasing productivity. In the first part of this series we’ll look at the benefits of using the following Excel features:
- Navigation and Selection Techniques
- Shortcut Keys & Key Tips
- Customizing the Quick Access Toolbar and Ribbon
- Using AutoFill
- Creating Custom Lists
- Using the Function Library and AutoSum
- Applying Data Validation
- Creating Pivot Tables
- Applying Conditional Formatting
- Consolidating data across spreadsheets
In each of these topics I’ll give a brief explanation of the feature including the best uses and applications for it and the benefit of using it. So stay tuned and increase your knowledge and power when working in Excel!