Microsoft Excel Mastery: From Beginner to Pro
Essential Excel Skills for Beginners & Intermediates: Comprehensive Training in Excel 2016
4.28 (719 reviews)
52,275
students
7.5 hours
content
Mar 2023
last update
$54.99
regular price
What you will learn
Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting.
Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges.
Excel Formatting: Adjusting fonts, colors, adding pictures, shapes and borders, inserting SmartArt, built-in styles and creating and using templates.
Printing: Inserting headers and footers, generating PDFs.
Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek and using the scenario manager in excel.
Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.
Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.
Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.
Macros: Understanding, recording, using and editing a macro.
Related Topics
3427082
udemy ID
8/17/2020
course created date
10/9/2020
course indexed date
Bot
course submited by