Introduction
- 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.
The University of Sheffield
Other Courses
Business Motivation Mastery: Motivation For Your Business!
By the end of this course you will be inspired and motivated to make some changes in your business for the better.
SOLIDWORKS Course: Turn 2D Sketches into 3D Models
Learn Creating 3D Models for parts, assemble different parts and make motion between them.
Productivity Secrets - The Focus Mastery Class
Learn How to stay on track long term with your goals and improve short term concentration so you start to get stuff done
Pass The California Police Academy Written Examinations
StudiGuide for the California Police Academy: Written Examination Tips
Setup OS X development environments
This course covers the easiest way to setup multiple environment stacks. Such as Java, Ruby, DB's and more
About the instructors
- 4.46 Calificación
- 68592 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
4.46
Course Rating
Reviews
Nguyen Thanh Le
26-07-2021
I have not known Flash Fill, Auto Sum, Fill a Range before this course
Anwar Mansuri
24-07-2021
Its really a good stuff