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 and Business Analytics Part 2 - Sales Reporting

Course Summary

Learn Excel as its used in business, by creating sales and margin reports with pivot tables and charts.

  • +

    Course Syllabus

    • Course Introduction
      • Course Introduction
      • Meet the Instructor
      • Course Map and Pre-Requisites
    • Basic Business Concepts
      • Business Basics
      • The Return Credit Memo
      • Credit Memos
      • Margin Calculations
      • Margin Calculation
      • Reporting by Groups
      • Downloading Practice Files, Homework, and Scripts
      • Section 2: Business Basics
    • Excel Functions
      • Introduction to Excel Functions
      • Review of Formatting
      • The =if() function
      • Nested if Functions
      • Tables and Names
      • The vlookup Function
      • Troubleshooting vlookup Functions
      • Review of Excel Functions
      • Excel Functions
    • Pivot Tables
      • Introduction to Pivot Tables
      • Pivot Table Layouts and Totals
      • Filters and Slicers
      • Pivot Table Calculated Formulas
      • Pivot Table Relationships and Data Models
      • Review of Pivot Tables
      • Pivot Tables
    • Data Visualization
      • Introduction to Data Visualization
      • Pie Charts
      • 3D Column Charts
      • Advanced Charting Features
      • Alternative Methods for Charts, and Scatter Plots
      • Conditional Formatting
    • Presenting the Results
      • Introduction to the Written Report
      • Page Setup
      • Print Functions
      • Some Print Examples
      • Copying Charts and Tables to Microsoft Word
      • The Written Report
    • Course Overview
      • Course Overview and Additional Practice Session
      • Additional Practice Material - Final Quiz

Course Fee:
USD 39

Course Type:


Course Status:



1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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