Easy Excel – Start your Excel practicing and learn the basic knowledge.
Welcome to the Microsoft Excel Training course.
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..
Course Content
- Introduction –> 1 lecture • 1min.
- Basic Knowledge –> 4 lectures • 26min.
- Basics Formulas –> 6 lectures • 26min.
- Formatting –> 5 lectures • 14min.
- Working with data –> 6 lectures • 29min.
- Charts –> 5 lectures • 24min.
- Print –> 2 lectures • 13min.
- What’s Next ? –> 1 lecture • 1min.
Requirements
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 data: 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 >>