MICROSOFT EXCEL 2010 INTERMEDIATE LEVEL 2 (MEXI2)
Take the road to becoming an Excel expert 
with the 2nd level of our 3 Excel Courses

WHO SHOULD ATTEND?

Microsoft Excel training course
The level 2 Intermediate course advances the student onto a higher level where more complex functions & formulas are explained. We will look at Charts, Graphs, Conditional functions, Named ranges, Formula Auditing tools, Linking and many more.

The expertise learned in this course are fundamental tools to be considered an expert in Excel and is crucial in saving time, costs and improve your efficiency.

After completing this course, Level 3 are advisable, to enhance your Excel efficiency to an expert level.
  • Duration 8:30 - 16:30
  • Receive a Certificate of attendance
  • Training by a dynamic and experienced facilitator
  • Training manual with notepad & pen

DOWNLOAD REGISTRATION FORM HERE

registration_form.pdf
File Size: 107 kb
File Type: pdf
Download File

COURSE OUTLINE

Module 1: Basic Overview
  • Excel Keyboard Shortcuts
  • Entering & Editing data
  • Obsolete references

Module 2: Named ranges
  • What is it and how do we utilise it?
  • Naming individual or a range of cells
  • Editing & Deleting of named ranges
  • Using named ranges in formulas, functions
  • Manage names
  • Navigating names

Module 3: Formula auditing tools
  • Revealing formula
  • Tracing dependents/Precedents
  • Goto special
  • 3D Calculations
  • Linking sheets in the same file
  • Linking sheets in different workbooks
  • Using edit/links
  • Data consolidation

Module 4: Conditional Functions & Formats
  • IF/NestedIF statements
  • AND
  • OR
  • NOT
  • SUMIF, COUNTIF, AVERAGEIF
  • IFERROR
  • Conditional Formatting
  • Date calculations
  • DAY(), MONTH(), YEAR()
  • Time calculations

Module 5: Worksheet management & Linking
  • Link sheets in same workbook
  • Link cells in different Excel files
  • Manage & edit links
  • Viewing different files the same time
  • Data consolidation
  • Use data forms

Module 6: Data list management
  • Autofilter
  • Sorting data
  • Advanced filter
  • Data validation for clean data capturing
  • Subtotals in a list
  • Grouping data
  • Use data form

Module 7: Creating Charts & Graphs
  • Creating a chart with the keyboard
  • Chart Wizard
  • Edit & format a chart
  • Changing the chart source data
  • Apply trendlines (Only Excel 2010)
  • Using sparklines (Only Excel 2010)
  • Change charts from object to sheets
  • Add labels and axes to chart
  • Showing specific data points
  • Save custom chart types
  • Changing the default chart type

1 Day course 
R1 850
All inclusive 
(10% Discount: 2+ delegates)

Register here
Picture
Picture
Picture
Photos used under Creative Commons from http://www.freedigitalphotos.net: Andy Newson,  Arvind Balaraman, Ambro, digitalart, photostock, 

Biz Training Institute © 2012

Accepted in the ezSearch South African business directory. Accepted in the ezSearch South African business directory.