THE AGENDA: IT’S YOURS TO CONTROL.
You have a spreadsheet screaming for an overhaul? We’ll take it on. General techniques? No problem. Want me to guide you from square one? I know exactly where to start.
For general lessons, here’s a very broad survey of areas we may explore:
- Fundamentals, like navigation, formatting, copying, sorting, merging cells
- Other basics, like filtering, and freezing cells; setting up the print area
- Simple formulas, like SUM, AVERAGE, and COUNT
- Building a model with inputs and outputs
- Decision making formulas, like IF, COUNTIF, SUMIF
- Looking up with VLOOKUP and HLOOKUP
- Leveraging CONCATENATE to create something new and useful
- Error handling with IFERROR
- Weighted Averages with SUMPRODUCT
- Find the text you need with LEFT, RIGHT, and LEN
- Time and date functions like HOUR, NOW, and YEAR
- Filtering for unique cells; removing duplicates
- Data validation; utilizing drop-down lists
- Deploying spin controls, check-boxes, and option boxes
- Naming formulas, cells, and ranges
- Dynamic ranges: auto adjusting to table size
- Simple conditional formatting
- Conditional formatting with inputs and named ranges
- Recording and editing macros
- Pivot tables and pivot charts
- Statistical functions, like CONFIDENCE, STDEV, QUARTILE, and RANK
- Protecting workbooks
- Hyperlinks and comments
There’s so much more to list…but it’s really not even about the list. I will teach you strategy to build an efficient and effective workbook. I’ll show you the right tool for the right purpose. I”ll show you how to execute evenly, with style.
