Level 1 (Intro)
Course Objectives
- Identify basic worksheet and workbook concepts and terms
- Enter & edit data
- Modify the worksheet
- Use functions to calculate and return values
- Format cells to enhance the appearance of your worksheet
- Use drawing features and other enhancements
- Change the page set-up to define how the printed worksheet appears.
Duration: 1 Day
Level 2 (Intermediate)
Course Objectives
- Using multiple worksheets, workbooks and workspaces
- Working with Financial functions
- Use advanced formatting techniques
- Using the Auditing Tools to track information
- Using charts to display financial data
- Use Templates.
Duration: 1 Day
Level 3 (Advance)
Course Objectives
- Creating, Maintaining, Filtering and using Subtotals in a List
- Recording, Assigning and Using Macros
- Creating and Using User-Defined Functions
- Performing “What If” Analyses
- Working with Scenarios
- Querying a Database
- Importing and Exporting Files and Data
- Protecting Data
- Pivot Tables, Reports and Charts.
- Other Advanced Business Analysis Tools
Duration: 2 Days
Who Should Attend?
- This courses takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.