You will learn the fundamentals of working with data, which really is the whole point of Excel.

I will be creating a spreadsheet during the course that you can download. The idea is that you work along with me, then you can compare our spreadsheets. This is the very best way to learn.

I love Excel, and I hope to share my passion and enthusiasm for this amazing software onto you, as well as passing on all my skill and knowledge. Pretty soon you will be using Excel like a master, and you will save yourself so much time, as well as look like a genius!

In this course I cover:

Creating a table of data
How to filter
How to automatically format a table with filters
How to find duplicates
How to split cells into columns
How to merge columns together
How to search and replace text in Excel
How to calculate a percentage increase.
A closer look at some simple formulas
How to count cells with data
How to round numbers
How to compare two lists
Extracting data from a table using vlookup and hlookup functions
Copying formulas so that they work - absolute and relative references

Here are some of the 788 reviews from my 53,609 Excel students

Aleksandar A. - Very good hands-on course on Excel
Frank F. - This coarse is easy to follow after the previous basic courses I have done so a good continuation
Conor K. - Very easy to understand and the instructors passion for the subject matter make the course very enjoyable
Erick K. - Excellent delivery
Ranjan Kumar S. - It was useful and I could learn about some of the features I did not know about. Thanks.
Lalchhandami H. - I love the course. So easy to understand.Crisp and on point. Thank you.
Vonn C. - Very helpful. Thanks to the trainer.
Raghad A. - yes it is very helpful and clear
Jordan - This course is great and I learned quite a bit that will benefit my job. The only issue I had is having to pause and rewind a ton of times as I followed along with the document. If you're unfamiliar with Excel and following along with the provided document, this will definitely take longer than the length of the videos, but very worth it.
Mathew D. - Good knowledge gained so far!
Malak F. - I was very excited it this course it was so nice
Pinal V. - this videos' are very good to understand the things that I wanted to learn all the time. I am very appreciate to the lecturer to make this video and its helps me a lot.
Oluwadamilola David G. - very insightful and well structured.
Mark J. - Very clear, have helped me understand more where some of the options are for creating charts as well as some nice tips along the way, Thank you for sharing this information.
Arsalan K. S. - EXCELLENT
Manju S. - excellent and really helped me in learning
Joseph P. - Very well presented course
James M. - I just want to be able to nail a perfect spreadsheet that looks professional should my boss hit me up at the last minute and not stress about it.
Jowita R. - my experience is very poor, however now after the course my knowledge has improved for sure and I can not wait to try to use it
Ahsan A. - Very Useful & Informative.

Aida Ayu Wulandari

1

1

Entreprise

Communauté

Enseigner

Mobile

Entreprise

Communauté

Enseigner