"People do not invest in education because they are rich. They become rich because they invest in education."


- Gabriel Verhoef

Microsoft Excel course details


Microsoft Excel Course Training


Length: 3 days
Audience: Anyone
Technology: Microsoft Office
Job Opportunity: Office Administrator
Delivery Method: Electronic Learning(Online Learning), Instructor-led (classroom)
Excel Online Training Courses

Microsoft Excel Courses | Online & Classroom Training

Microsoft Excel training


MasterGrade IT's Excel Courses will teach you all you need to know.Microsoft Excel is the standard spreadsheet application for both business and personal use.

Microsoft Excel Training is designed for Beginners to Power users and helps you create the most amazing Mathematical work spreadsheets.

After attending Microsoft Excel 2010 Training Course you will be able to use Excel Features and Excel Formula's, Functions,Charts,Bookkeeping,Tax Invoices and loads more.


Upgrade to Microsoft Excel 2013!

 

Who will benefit from Microsoft Excel training?


Whether you’re new or already an advanced user, You will be able prepare the following Using Microsoft Excel 2010

  • Creating a Basic worksheet in Microsoft Excel.
  • Inserting Graphic Objects using Microsoft Excel
  • Using PivotTables, Slicers and PivotCharts in Microsoft Excel.
  • Analysing Data in Microsoft Excel.
  • Working with Data using Math Functions in Microsoft Excel.
  • Manipulating Data using text and information functions in Microsoft Excel

  • Microsoft Excel 2010 Level 1

    Lesson 1: Creating a Basic Worksheet

    • Identify the Excel User Interface
    • Customize the Excel Interface
    • Work with Cells
    • Enter Data in an Excel Workbook
    • Obtain Help

    Lesson 2: Performing Calculations on a Worksheet

    • Create Basic Formulas
    • Calculate Using Functions
    • Copy Formulas and Functions

    Lesson 3: Modifying a Worksheet

    • Manipulate Worksheet Data
    • Modify Worksheet Elements
    • Search Worksheet Data
    • Modify Rows and Columns

    Lesson 4: Formatting a Worksheet

    • Modify Fonts
    • Spell Check a Worksheet
    • Apply Number Formats
    • Add Borders and Colour to Cells
    • Align Cell Contents
    • Apply Cell Styles

    Lesson 5: Printing Workbooks

    • Set Page Breaks
    • Set Page Layout Options
    • Print a Workbook

    Lesson 6: Managing a Workbook

    • Format Worksheet Tabs
    • Manage Worksheets
    • Manage Workbook Views

    Microsoft Excel 2010 Level 2

    Lesson 1: Calculating Data with Advanced Formulas

    • Apply Cell and Range Names
    • Calculate Data Across Worksheets
    • Use Specialized Functions
    • Analyze Data with Logical and Lookup Functions

    Lesson 2: Organizing Worksheet and Table Data

    • Create and Modify Tables
    • Format Tables
    • Sort or Filter Worksheet or Table Data
    • Use Functions to Calculate Data in a Table or Worksheet

    Lesson 3: Presenting Data Using Charts

    • Create a Chart
    • Modify Charts
    • Format Charts

    Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

    • Create a PivotTable Report
    • Filter Data Using Slicers
    • Analyze Data Using PivotCharts

    Lesson 5: Inserting Graphic Objects

    • Insert and Modify Pictures and ClipArt
    • Draw and Modify Shapes
    • Illustrate Workflow Using SmartArt Graphics
    • Layer and Group Graphic Objects

    Lesson 6: Customizing and Enhancing Workbooks and the Environment

    • Customize the Excel Environment
    • Customize Workbooks
    • Manage Themes
    • Create and Use Templates

    Microsoft Excel 2010 Level 3

    Lesson 1: Streamlining Work flow

    • Update Workbook Properties
    • Create a Macro
    • Edit a Macro
    • Apply Conditional Formatting
    • Add Data Validation Criteria

    Lesson 2: Collaborating with Others

    • Protect Files
    • Share a Workbook
    • Set Revision Tracking
    • Review Tracked Revisions
    • Merge Workbooks
    • Administer Digital Signatures
    • Restrict Document Access

    Lesson 3: Auditing Worksheets

    • Trace Cells
    • Troubleshoot Errors in Formulas
    • Watch and Evaluate Formulas
    • Create a Data List Outline

    Lesson 4: Analysing Data

    • Create a Trendline
    • Create Sparklines
    • Create Scenarios
    • Perform What-If Analysis
    • Perform Statistical Analysis with the Analysis ToolPak

    Lesson 5: Working with Multiple Workbooks

    • Create a Workspace
    • Consolidate Data
    • Link Cells in Different Workbooks
    • Edit Links

    Lesson 6: Importing and Exporting Data

    • Export Excel Data
    • Import a Delimited Text File

    Lesson 7: Using the Web

    • Publish a Worksheet to the Web
    • Import Data from the Web
    • Create a Web Query

    Lesson 8: Structuring Workbooks with XML

    • Develop XML Maps
    • Import and Export XML Data

    Microsoft Excel 2010 Level 4

    Lesson 1: Manipulating Data Using Statistical and Lookup Functions

    • Forecast GDP Using Statistical Functions
    • Evaluate Sales Data Using Statistical Functions
    • Analyze Stock Data Using Statistical Functions
    • Mine Data Using the Lookup and Reference Functions

    Lesson 2: Analyzing Data Using Data Analysis Tools

    • Analyze Sales Data Using Descriptive Statistics
    • Analyze Time Series Data Using Exponential Smoothing
    • Analyze Data Using Regression
    • Identify the Beta Value of a Security
    • Analyze Sector Data Using Correlation and Covariance Matrices
    • Optimize a Stock Portfolio Using Solver

    Lesson 3: Working with Data Using Financial Functions

    • Develop an Investment Schedule Using Financial Functions
    • Make Investment Decisions Using Financial Functions

    Lesson 4: Examining Data Using Math Functions

    • Analyze Sales Data Using Math Functions
    • Calculate Stock Returns Using Math Functions
    • Aggregate GDP Data Using Math Functions

    Lesson 5: Manipulating Data Using Text and Information Functions

    • Manipulate Data Using Text Functions
    • Validate Data Using Information Functions

    Lesson 6: Working with Templates and Charts

    • Create Advanced Templates
    • Create Advanced Charts

    Lesson 7: Managing Data in Workbooks

    • Retrieve and Paste Data
    • Clean Data in Workbooks 

    Duration:




    Learning Materials:
     

    Prerequisites:

    What course next:


    Level 1 - 1 Day
    Level 2 - 1 Day
    Level 3 - 1 Day
    Level 4 - 1 Day
     

    All included

    Basic Windows skills »

    Any other Microsoft Office courses »
     



    Get a Quote today »
    Microsoft Excel 2010 Courses Content
    Excel 2010 Training - Level 1

    • Creating a Basic Excel Worksheet
    • Performing Calculations in an Excel Worksheet
    • Modifying an Excel Worksheet
    • Formatting an Excel Worksheet
    • Printing Excel Workbooks
    • Managing an Excel Workbook

    Excel 2010 Training - Level 2

    • Calculating Data with Advanced Formulas
    • Organizing Worksheet and Table Data
    • Presenting Data Using Charts
    • Using PivotTables, Slicers and PivotCharts
    • Inserting Graphic Objects
    • Enhancing Workbooks and the Excel Environment

    Excel 2010 Training Level 3

    • Streamlining Workflow
    • Collaborating with Others
    • Auditing Worksheets
    • Analysing Data
    • Working with Multiple Workbooks
    • Importing and Exporting Data
    • Structuring XML Workbooks

    Excel 2010 Training Level 4

    • Manipulating data using statistical and lookup functions
    • Analysing data using data analysis tools
    • Working with data using financial functions
    • Examining data using math functions
    • Manipulating data using text and information functions
    • Working with templates and charts
    • Managing data in workbooks
     

     

    Quick Search
    Register Here

    Fill in your details below and one of our career specialists will assist you with your study needs

    Sorry, your message could not be sent. Please check your details. Please complete all fields.

    Name

    Email

    Phone

    Location

    Message


    Thank you
    For your request, one of our career specialists will assist you with your study needs.

    It’s very fun and interesting. Love It!!

    Shaun2.jpg
    - Shaun Brown

    I will recommend MasterGrade IT to anyone that is serious about getting certification.

    zaheer1.jpg
    - Zaheer Isaacs

    Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

    rene1.jpg
    - René Leandro Borges

    I enjoyed doing the course in my own time!

    sadia.jpg
    - Sadia Abrahams

    Already Engaged.

    Thousands of companies around the world use and love our training every day.


    Meetup
    Meetup
    Meetup
    Meetup
    Meetup
    Meetup
    Meetup
    Meetup

    Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.