In this special Microsoft Excel - Excel From Beginner to Advanced course you can learn the most important features of Excel focusing on data visualization and productivity. I'm using the version Microsoft Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with Ms Excel 2010, 2013, 2016, 2021, 2022 versions

data visualization techniques which you can use to create Excel charts that will impress your audience. Projects covered: highlight max value dynamically on an Excel chart discover Excel's conditional formatting feature to highlight key data in your table how to create a map chart that reads well by the viewer how to use icons in your bar charts to make it exciting how to create a progress chart in infographic style

the most frequently used Excel formulas/functions. You will find lots of real-world examples in these topics: Relative vs Absolute cell references explained working with date functions SUM(), SUMIF(), SUMIFS() functions MIN(), MAX(), AVERAGE(), COUNT() functions VLOOKUP(), HLOOKUP() functions examples INDEX(), MATCH(), XLOOKUP() functions to search data

In the last section we're getting into an advanced Excel topic. I explain how one of the most valuable Excel features works, the PivotTable. Many people are afraid to use it, but I'll make it simple for you. We're going to build several reports, and create a PivotChart too. I will also talk about database design principles. We will create a Data Model, and I will show you how to use PivotTable with multiple tables. So, you'll be able to use Excel as a real database. By taking this course you can really take your Excel skills to way above the average. Don't worry if you're an absolute beginner. I'll explain everything step by step.