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

Fast moving, easy to follow Microsoft Excel 2010 tutorial from the the e-learning experts!

  • +

    Course Syllabus

    • Introduction and Auxiliary Materials
      • Introductory Lecture
      • ClipStart Guide for Excel
    • The Basics of Workbooks and Worksheets
      • Getting Started
      • Exploring Ribbon Tabs
      • Working with Backstage View
      • Understanding Worksheet Navigation
      • Adding, Deleting and Renaming Worksheets
      • Hiding and Unhiding Worksheets
      • Moving, Copying or Coloring Worksheets
      • Working with Templates
      • Closing Excel
      • Entering Data
      • Exploring Navigation Shortcuts
      • Inserting Different Data Types
      • Modifying Cell Comments
      • Using the Clipboard Pane
      • Understanding AutoFill
      • Creating Series with AutoFill
      • Working with AutoComplete
      • The Basics Quiz Part One
      • The Basics Quiz Part Two
    • Formatting and Conditional Formatting
      • Exploring the Font Group
      • Using the Font Dialog Box
      • Exploring the Alignment Group
      • Using the Alignment Dialog Box
      • Understanding the Number Group
      • Using the Number Dialog Box
      • Adjusting Rows and Columns
      • Using Hide and Unhide
      • Formatting a Data Bar
      • Configuring Data Bar Rules
      • Formatting with Color Scales
      • Formatting with Icon Sets
      • Configuring Highlight Cells Rules
      • Working with Top/Bottom Rules
      • Manage Multiple Conditional Formatting Rules
      • Using Cross Sheet Conditional Formatting
      • Working with Conditional Formatting in Ranges with Errors
      • Groups, Dialog Boxes, Rows and Columns Quiz
      • Formatting and Conditional Formatting Quiz
    • Working with Formulas and Functions
      • Creating Formulas
      • Understanding Functions
      • Using AutoSum
      • Exploring Common Functions
      • Understanding Status Bar Results
      • Exploring the Function Library
      • Using the Insert Functions Command
      • Inserting Logical Functions
      • Working with Text Functions
      • Using Date Functions
      • Working with Formulas and Functions
    • Sorting and Filtering Data
      • Exploring Sort and Filter Commands
      • Preparing to Use Custom Sort
      • Performing a Color Custom Sort
      • Using Multiple Level Custom Sorts
      • Exploring Data Filters
      • Filtering Multiple Columns
      • Working with Subtotals
      • New Table Features
      • Using Search Features
      • Sorting and Filtering Data
    • Worksheet Protection and Various View Options
      • Protecting Your Data
      • Modifying Workbook Protection Settings
      • Protecting Cells in a Workbook
      • Protecting a Workbook Window
      • Understanding Protected View
      • Requiring Protected View
      • Exploring Worksheet Views
      • Using Zoom Controls
      • Working with Freeze Panes
      • Splitting the Worksheet Views
      • Arranging Worksheet Views
      • Worksheet Protection and Various View Options
    • Working with Illustrations and Charts
      • Using Illustrations
      • Formatting Pictures
      • Formatting Shapes
      • Adding SmartArt into Worksheets
      • Adding Pictures in SmartArt
      • Exploring Charts
      • Create a Simple Chart
      • Customizing Text in Charts
      • Formatting Chart Components
      • Working with Illustrations and Charts
    • Printing, Proofing and More
      • Customizing Print Options
      • Scaling Page Dimensions
      • Modifying Gridlines and Headlines
      • Creating Headers and Footers
      • Printing Titles
      • Using Proofing Tools
      • Printing, Proofing and More
    • Advanced Excel Features
      • Renaming a Cell
      • Renaming Cell Ranges
      • Using Name Manager
      • Working with Absolute References
      • Using a Named Cell within a Formula
      • Understanding PivotTables
      • Create a Simple PivotTable
      • Update Your PivotTable
      • Understanding the Slicer Tool
      • Formatting the Slicer Tool
      • Customizing PivotCharts
      • Creating Sparklines
      • Modifying Sparklines
      • Inserting Sparklines from Data Ranges
      • Saving to Excel WebApp
      • Logging in to Excel WebApp
      • Modifying Excel WebApp Documents
      • Viewing an Excel WebApp Document Version History
      • Exploring Excel WebApp Menu Features
      • Hiding the Ribbon
      • Customizing the Ribbon
      • Advanced Excel Features Quiz Part One
      • Advanced Excel Features Quiz Part Two
    • Additional Training Clips
      • VLookup

Course Fee:
USD 49

Course Type:


Course Status:



1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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