Free Excel Tutorial - Microsoft Excel - Improve your skills quickly

Description

In this course, you will learn:-

• Tables, PivotTables, PivotCharts, and Sparklines can all be created.
• Use Conditional Formatting, Filters, and even a little Visual Basic for Applications to spice things up.
• Use the functions SUM, SUMIF, VLOOKUP, OFFSET, and INDIRECT.
• Learn everything you need to know about Excel so you can continue your education.

Syllabus:-

• Introduction

• Welcome to Udemy

• Introduction to Udemy

• Formatting

• Filters

• Conditional Formatting

• Tables

• PivotTables

• Graphs and PivotCharts

• Sparklines

• Visual Basic for Applications (VBA)

• Practice Activity Number 1

• SUM, AVERAGE, COUNT

• SUMIF, AVERAGEIF, COUNTIF

• VLOOKUP

• OFFSET

• INDIRECT

• Practice Activity Number 2

• What more should I know about Excel?

• Bonus - How to learn more about Excel