- 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.
Other Courses
![Netcurso-astronomy-for-vce-physics](https://img-c.udemycdn.com/course/480x270/135420_f900_6.jpg)
Astronomy for VCE Physics
Learn the VCE Physics Astronomy course through instruction, simulations and your own observations of the night sky.
![Netcurso-photoshop-retouching-the-dog](https://img-c.udemycdn.com/course/480x270/91494_fadc_7.jpg)
Adobe Photoshop Animal Retouching
Photoshop Dog Retouching - Become an expert in Retouching your best friends image - Without prior Photoshop knowledge.
![Netcurso-the-complete-guide-to-ios-7-ipad-edition](https://img-c.udemycdn.com/course/480x270/84048_8753_7.jpg)
The Complete Guide to iOS 7 - iPad Edition
A Go-To resource for any iPad question you have.
![Netcurso-local-development-environments-for-web-design](https://img-c.udemycdn.com/course/480x270/118550_a19c_5.jpg)
Local Development Environments for Web Design
How to install and configure a local dev environment using LAMP stacks.
![Netcurso-tony-friz-ios-sdk-7-bootcamp](https://img-c.udemycdn.com/course/480x270/119000_2988_9.jpg)
iOS SDK 7 Bootcamp
A 10 video-tutorial series that takes absolute beginners with no iOS development experience and teaches them the basics.
About the instructors
![Netcurso-Instructores](https://img-c.udemycdn.com/user/100x100/29137852_f46b_5.jpg)
- 4.62 Calificación
- 90700 Estudiantes
- 2 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
Course Rating
Reviews
It is quite educative
Useful small things shown in this small course! I thought there won't be much new function for me but to be honest, I knew only a few of them. Great course, thanks!
hgvg
great course and really very informative ofcourse every analyst and excel professions should take this course.