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

Ultimate Excel: become an Excel guru in easy, bitesize steps

Course Summary

Become an Excel master and learn all the best tricks, from beginner through to advanced, in bitesize lessons


  • +

    Course Syllabus

    • Add numbers in Excel
      • Using Excel to add numbers
      • The SUM function
      • The SUMIF function
      • A brief reminder for adding numbers
      • Test yourself
    • Basic calculations in Excel
      • Learn to add, subtract, multiply, divide
      • Using built-in functions to save time
    • Operator order in Excel
      • Operator order in Excel and what that means
    • More complex formulas in Excel
      • Learn how to create more complex formulas
    • Basic calculations: Quiz
      • Test yourself: Basic calculations
    • Creating a graph (chart)
      • Create a chart (graph) that's recommended for your data
      • How to create pie, bar, and line charts
      • Customize it to make it look exactly how you want
      • What is a combo chart and how to create one
      • How to copy a chart to another worksheet in the same or a different workbook
    • Freeze or lock panes
      • How to freeze panes
      • Freezing panes in detail
    • Cell references
      • The basics of cell references
      • Copying formulas with references
    • Working with TIME
      • Adding time
      • Subtracting time
    • Averaging a group of numbers
      • How to average a group of numbers
      • AVERAGEIF function
      • Weighted average
    • Sort and filter data
      • Sort and filter data quickly
      • Sorting things other than numbers
      • Using the AutoFilter
      • Using the Advanced Filter
    • Conditional Formatting
      • Using conditional formatting
      • Conditional formatting and dates
      • Conditionally formatting text
      • Copy and remove conditional formatting
      • Take conditional formatting to the next level
      • Using formulas to apply conditional formatting
      • How to manage conditional formatting
    • VLOOKUP
      • VLOOKUP: When and how to use it
      • The nuts and bolts of VLOOKUP
      • Look up values on a different worksheet
      • Copy a VLOOKUP formula
    • Advanced IF functions
      • IF function refresher
      • Nested IF functions
      • IF used with AND and OR
      • COUNTIF and SUMIF
      • AVERAGEIF and IFERROR
    • Using Dropdown lists
      • Dropdown lists
      • Dropdown list settings
      • Input and error messages
      • Managing dropdown lists
    • Working with macros
      • Work with macros
      • Editing a macro
      • Saving a macro
      • Assigning a button to a macro


Course Fee:
USD 47

Course Type:

Self-Study

Course Status:

Active

Workload:

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