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

10 Things you didn't know about Excel - but you should!

Course Summary

Learn useful features and latest tricks for Excel 2010/2013 to create better workbooks in less time.


  • +

    Course Syllabus

    • Work FASTER and avoid ERRORS at the same time.
      • The Autofill Feature - you think you know it, but there is more to it!
      • Cell and Range names to simplify creating formulas
      • Add Range Names
      • Edit and Delete Range names
      • Use Range Names in formulas
      • Watch Formulas that are not on the same screen - and see what happens!
      • How to check if your complex formulas work properly!
      • Customize Formula Options to specify how formulas are calcuated and more!
      • Section Quiz
    • Customize Ribbon and Quick Access Toolbar
      • Save some clicks, by place your often used commands in the Quick Access Toolbar
      • Customize the Ribbon to your needs.
    • Make your Workbooks look GREAT
      • Apply Cell Styles instead of formatting each cell on its own.
      • Understanding Sparklines - will add value to your data when used wisely!
      • Section Quiz
    • Sharing workbooks with others is much more than send a mail with an attachment.
      • You use spell check in Word - start using it in Excel as well.
      • Add Comments to guide others through your workbook.
      • You recieve workbooks from your team - Merge Workbooks when you can!
      • Consolidate Data from multiple workbooks into one.
      • Avoid Excel messages about "do you trust this workbook?" in the Trust Center
      • Secton Quiz
    • Useful functions, we do not see often!
      • Automate analyzing data with logical functions.
      • Counting made easy - Count(), Counta() and Countif().
      • This is tricky but cool (HLookup/VLookup), helps you find data based on criteria
      • Text Manipulations (Concatenate, &)
      • Section Quiz
    • Manage Large Workbooks and Multiple Workbooks without getting lost.
      • Managing Large Workbooks - now hassle free!
      • Format Worksheet Tabs - red for input sheets, blue output/reports, or ....?
      • Manage Worksheets with ease.
      • Manage the View of Worksheets to make managing larger workbooks easier!
      • How to work with multiple workbooks.
      • Section Quiz
    • The advatages of organizing data in a table. Yes - a table within Excel!
      • The basics: Create and Modify Tables
      • Sort Data in Tables - one of the advantages working with tables in Excel
      • Filter Data with the Auto Filter - easy as 1-2-3 with tables in Excel!
      • Filter Data with the Advanced Filter - only possible with tables in Excel.
      • The "Total Row" helps you to calculate SUM, Average, and Count with one click!
      • Section Summary
      • Section Quiz
    • Remove Duplicates
      • Every data collection has duplicates - learn how to remove them.
    • Pivot Tables - Analyse your data like never before!
      • Analyzing Data with Pivot Tables
      • Create a Pivot Table - first steps
      • Advanced Field Settings - make your Pivot Table more readable.
      • Slicers - make filtering easy for everyone
      • Analyzing Data by using a Pivot Chart - adds a new perspective to the data.
      • Section Summary
      • Pivot Tables Quiz
    • Automatically update data from the web like exchange rates, stocks and more.
      • Create a WebQuery


Course Fee:
USD 47

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