|
Provided by: Act Training Excel Level 3Computer |
 |
Training
Provided by Act Training
Advanced level one day hands-on instructor led course on Microsoft Excel. Topics include: Customizing the Work Area; Advanced Formula Construction; Using Pivot Tables; Working with Multiple Worksheets; Consolidating and Analysing Data; Using Protection and Display Options; Introduction to Macros; Working with Interactive Excel Web Documents.
The prerequisite for this course is Excel Level 1 & Level 2 or equivalent knowledge.
Related Software Programs or Products: Microsoft Excel
|
|
||||||||||||
Excel Level 3
Lesson 1: Customizing the Work Area; Working with Built-in Toolbars, Using Custom Toolbars, Creating and Using Styles
Using Templates.
Lesson 2: Advanced Formula Construction; Using Names, Using the IF Function, Using the VLOOKUP Function, Using IS Functions and the Auditing Features.
Lesson 3: Using Pivot Tables; Creating Pivot Tables, Modifying Pivot Tables, Grouping and Summarizing Data in a Pivot Table, Creating Interactive Pivot Tables for the Web.
Lesson 4: Working with Multiple Worksheets; Working with Workbooks, Linking Cells in Different Workbooks, Workbook Versus Links and Workspaces, Sharing and Merging Workbooks
Lesson 5: Consolidating and Analyzing Data; Consolidating Data from More Than One Worksheet, Using the Goal Seek and Solver Utilities, Using Scenario Manager to View a Worksheet with Different Input Values.
Lesson 6: Using Protection and Display Options; Using Comments, Protecting Workbooks, Using Custom Views.
Lesson 7: Introduction to Macros; Running Macros, Recording a Macro, Viewing and Editing VBA Code.
Lesson 8: Working with Interactive Excel Web Documents; Saving Excel Worksheets as Web Documents, Spreadsheet Web Components.
Using Templates.
Lesson 2: Advanced Formula Construction; Using Names, Using the IF Function, Using the VLOOKUP Function, Using IS Functions and the Auditing Features.
Lesson 3: Using Pivot Tables; Creating Pivot Tables, Modifying Pivot Tables, Grouping and Summarizing Data in a Pivot Table, Creating Interactive Pivot Tables for the Web.
Lesson 4: Working with Multiple Worksheets; Working with Workbooks, Linking Cells in Different Workbooks, Workbook Versus Links and Workspaces, Sharing and Merging Workbooks
Lesson 5: Consolidating and Analyzing Data; Consolidating Data from More Than One Worksheet, Using the Goal Seek and Solver Utilities, Using Scenario Manager to View a Worksheet with Different Input Values.
Lesson 6: Using Protection and Display Options; Using Comments, Protecting Workbooks, Using Custom Views.
Lesson 7: Introduction to Macros; Running Macros, Recording a Macro, Viewing and Editing VBA Code.
Lesson 8: Working with Interactive Excel Web Documents; Saving Excel Worksheets as Web Documents, Spreadsheet Web Components.
About The Training Provider: Act Training
Act Training - We provide training in Computer Applications such as Microsoft Word, Excel, PowerPoint, Access, Outlook, Sage Accounts and Sage Payroll; Professional IT subjects such as CompTIA A plus, CompTIA N plus, MCP, MCSA, MCSE and CISCO; Office skills such as Bookkeeping, Accounting, Pitman & Teeline Shorthand, OCR Text Processing and Keyboard skills.
These subjects are taught on site for individuals...
