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 Beginners Training From Scratch

Course Summary

Learn to master Microsoft Excel with easy to follow step-by-step lessons using practical case studies and projects.


  • +

    Course Syllabus

    • Introduction & files
      • Course introduction
      • Pre-course survey
      • Course and Exercise files
    • Navigating Excel
      • Excel Terminology
      • Navigating the ribbon interface
      • Excel toolbars
      • The Excel file menu
      • Tips & Tricks
    • Working with Worksheets
      • Working with worksheets
      • Creating, moving and deleting sheets
      • Renaming sheets
      • Copying and moving sheets
      • Worksheet organisation
      • Formatting cells and worksheets
    • Number Formats
      • Introduction to number formats
      • Different number formats
      • Assigning number formats
      • Number format options
      • Custom number formats
      • Dates in Excel
      • Midway review and Exercise
    • Functions and calculations
      • Formulas introduction
      • Math calculations
      • Introduction to functions
      • Absolute vs relative references
      • Most commonly used functions
      • Section wrap-up and exercise
    • Charting
      • Charting introduction
      • Do you need to use a chart
      • Anatomy of a chart
      • Chart types
      • Creating a column chart
      • Creating a line chart
      • Creating a bar chart
      • Creating a pie chart and wrap-up
    • Course project
      • Project introduction
      • A look at what we will be making
      • Creating the data section
      • Creating the overview section
      • Creating the chart and conditional formatting
    • Course wrap-up
      • Course wrap-up and thanks!
      • Post course survey
    • Bonus content
      • Lookups (V & H lookups)
      • Named ranges - adding meaning to your formulas
      • Adding comments to your spreadsheets
      • Printing and exporting spreadsheets


Course Fee:
USD 25

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