What you’ll 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.
How to Enroll Microsoft Excel Training: From Zero to Hero in 8 Hours course?
How many members can access this course with a coupon?
Microsoft Excel Training: From Zero to Hero in 8 Hours Course coupon is limited to the first 1,000 enrollments. Click 'Enroll Now' to secure your spot and dive into this course on Udemy before it reaches its enrollment limits!