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 With Ease: Master Excel Spreadsheets

Course Summary

This course is a Microsoft Excel tutorial that takes your Excel skills to the next level. It is an Excel training class.

  • +

    Course Syllabus

    • A Few Things Before We Begin
      • Welcome!
      • How To Learn Excel In This Course
    • First Things First
      • Microsfot Excel User Interface
      • How To Enter Data In Excel
      • How To Use Fill Series (The Fill-handle Tool)
      • How To Move Around An Excel Spreadsheet And Select Cells
      • Easy Direct Formatting In Excel
    • Formulas - The Power Of Excel
      • Easy Excel Formulas
      • Easy Excel Functions Basics
      • Relative And Absolute Cell References In Excel
      • Using AutoSum In Excel
      • Easy Text Functions
    • Working With Dates
      • Excel TODAY and NOW Functions
    • Logical Functions
      • Logical IF Function Introduction
      • Excel Logical Functions: AND, OR
      • Using Logical Functions IF, AND, OR Together
      • Exercise Using IF AND SUM (courtesy of Björn Már Sveinbjörnsson)
    • Conditional Statistical Functions
      • SUMIF and SUMIFS: Conditional Sum in Excel
      • AVERAGEIF and AVERAGEIFS: Conditional Average
      • COUNTIF and COUNTIFS: Conditional Count
      • COUNTIFS Conditional Number Counting (courtesy of Björn Már Sveinbjörnsson)
    • VLOOKUP Function Tutorial
      • VLOOKUP Function Introduction
      • Fill Data With VLOOKUP Function
      • Excel VLOOKUP With Approximate Match
      • VLOOKUP With A Named Range As Table Array
      • Use Excel Table In VLOOKUP
    • Loan Payment Calculations With PMT (Newly Added)
      • Monthly Loan Payment With PMT Function
      • Goal-Seek Analysis Tool
    • A Few More Important Things
      • More on Formatting
      • Printing in Excel
      • Thank You!

Course Fee:
USD 39

Course Type:


Course Status:



1 - 4 hours / week

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

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