EXCEL ADVANCED ALL VERSIONS

Microsoft-Excel-Logo.png

Included in the course

  •  A course attendance certificate
  •  Tea and Biscuits during breaks
  • Lunch
  •  A notepad and pen
  •  A manual and datafiles

Course Code: EXCEL-L3

Duration: 1 Day 

***Course Content is based on Excel 2013 ***

This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel® : Part 1 (Second Edition) and Part 2 (Second Edition) courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips


Study Methods available for this course;

   Classroom Training    Onsite Training
   Mentored Learning   Correspondence
   Virtual Classroom Training    Part Time Training
   E-Learning

GET A QUOTE NOW!


Name:*
E-mail:*
Phone:
-
Date:
Study Method:
Course Code:
Course Description:
No of Students:
Message:*
Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
   Topic A: Use 3D References
   Topic B: Use Links and External References
   Topic C: Consolidate Data

Lesson 2: Sharing and Protecting Workbooks
   Topic A: Collaborate on a Workbook
   Topic B: Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality
   Topic A: Apply Data Validation
   Topic B: Work with Forms and Controls
   Topic C: Work with Macros

Lesson 4: Applying Conditional Logic
   Topic A: Use Lookup Functions
   Topic B: Combine Functions
   Topic C: Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets
   Topic A: Trace Cells
   Topic B: Search for Invalid Data and Formulas with Errors
   Topic C: Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools
   Topic A: Determine Potential Outcomes Using Data Tables
   Topic B: Determine Potential Outcomes Using Scenarios
   Topic C: Use the Goal Seek Feature
   Topic D: Activate and Use the Solver Tool
   Topic E: Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually
   Topic A: Use Advanced Chart Features
   Topic B: Create Sparklines

Prerequisites
Target Student

Contact Information

Address

Durbanville, Cape Town

Call Us
021 065 0347
Email

info@idigisol.co.za

Subscribe to our mailing list

* indicates required

Live Help

Live Help

Quick Contact

Search