EXCEL INTERMEDIATE 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-L2

Duration: 1 Day 

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

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel®: Part 1 (Second Edition) course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence.


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: Customizing the Excel Environment
   Topic A: Configure Excel Options
   Topic B: Customize the Ribbon and the Quick Access Toolbar
   Topic C: Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas
   Topic A: Use Range Names in Formulas
   Topic B: Use Specialized Functions
   Topic C: Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting
   Topic A: Analyze Data by Using Text and Logical Functions
   Topic B: Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables
   Topic A: Create and Modify Tables
   Topic B: Sort Data
   Topic C: Filter Data
   Topic D: Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts
   Topic A: Create Charts
   Topic B: Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
   Topic A: Create a PivotTable
   Topic B: Analyze PivotTable Data
   Topic C: Present Data with PivotCharts
   Topic D: Filter Data by Using Slicers

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