MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Learn Microsoft Excel 2010

Course Summary

Get to grips with Excel - create spreadsheets that work! Learn what you want when you want.


  • +

    Course Syllabus

      • Introduction
      • Demonstration Files - Download these to work alongside me
    • Getting Started
      • Starting Excel
      • The Excel Window
      • The Ribbon
      • The Quick Access Toolbar
      • The Alt Key
      • Customise the Ribbon
      • Create your own Ribbon
      • The Backstage Menu
      • Excel Options
      • Exercise - Customise your screen
      • Getting Started
    • Editing in Excel
      • Adding text and numbers to your worksheet
      • Number formats
      • Selecting text and the Mouse
      • Formatting text
      • Formatting Numbers
      • Merge Centre and Resize Columns
      • Exercise - Formatting
      • Format Painter
      • Insert Columns and Rows
      • Cut Copy and Paste
      • Moving around
      • Different Views of your Worksheet
      • Saving your workbook
      • Printing in Excel
      • Save in different formats and versions
      • Email from within Excel
      • Exercise - Printing
      • Editing in Excel
    • Automatic features
      • Auto Fill - automatically copy a list
      • Create a custom list
      • Automatically add up a column of numbers
      • Copy a formula using autofill
      • Automatic Features
    • Creating Formulae
      • Create simple formula
      • Average Min Max
      • Absolute Cell References - fixing part of your formula
      • Exercise - Absolute Cell References
      • Formula
    • Sort and Filter
      • Sort Data
      • Sort on more than one level
      • Filter Data
      • Sort and Filter
    • Format as a Table
      • Format as a table
      • Remove formatting convert to range
      • Calculated Columns
    • More Formatting Options
      • Borders and Shading
      • Conditional Formatting & Duplicate values
    • Analyse Data
      • Subtotals - get subtotals of groups of data in a flash
      • Exercise - Sort Filter and Conditional Formatting
      • Create a Pivot Table
      • Pivot Table Design
      • Update a Pivot Table
      • Slicers
      • Pivot Charts
      • Exercise - Pivot Tables and Pivot Charts
      • Analyse Data
    • Conditional Processing
      • If Statements
      • Nested IF Statements


Course Fee:
USD 125

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top