Microsoft Excel, Level 3
Overview | Level 1 | Level 2
Printable Version
TOPIC 1 – FORMS AND PROTECTION
- Formatting Alternating Rows
- Displaying the Developer Tab on the Ribbon
- Using Checkboxes on Forms
- Locking and Hiding Cell Contents
- Protecting and Unprotecting Worksheets
- Creating Workbooks from Templates
- Creating a Custom Template
- Sending Files in Email
TOPIC 2 – MACROS
- Adjusting the Macro Security Settings
- Using the Macro Recorder
- Examining a Macro in the Visual Basic Editor
- Recording a Complex Macro
- Editing a Macro in Visual Basic
- Displaying a Message Using Visual Basic
- Saving a Macro-Enabled Workbook
- Attaching Macros to Button Objects
- Adding Macros to the Quick Access Toolbar
- Creating a Calendar Control Object
TOPIC 3 – TOOLS FOR POWER USERS
- Converting Text to Columns
- Marking Duplicate Entries on a Worksheet
- Removing Duplicates
- Using the Name Manager
- Special Copy and Paste Methods
- Creating Custom AutoFill Lists
- Handling Leading Zeros
TOPIC 4 – ADVANCED FUNCTIONS
- Using the SUMIFS Function
- Creating Nested IF Functions
- Using the AND and OR Functions
- Using the IFERROR Function to Hide Error Messages
- Using the CONCATENATE Function
- Using the HYPERLINK Function
TOPIC 5 – AUDITING YOUR WORKSHEETS
- Selecting Special Cells on a Worksheet
- Using the Formula Auditing Tools
- Using the Watch Window on Large Worksheets
TOPIC 6 – ADVANCED CHARTING
- Advanced Charting Methods
- Displaying Charts on a Worksheet
- Switching Chart Rows and Columns
- Changing Chart Layout
- Resetting the Quick Access Toolbar
Overview | Level 1 | Level 2
