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 Basic Training Course

Course Summary

Master Basic Excel 2013 Features. Get a solid foundation level understanding of Excel 2013 - formulas & functions


  • +

    Course Syllabus

    • Overview
      • Overview
    • Getting Started
      • Opening Excel
      • Familiarity with excel interface and Ribbons
      • Surfing an excel worksheet and How to use HELP in MS Excel
    • Case Study
      • Case Study
      • XYZ Company Basic Excel Case Study
    • Data Entry
      • Data entry in excel
    • Populating the Case Study in Excel
      • Populating the Case Study in Excel
      • populating case study in excel (without solution)
      • populating case study in excel (with solution)
    • Calculations
      • Calculations
      • Calculations (without solution)
      • Calculations (with solution)
    • Formulas
      • Formulas - part 1
      • Formulas - part 2
      • Formulas (without solution)
      • Formulas (with solution)
    • Formatting
      • Formatting Number formats
      • Formatting - Number Formats (without solution)
      • Formatting - Number Formats (with solution)
    • Formatting Table formats
      • Formatting Table formats
      • Formatting - Table Formats (without solution)
      • Formatting - Table Formats (with solution)
    • Updating a Calculation
      • Updating a Calculation
      • updating a calculation (without solution)
      • updating a calculation (with solution)
    • Percentages & Absolute References
      • Percentages and Absolute References
      • percentage & asbsolute refernces(without solution)
      • percentage & asbsolute refernces(with solution)
    • Conditional Formatting
      • Conditional Formatting
      • Conditional formatting (without solution)
      • Conditional formatting (with solution)
    • IF Function
      • IF Function
      • if function (without solution)
      • if function (with solution)
    • COUNTIF
      • COUNTIF
      • count if (without solution)
      • count if (with solution)
    • SUMIF
      • SUMIF
      • SUMIF (without solution)
      • SUMIF (with solution)
    • Graphs & Charts
      • Graphs and Charts Part 1
      • Graphs and Charts Part 2
      • Graphs and Charts Part 3
      • Graphs & Charts (without solution)
      • Graphs & Charts (with solution)
    • Pie Chart
      • Pie Chart
      • Create Pie Chart (without solution)
      • Create Pie Chart (with solution)
    • Sorts
      • Sort function
      • Sort (without solution)
      • Sort (with solution)
    • Filter Function
      • Filter Function
      • Filter (without solution)
      • Filter (with solution)
    • Pivot table
      • Pivot table Part 1
      • Pivot table Part 2
      • Pivot table (without solution)
      • Pivot table (with solution)
    • Freeze & Split
      • Freeze and Split
      • Freeze panes (without solution)
      • Freeze panes (with solution)
      • Split (without solution)
      • Split (with solution)
    • Presentation
      • Table Formats
      • Presentation table format (without solution)
      • Presentation table format (with solution)
      • Indents and Formatting Charts
      • Indents and Formatting Charts (without solution)
      • Indents and Formatting Charts (with solution)
    • Print
      • Printing the Worksheet
      • Print Layout
      • Printing the Worksheet (without solution)
      • Printing the Worksheet (with solution)
      • Print Layout (without solution)
      • Print Layout (with solution)
    • Shortcuts
      • Shortcuts Part 1
      • Shortcuts Part 2
      • Shortcuts Part 3
      • Shortcuts Part 4
      • Shortcuts Part 5
      • Shortcuts Part 6
      • Excel Shortcuts
    • Common errors
      • Common errors


Course Fee:
USD 99

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