About Course

Oops!

You don't have permission to view this page! Make sure you're logged in and try again, or contact support.

What Will You Learn?

  • In this course you will learn some of the basic features of how to create a report in Excel. We will dive into some of the most common functions used to create meaningful reports and then how to get these business measures in record time

Course Content

Before the Magic
Before we get into some of the cooler aspects of Excel and how to build reports in record time, let's review some of the more traditional methods and functions. These will include: * SUM * COUNT and COUNTA * SUMIF * Fixing Cell References * SUMIFS and COUNTIFS

  • Introduction
    05:55
  • Get the Exercise Demo File
  • SUM
    03:26
  • COUNT Methods
    01:56
  • SUMIF
    02:41
  • SUMIFS
    03:28
  • How to Anchor your Formula
    06:18

Student Ratings & Reviews

No Review Yet
No Review Yet