Description
Excel Level 4 is a one-day instructor led course building upon the Level 3A course that continues teaching the more advanced features in Microsoft Excel. Upon successful completion of this course, participants will be able to use macros to automate repetitive tasks and what-if analysis to analyze data, validation to ensure the data in your workbook is appropriate, build lists, and use Quick Analysis features to automate many common tasks.
– Macros
- • Benefits of Macros
- • Recording Macros
- • Relative vs. Absolute Recording
- • Running Macros using Various Techniques
- • Editing Macros
- • Deleting Macros
- • Making Macros Accessible to Various Workbooks
– What-if Analysis
- • Solver
- • Goal Seek
- • Scenario Manager
– Data Validation
– Advanced Import/Export/Linking
- • Importing data into Excel
- • Text file
- • Database
- • Exporting data from Excel
- • Linking Data
- • Custom Lists
- • Custom Views
– Saving in Different Formats
– Hyperlinks
- • Creating/Editing/Deleting
– Quick Analysis Features
- • Built-in efficiency feature introduction
- • Instantly create:
- • Conditional Formatting
- • Charts
- • Totals
- • Tables
- • Sparklines