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.