[82% Off] Microsoft Excel Training: From Zero to Hero in 8 Hours
Duration: 7.5 hours
Excel with this Microsoft Excel Course. Learn Excel from A to Z in just 8 hours!!
Notice for our visitors in India:
If udemy coupon is 100% off but it was not free when you go to Udemy website, please follow our friend Abhay Singh instructions to make it work. This is mainly affecting visitors that has India as a Country of Residence in their profile in Udemy.
You may also like:
What is SEO and How Does it Work?
The Bits and Bytes of Computer Networking
Coursera ● 0$ 45.00$
learn python for beginners
C# Tutorial For Beginners - Learn C# Basics in 1 Hour
AWS Certified Solutions Architect Associate Practice Exams
Udemy ● 13$ 79.99$
Welcome to Microsoft Excel 2016 Training course.
If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.
Learning Excel will become very easy if you do it the right way. First you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.
In this Excel course, you will learn about:
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.
Enjoy and happy learning!!