The Hidden Key excel Reporting And Charting everydayExcel Business Lab Pte Ltd
Price: AED 1,657

    Course details

    Managers and Executives who have to prepare monthly, weekly or daily dashboards, balance scorecards, KPI reports using data downloaded from systems. They must know how to format cells, auto-filter, sort, create a simple template and enter simple formulas (e.g. SUM) into the worksheet

    Learning Objectives

    Upon completion of the course, participants will be able to:

    • Apply useful built-in functions in Excel to pick up and compute the results automatically
    • Advanced skills and techniques to create charts and tables in Excel.
    • Making use of the special features in Excel to enhance users interactivity with the report.
    • Prepare impressive reports that get noticed.

    Course Outline

    • Create an Interactive Title for your report
    • Pulling Data from another Excel file using Advanced MSQuery techniques
    • Create Charts with 2 x-axes displaying 2 different measurements
    • Create a 2-in-1 chart
    • Using customized format for the axes, e.g. S$50K
    • Application of Advanced Formula such as INDEX and MATCH
    • Using Thermometer chart to compare current year performance with Prior year
    • Presenting the TOP 5 selling products WITHOUT using Pivot Table.
    • The hidden key to the Excel Camera for presentation

    Functions and formulas used

    • NESTED IF
    • INDEX
    • MATCH
    • SUMIF
    • SUMIFS
    • COUNTIF
    • COUNTIFS
    • VLOOKUP
    • Advanced MS Query
    • Dropdown list, etc.
    Updated on 08 November, 2015

    About everydayExcel Business Lab Pte Ltd

    everydayExcel Business Lab is a training company offering Professional Microsoft® Excel CThierses with a Business Perspective. They tailor-made Excel cThierses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resThierce, administration, business development, etc.

    See all everydayExcel Business Lab Pte Ltd courses
    Are you from everydayExcel Business Lab Pte Ltd ? Claim your course!
    Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or