Improve your Excel skills Quickly with our Step-by-Step Training Method

Microsoft Excel

Inquire Now

Microsoft

Microsoft Excel is the leading spreadsheet software in the home and business sector. Currently there is strong demand for highly skilled Excel operators.

Our training is delivered through our On-line 24/7 Mentored training platform.

The training is broken up into modules from Beginner to Intermediate to Advanced.

Training Modules and Objectives

Creating a Spreadsheet

  • Input text, values, and formulas
  • Edit data
  • Use the speech and handwriting recognition features
  • Use AutoCorrect, AutoFill, and AutoSum
  • Retrieve backup files following a system crash

Formatting Data

  • Use AutoFormat
  • Apply different number formats
  • Change the size of rows and columns
  • Change fonts and font sizes
  • Modify the alignment of cell entries
  • Add borders, shading, and colors to cells

Editing and Printing Worksheets

  • Find and open a workbook
  • Edit a workbook
  • Find and correct errors
  • Prepare a workbook for printing
  • Print a workbook

Managing Worksheets

  • View information in a worksheet
  • Insert comments
  • Use Find and Replace
  • Protect a worksheet
  • Manage multiple worksheets
  • Create a summary worksheet

Charts and Databases

  • Create charts using Chart Wizard
  • Insert clip art into a worksheet
  • Create your own graphics
  • Create a database
  • Manage a database

Formulas and Functions

  • Work with formulas
  • Use references and AutoSum
  • Enter Functions
  • Use basic and date functions
  • Use financial and logical functions

Hypertext and Tips

  • Add hyperlinks to Excel worksheets
  • Follow and edit hyperlinks
  • Save static and interactive Web pages in Excel
  • Edit Web pages
  • Send Excel workbooks in e-mail

Filtering and Sorting Data

  • Remove duplicate records from an Excel worksheet
  • Apply filters to an Excel worksheet
  • Apply one-click, multiple-level, and custom sorts to your data

Using Pivot Tables

  • Create pivot tables
  • Modify pivot tables
  • Use pivot tables to quickly and easily analyze complex data sets
  • Apply pivot tables for common uses

Working with functions

  • Calculate results with math functions
  • Use date and time functions
  • Adjust text with functions
  • Work with logic and information functions
  • Use lookup functions to locate data
  • Determine payments with financial functions
  • Use statistical functions to determine relationships

Using Data Analysis Tools

  • Use What-If analysis in Excel 2007
  • Create analyses with Scenario Manager
  • Analyze data using Goal Seek
  • Install Solver

Automating with VBA Macros

  • Enable the Developer tab on the Ribbon
  • Modify macro security settings
  • Record and run macros
  • Record a macro that uses an advanced filter
  • Customize macros for everyday use
  • Combine elements of written code with recorded code

Adding Connections and Importing Data

  • Connect two worksheets in separate workbooks
  • Use the Links tab on the Trust Center
  • Set up a connection to a Web page
  • Import an XML file
  • Connect to an Access database using Microsoft Query

SkillFusion Training Benefits

  • Cost effective - You don't have to break your budget to get started
  • Flexibility - You don't have to take time off work or disrupt your schedule
  • Specialised Teacher Support - You will have support for all your questions
  • Hands on skills - Software simulations in real world scenarios

Take the next step now!

Register for more information and receive FREE of charge our e-book
"11 Breakthrough strategies for Interview Success"

Register Now