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

Microsoft Excel 2013 Intro and Intermediate Training

Course Summary

This course provides essential knowledge for new or inexperienced Microsoft Excel 2013 users, or aspiring "Excel Stars".

  • +

    Course Syllabus

    • Introduction to This Course and Microsoft Excel 2013
      • Course Introduction
      • What is Excel / Introduction to Basic Formulas
      • The Microsoft Excel 2013 Certification Exam (77-420)
      • Creating an Excel Workbook
      • Excel WorkSheets
      • Navigating Excel 2013
    • Inputting Data and Cell Formatting
      • Formatting a Cell (Ctrl+1)
      • Fill and Drag
      • Creating and Using Tables
      • Freeze Panes and Views
    • Formulas (Part 1)
      • MAX, MIN, SUM and AVERAGE Formulas
      • ROUND Formulas
      • LEFT, RIGHT and MID Formulas
      • COUNT Formulas
      • CONCATENATE Formulas
      • Absolute References
    • Formulas (Part 2)
      • IF Formulas
      • VLOOKUP and HLOOKUP Formulas
      • MATCH Formulas
      • INDEX Formulas
      • IFERROR Formulas
    • Inputting Data and Cell Formatting (Part 2)
      • NameBox
      • Inserting and Formatting Pictures
      • COPY and PASTE Types
      • Data Validation
      • Grouping Rows and Columns
      • Locking or Hiding Cell Contents
      • Charts
      • Sort and Filter
      • Conditional Formatting
    • Bonus Lectures
      • Developer Tab
      • ~ (Show Cell Contents)

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