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
Make Money from Home: How to Build an Online Business
Learn all the basics of online entrepreneurship while building a real business with your own portfolio of websites.
Programming 101
Comprehend basic foundational knowledge of hardware, networking, programming and licensing.
AngularJS For Beginners
Create Web Applications, Create Hybrid Apps for Android & iOS,Create single page applications
Paul and His Letter to Philemon
Prof. N.T. Wright compares Paul's letter to Philemon to a letter of Pliny showing powerful countercultural differences.
Security Awareness Campaigns (Lite)
This is the "lite" version of Security Awareness Campaigns and is meant to give you an idea of the full course.
About the instructors
- 4.41 Calificación
- 53718 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.41
Course Rating
Reviews
Thiago Hoffmann
10-07-2020
It was a nice and fast tutorial on some basic concepts that are good to know.
John Cunningham
10-07-2020
nice tips
Alaa AlHajri
10-07-2020
thank you valuable information
Shabaz
08-07-2020
short and precise