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 - For everyday Excel Users. Take my Excel training!

Course Summary

Excel course: 30 Day Money Back Guarantee. FREE Excel preview lectures. Try the Excel lectures and read course bio below

  • +

    Course Syllabus

    • Welcome- Introductory lecture!
      • Introductory video
    • Report basics part 1- How to do bullet points and new lines in the same cell
      • How to structure Excel reports!
    • Report basics part 2- How to capitalise/de-capitalise your text- quickly
      • To Capital or not Capital? That is the question:)
      • Making teXt...Proper
      • Report basics part 2 quiz!
    • Cleaning data- How to substitute characters in text
      • Substitute and more!
      • Cleaning data quiz!
    • Automating reports- How to join formulas and text
      • One symbol to rule them all:) & !
      • Automating reports quiz!
    • How to calculate working days
      • Working out the difference between two dates!
      • Adding workings days to a date!
      • Working days quiz!
    • Data basics 1- How to figure out formulas and fix errors
      • Audit that formula!
      • Data basics 1 quiz!
    • Data basics 2- How to sum a range of values based on one or more criteria
      • Sum this, sum that!
      • Data basics 2 quiz!
    • Data basics 3- How to retrieve a value based on a lookup of another value
      • Lookup this!
      • Data basics 3 quiz!
    • Wrap up!
      • The end?

Course Fee:
USD 70

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Telecommunications 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