Apply conditional formatting to highlight data based on specified criteria. Create and apply data validation rules to help ensure accurate data entry. Create and apply custom date and number formatting. Move and copy worksheets and export data from Excel for use in Word. Create pivot table reports. Password protect at the worksheet and workbook level. Record and run macros and view and edit VBA code.
6 hours

Data Validation

Custom Date and Number Formatting

Worksheet Protection

Workbook Protection

Moving and Copying Sheets

Exporting Data from Excel

Consolidating Data

Getting Started with Excel Macros

• Recording a Command Macro
• Using the Visual Basic Editor
• Running a Command Macro
• Creating macros for Printing
• Adding Macros to Buttons and Menus
• Using the Personal Macro Workbook