What you'll learn
Most Useful Shortcuts to accelerate the work on sheets.
Basics operations, Absolute and Relative cell reference.
Using basics Formulas : SUM , AVERAGE, MAX & MIN, LARGE & SMALL, COUNT COUNTA & COUNTBLANK.
Formatting the sheets : Fonts, Borders, Styles & Themes, Quick Styles.
Working with data : Sorting, Filtering, Conditional Formatting.
Create and Manipulate simple Charts.
Printing setting.
Requirements
No advanced knowlegde for Excel
Basic Knowledge on how to use a computer and a stable Internet Connection.
Having Microsoft Excel installed on your computer
Some of the features may not work on the version older than 2016
Description
Welcome to the Microsoft Excel Training course.
If you're looking to start learning Excel or u know already some basics but u want to learn more, here is your place.
Excel is a powerful tool that can make your work easy if u do it the right way, that is why this course will guide u to learn the basics, and then why not move to the advanced features.
In this Excel course, you will learn about
Shortcuts: To be fast when handling ur files, or a large data worksheet.
Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using AVERAGE, MAX, MIN, LARGE, SMALL, IF, AGGREGATE.
Excel Formatting: Adjusting fonts, colors, borders, built-in styles, and creating and using templates.
Dealing with large dаta: Using Find and Replace, managing worksheets, Filtering and sorting, using Conditional formatting.
Charts: Choosing chart types, creating and modifying a column chart, and a bonus on how to highlight the max and the min in a bar chart ( dynamic ).
Printing: Insert headers and footers, and some printing settings to know.
What differentiates this Microsoft Excel course from the others?
I created this course as someone who admires Excel, it's been 3 years of learning and working with data using this tool, and each time I learn something new, I decided to share this knowledge the best I can, by creating practical examples and challenges to do to practice more, as they say
" Practicing makes it permanent".
Enjoy this course >>
Who this course is for
For beginners and anyone who want to start and learn Excel
For any other level who want to practice more Excel.
Homepage