Toolbox: Excel – Intermediate
Free
About this course
Description
Frequently working with data in excel, you feel that there should be a way to be more efficient? Curious to expand your list of formulas and tricks? We are here to help you.
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:
- Hlookup
- Indirect
- Index-Match
- Text functions
- Basics of model / report building
Target Audience
You feel comfortable with the excel basics (see basic analyses), but would like to shift into second gear? This is your course!
Register for this Course
Syllabus
Day 1
Introduction
Hlookup Indirect Index-Match Text functions Basics of model / report building
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.