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
2019 build a translate online app with vue js
2019 build a translate online app with vue js
Complete Microsoft Excel Course - Learn From Scratch
Complete Microsoft Excel Course. Go From Beginner To Advanced In Microsoft Excel.
Blogging Insight To Learn How To Write Better Blog Posts
This course provides blogging tips for anyone to learn how to write better blog posts.
About the instructors
- 4.44 Calificación
- 38756 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.44
Course Rating
Reviews
Annie Wong
16-02-2020
very useful and easy to learn
Achraf Jaghiri
12-02-2020
this is a good course for the ones who wants to know the basics of the EXCEL.
Aniket Ghonge
11-02-2020
Thank you. These are some interesting trick in excel that I have learned today.
Kelly Minton
09-02-2020
Short sweet to the point and not a lot of extra verbiage, just what he was doing and why he was doing it.
David Iverson
09-02-2020
Narration was a bit monotone so sometimes hard to follow overall great information
Toby Egwuatu
09-02-2020
Excellent