- Introduction
- Text to Column
- Flash Fill
- Record a Macro
- Group Sheets
- Delete Blanks
- Remove Duplicates
- Auto Sum
- Fill a Range
- 3D Sum
- Advanced Filter
- Bonus: Conditional Formatting
What you'll learn
- At the end of the course you will be familiar with and be able to use various useful Excel features that will help you save time and effort in your work.
Description
In this course we will learn about some awesome Excel features and how to use them with some examples commonly encountered by every analyst.
- Text to Column
- Flash Fill
- Recording a Macro
- Grouping Sheet
- Deleting Blank Rows
- Remove Duplicate Data
- Auto Sum
- Filling a Range with Ctrl + Enter
- 3D Sums
- Advanced Filters
Bonus: Conditional Formatting
These tools should be in every analysts toolbox and will save you a lot of time and effort if you know how to use them should the need arise.
Other Courses

Excel VBA[第0弾]ゲームでわかる、マクロVBAプログラミング超入門~作りながら「楽しい!」を実感する2時間講義
延べ3,000名が学んだ人気のマクロVBA講座シリーズの「番外編」がついに登場!ゲームを作りながらマクロVBAに入門できるエントリーコース。

Curso de Python 3.11: Aprende Desde Cero a Pro 2023 Parte 4
Aprende Como un Profesional Python 3.11.0 el Lenguaje de Programación Más Demandado del Mundo

Parenting course on how to help children learn English fast
English reading, writing and vocabulary learning activities for parents to practice with their kids

Iniciación al Mindfulness + Primeras Prácticas en Meditación
· Descubre una Nueva Habilidad · Aprende los Pilares de la Atención Plena · Haz tus Primeras Prácticas Mindfulness ·
About the instructors

- 4.47 Calificación
- 79899 Estudiantes
- 1 Cursos
John MacDougall
Microsoft Excel MVP
I've worked in Canada, Ireland, Luxembourg and the UK as an actuary for 10 years where I discovered my passion for using Excel to find the easiest solutions to my work problems. In 2016 I started an Excel websites which has since grown over a 50k following on Facebook. My interest has shifted to online technology and marketing so in 2017 I started a new career at an ad operations start up.
Student feedback
Course Rating
Reviews
not sure about grouping sheets, but all the other lessons taught me at least something that i didn't know before, that looks useful. and i've used Excel since it came out and considered myself an expert.
Being an analyst myself, I can already imagine myself using these in my workspace which is gonna help me in my daily tasks.