Toolbox: Excel – Basic
Day 1
Introduction

Toolbox: Excel – Basic

Free

About this course

Description

The idea of working with business data gives you a squeezy feeling and the word “excel” makes you hope this has nothing to do with you? Still have to or want to work with it? Here is help!

What you’ll learn

You will learn about the following topics and apply your new knowledge during the course by solving small exercises. You will leave the course with detailed documentation that will help you remember. At the end of this fun intro, you will be a master of the following topics:

  • Formatting and customizing the ribbon
  • Simple mathematical and statistical functions, e.g. sumproduct, sumif(s) & countif(s)
  • Shortcuts
  • Logical functions (if, and, or)
  • Error analysis and solving
  • Vlookup
  • Pivots

Target Audience

You have a very basic understanding of excel and would like to learn how to be more efficient with basic analyses? Then this is your course!

Register for this Course


Syllabus

Day 1
Introduction

Formatting and customizing the ribbon Simple mathematical and statistical functions, e.g. sumproduct, sumif(s) & countif(s) Shortcuts Logical functions (if, and, or) Error analysis and solving Vlookup Pivots

Members

Our course begins with the first step for generating great user experiences: understanding what people do, think, say, and feel. In this module, you’ll learn how to keep an open mind while learning.

Total numbers of students in course