Microsoft Excel Masterclass: Learn Excel Step by Step
Master Excel from the basics to advanced tools — learn formulas, functions, charts, and data analysis step by step.
Current Price: Free
Discount: 100% off
What you will learn:
Overview of Excel's InterfaceUnderstanding Ribbons, Tabs, and Menus
Navigating Excel
Using Cells, Rows, and Columns
Understanding The Excel Grid System
Entering and Editing Data
Copying, Cutting, and Pasting Data
Font Styles, Colors, and Cell Alignment
Applying Borders and Shading
Performing Basic Calculations (SUM, AVERAGE)
Using AutoFill and Flash Fill
Sorting and Filtering Data
Grouping and Ungrouping Worksheets
Logical Functions (IF, AND, OR)
Lookup and Reference Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Working With TODAY, NOW, and DATE Functions
Using LEFT, RIGHT, MID, CONCAT, and TEXT
Visualizing Data with Pivot Charts
Creating Dropdown Lists
Using Goal Seek, Data Tables, and Scenario Manager
Column, Line, and Pie Charts
Customizing Chart Elements and more