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

Excel Essentials

Course Summary

Learn Excel the FUN way! By working through exercises along with the video tutorial.


  • +

    Course Syllabus

    • Getting Started
      • Using the Ribbon
      • Cheat Sheet PC 10
      • Getting Started
      • Ribbon Demo
      • Customize the Ribbon PC 10
      • Freeze Panes
      • Sorting
      • Filters
      • Paste Special
    • Formatting with Excel
      • Formatting Exercises Workbook
      • Formatting Fonts
      • Formatting Alignment
      • Formatting Numbers
      • Conditional Formatting
    • Formulas - Introduction
      • Handout Excel PC 2010 Introduction To Formulas
      • Formula Basics
      • Absolute Referencing
      • Named Ranges
      • More Functions
    • Formulas - Intermediate
      • Handout Excel PC 2010 Intermediate Functions
      • IF Statement And Nesting
      • Text Functions
      • Remove Duplicates
      • Vlookup
    • Drop Down boxes, Working with Tables, and Goal Seek. Cool tools.
      • Excel Tutorial 5 Tables And Validation
      • Data Validation
      • Find And Replace
      • Tables
      • Goal Seek
    • Pivot Tables - Introduction
      • Pivot Tables - Introduction
      • Intro to PivotTables
      • Build Simple PivotTables
      • Format PivotTables
      • Manipulate PivotTables
      • PivotTable Totals
    • Pivot Tables - Intermediate
      • Handout Excel PC 2010 Intermediate Pivot Tables
      • Multiple Data Points
      • Calculated Fields
      • PivotTable Maintenance
      • Slicers
    • Printing and Screen settings
      • Handout Excel PC 2010 Viewing And Printing Options
      • Viewing
      • Printing
      • Custom Views
      • Headers and Footers
    • Building Charts
      • Charting Exercise Files
      • Introduction to Charting
      • Build a simple chart
      • Formatting Charts
      • Configuring the X Axis
      • Configure Y axis
      • Data Labels and Data Tables


Course Fee:
USD 199

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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