Five sessions that will help you get the most out of your spreadsheets
Microsoft Excel Fundamentals Bundle: The five sessions setting the foundation for Excel expertise.
Advanced Formatting Options, Format Painter Tool, Themes, Styles and A-ha! tips
Absolute Cell References, If Statements, Janet's Favorite Formulas and Paste Special Applications
Links, Comments and Notes, Hiding and Unhiding Rows/Columns/Sheets, Macros
Automatically format cells based on their values or their value in relation to other cells
Creating a Spreadsheet, including Entering and Editing Data, Opening, Saving, Exporting and Sharing Files, PLUS AutoFill and Keyboard Shortcuts
Best practices for creating a spreadsheet, Keyboard shortcuts, AutoFill, and Format Painter
The Excel Window, The File Tab, and Spreadsheet Navigation
Filtering data by text, number, and dates and Find options
Improve the appearance and readability of your spreadsheet with these formatting tools, including how to move and copy rows, columns and cells
Set up formulas and let Excel do the work for you.
A crash course - in under an hour - on Microsoft Excel!
Gridlines, Freezing Panes, Printing Row & Column Labels, Headers & Footers
Setting up and Using a PivotTable, Creating a PivotChart
File Protection Options, Locking Cells and Protecting Spreadsheets, Data Validation
Helpful tools for viewing and printing your spreadsheet, including: Print Options, Print Preview, Page Breaks, and Page Layout Tools
Sorting options, Subtotals and Nested Subtotals
Managing, Printing and Linking Multiple Worksheets
Creating an electronic form using Microsoft Excel