This is Excel from the ground up – for the novice or the self-taught, eager to learn the intricacies of the program. A spreadsheet built on a weak foundation will only get worse as you go forward. Learn your way around the screen components. There are many nooks and crannies in Excel that you need to know. Design your own spreadsheet, and create your own formulas. Learn techniques for double-checking for accurate numbers! Basic navigation and selection techniques will save hours of scrolling and ineffective dragging through cells (as they go flying by out of control). Editing and formatting will be covered in detail. Viewing techniques and document setup will ensure that your final document prints as you thought it would! Shortcuts will be included throughout the class for all who are interested in shortcuts.
The topics in this class are not necessarily more difficult, there are just more topics that most of us need to know to make the most of the program. A brief review of basics is held at the start of class to make sure everyone is on the same page (worksheet). Date considerations are examined, such as date lists, formats, and calculations. Other lists are created, to include number patters, number words, and custom lists. Learn absolute reference formulas and a trick for speeding up the process of multiple calculations. Inserting a formula and the formula library will be explored. More advanced formatting will be covered to include rotations, wraps, indents, vertical centering, merge and centering, use of styles, and conditional formatting. Learn to manage worksheets and to calculate across worksheets and workbooks with linked 3-D formulas. Use Formula Auditing, Watch Window, and Comments to kick your spreadsheet work up a notch!
Accuracy and clarity is what we are trying to achieve with our spreadsheets, and more advanced page setup features will help with that. Charting will add to the clarity of what the numbers on the spreadsheet are telling us if we create appropriate charts. Learn the ins and outs of what data to select before charting and which chart to apply. Chart format can be set for each chart object! We could spend a full day on charting...
Basic database features within Excel will be covered, such as Finding and Replacing, Sorting, Filtering, and Subtotals. Incorporate the automation of tracking changes and revisions for your own spreadsheets or shared files. And finally, learn to protect a worksheet and create a template so that a report can easily be recreated.
Advanced database features are another "must know". Many users only use Excel for list management, database applications. Learn multi-level Sorting, Advanced Filters, Grouping and Outlining, Data Validation, Data Consolidation, PivotTables and PivotCharts, and even more built-in calculation functions.
Analysis gives further meaning and ease-of-use to getting more information out of all of that data we have taken the time to enter. Use Goal Seek, Scenarios, and Custom Views. Create macros to automate many of the repetitive tasks you do "manually" on a daily basis. Export and import data with meaning! Custom charts will be added for even more detail and control.