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

Fundamentals of Excel for Business

Course Summary

A gentle but detailed introduction to the effective use of Microsoft Excel in business


  • +

    Course Syllabus

    • Functions and cell references
      • Introduction to basic functions
      • Cell references in Excel
      • Vlookup with exact match
      • VLookup with fuzzy or approximate match
      • Naming cell ranges
    • Charts
      • Charts - basics
      • Charts with clustered columns
      • Pie-charts
      • Adding chart titles and axes titles
      • Charts - colors and trendline
      • Charts - data labels
    • Managing tables with data
      • Conditional formatting
      • Creating a table
      • Filtering a table
      • Advanced fiiter
      • Freezing rows and columns
      • Sorting a table
      • Structured reference table
      • Subtotals
    • Pivot tables
      • Pivot table basics
      • Pivot table - report filter
      • Calculated fields
      • Calculated values
      • Label filters
      • Slicer
      • Pivot chart
    • What-if analysis
      • One variable data table
      • Two variable data table
      • Create scenarios
      • Goal-seek
    • Logical functions
      • IF function
      • SUMIF function
      • SUMIFS function
      • Average if
      • Database functions
      • Nested IF
      • IF with AND
    • Lookup and reference
      • Matching in a table
      • Matching with index
    • Worksheets
      • Group worksheets
      • Data across worksheets
      • Worksheet hyperlinks
      • Conclusion


Course Fee:
USD 49

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