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

Comprehensive Microsoft Excel

Course Summary

Discover how to use Microsoft Excel with an easy to follow tutorial series that focuses on project based learning.

  • +

    Course Syllabus

    • Excel Basics
      • Intro to Excel Tutorial
      • How to Configure Excel
      • How to Design and Format an Excel Spreadsheet
      • Sorting and Filtering Data in Excel
      • Text Formatting
      • Connecting Text Columns in Excel
      • Managing Tabs
      • How to Pull Data from Tabs in Excel
      • How to Use the Format Painter
      • How to Freeze the Top Row in Excel
      • How to Add a Header and Footer
      • How to Print an Excel Spreadsheet on One Page
    • Intermediate Excel Techniques
      • Excel Tips, Tricks and Shortcuts
      • How to Use Math Formulas
      • How to Use Formulas - Creating Sums
      • How to Create Tables Automatically in Excel
      • How to Round in Excel
      • How to Calculate Averages
      • How to Calculate Ages
      • How to Use Themes
      • Splitting Text Fields in Excel Automatically
    • Advanced Excel Techniques
      • How to Add and Manage Sparklines
      • How to Use Conditional Formatting
      • How to Use the Count Formula
      • How to Use If Then Statements
      • How to Add and Design Charts
      • Adding Comments
      • How to Create Financial Scenarios
      • How to Add SmartArt
      • How to Pull in Data from a Website into an Excel Spreadsheet
      • How to Create and Customize Pivot Tables

Course Fee:
USD 99

Course Type:


Course Status:



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
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