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
Crash Course: Virtualization with VMWare Fusion 8.0
Gain the knowledge of Virtualization and why you should learn how to properly use VMWare.
Become Awesome at Everything ROBLOX in 1 Hour
You will learn everything from getting started to Earning TONS of Robux and be able to start in less than one hour!
HDR Image-Based Lighting in Blender
Watch this crash course and master the complete HDR image-based lighting workflow, 100% Blender
Service Cloud Exam: Contact Center Industry Knowledge
A course to prepare for the Industry Knowledge section of the Service Cloud Consultant Certification Exam
Blockchain for Healthcare
How blockchain technology has the potential to improve the cost, quality, and value of healthcare.
About the instructors
- 4.37 Calificación
- 44162 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.37
Course Rating
Reviews
Saksham
08-04-2020
Its good
Cathy Stanczak
08-04-2020
Yes, quick easy useful functions of Excel everyone needs to know.
Surbhi Gupta
08-04-2020
This training helped to learn something new!
Asmit Thapa
09-04-2020
Yes it was good way of learning and tons of ticks to solve the problems.