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
Kindle Marketing: Ninja Tactics To Explode Your Amazon Sales
Copy And Paste My Secret Kindle Marketing System To Skyrocket Your Sales And Boost Your Income!
Baseball Database Queries with SQL and dplyr
Explaining the relationship between SQL and dplyr with baseball examples.
Certified Public Accountant Tax Preparation Tutorial
A tutorial on how to do Basic Tax Preparation
Power BI Gaming Dashboard for Beginners
Step by step development of Power BI Dashboard
Learn Statistical Data Analysis with Python
Perform Statistical Data Analysis Techniques with the Python Programming Language. Practice Notebook included.
About the instructors
- 4.51 Calificación
- 81969 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.51
Course Rating
Reviews
Gaurav Kanojia
28-05-2023
amaing
Alok
13-05-2023
great ! Thanks
Melody Sager
12-05-2023
I have been using Excel for years and still learned quite a few useful tips! Looking forward to applying them in my next project. Thank you for providing this free tutorial.
Ayan Sinha
05-05-2023
Good for beginners
Rachell Paguirigan
28-04-2023
Its good to know some basics that I only encountered here. Great presentation. Thank you!