Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data.
Pre-requisite(s): Excel Level 2
Course OutlineLesson 1 : Logical and statistical functions
- Logical functions
- Math and statistical functions
Lesson 2 : Financial and date functions
- Financial functions
- Date and time functions
- Array formulas
- Displaying and printing formulas
Lesson 3 : Advanced data management
- Validating cell entries
- Exploring database functions
Lesson 4 : Analytical tools
- Goal Seek and Solver
- The Analysis ToolPak
- Scenarios
Lesson 5 : Outlining and subtotals
- Outlining and consolidating data
- Creating subtotals
Lesson 6 : Documenting and auditing
- Auditing features
- Comments in cells and workbooks
- Protection
- Workgroup collaboration
Lesson 7 : Macros and custom functions
- Running and recording a macro
- Working with VBA code
- Creating functions
Lesson 8 : Appendix - Exporting and importing
----note: Appendix content is not covered in the one day course
- Exporting and importing text files
- Exporting and importing XML data
- Getting external data
Lesson 9 : Appendix - Additional Features
----note: Appendix content is not covered in the one day course
- Sharing workbooks as Web pages
- Using hyperlinks
- Sharing workbooks
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.