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
CFA® Level 1 Quantitative Methods (2022) - Part 1
Master Quantitative Methods with WSN CFA® Level 1 Crash Course | Cover ALL learning outcome (LOS) with video lectures!
CCNA OSPF troubleshooting: Cisco CCNA and ICND2 exam prep
Prepare for the OSPF exam topic in the CCNA 200-125 or ICND2 200-105 exams. You need to learn OSPF for your exam!
Web development Learn Html in 2 hours with certification
Learn complete html with certification in just 2 hours and boost your skills for web development
Build your first React JS Application
Learn the most popular JavaScript framework on the web by building your first React web app
Tableau Fundamentals for Aspiring Data Scientists
Learn Tableau from scratch, create rich visualization and share with others
Google Cloud Platform MasterClass : 4 GCP Certification in 1
Google Cloud Certified Associate Engineer, Google Cloud Professional Architect, GCP Cloud Data & Security Engineer
About the instructors
- 4.63 Calificación
- 85689 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.63
Course Rating
Reviews
Kelly Dingman
08-11-2023
Easy to understand and follow.
Accounting
21-10-2023
So far pretty basic knowledge but a great refresher.
Juliet Britanico
18-10-2023
very informative