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 2013

Course Summary

Online Excel training is designed to create a strong foundation for using the world's most popular business software.


  • +

    Course Syllabus

    • Essentials and Intro to Formulas and Functions
      • Introduction and the Ribbon
      • Interactive Guides
      • Navigating
      • QA Toolbar
      • More QA Toolbar Part
      • Formulas
      • Saving Files
      • Functions
      • Continued Formuli
      • Troubleshooting Issues
      • Compatibility Issues
      • Course Check List
    • Formatting, Spreadsheet Design, Page Setup and Printing
      • Fill Handle
      • Copying and Pasting
      • Auto-fill Series Formatting and Styles
      • Styles and Themes
      • Templates
      • Working with Worksheets
      • Copying Entire Worksheets
      • Custom View
      • Spell Check in Excel
      • Working with Large Worksheets
      • Split Screen
      • Printing
      • Page Layout View
      • Course Check List
    • List/Table Essentials and Charting
      • Flash Fill
      • Well Defined List
      • Sorting
      • Sort by Then
      • Formatting
      • Format as Table
      • Filtering
      • Multi-Field Filtering
      • Remove Duplicates
      • Inserting Automatic Subtotals
      • Column Line Charts
      • Pie Chart
      • Formatting Charts
      • Chart Templates
      • Recommended Charts and Quick Analysis Tools
      • Printing Charts
      • Sparklines
      • Review
      • Course Check List
    • Importing Data, Pivot Tables, Protecting and Linking Data
      • Importing Data from Sources
      • Importing Database File
      • Pivot Tables
      • Custom Pivot Tables
      • Advanced Pivot Tables
      • Pivot Table Exercise
      • Formatting Pivot Tables
      • Slicer Tool
      • Pivot Charts
      • Filtering Charts
      • Data Validation
      • Rules
      • Conditional Formatting
      • Advanced Conditional Formatting
      • Manage Rules of Conditional Formatting
      • Conditional Formatting Data Validation
      • Protecting Worksheets
      • Comments
      • Printing Comments
      • Linking Data Between Worksheets
      • Course Check List
    • Creating Functions
      • Named Ranges
      • Logical Functions
      • If Functions
      • Nested Functions
      • Lookup Functions
      • V Lookup
      • Database Function Sumif
      • Database Function Averageif
      • Database Function Sumifs
      • If Error Functions
      • V Lookup Range
      • Date Functions
      • Course Check List
    • Advanced Tools
      • Consolidate Data
      • Consolidate with Different Layouts
      • Intro to Goal Seek Tool
      • Goal Seek Tool
      • Installing Solver Tool Add-In
      • Solver Basic Sheet
      • The Solver Tool
      • PMT Data Table Worksheet
      • Data Table Command
      • Two Variable Data Table
      • Scenario Manager
      • Adding Developers Tab
      • Recording a Macro
      • Running Your Macro
      • Recording Macros with Relative References
      • Record a Formatting Macro
      • Better Formatting Macro
      • Add Form Buttons
      • QA Macro Buttons
      • Introduction to Skydrive
      • Skydrive
      • Course Check List


Course Fee:
USD 59

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