[ FreeCourseWeb.com ] Microsoft Excel Training: Learn Essential Excel Skills



Download More Latest Courses Visit -->> https://FreeCourseWeb.com







Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 3.27 GB

Genre: eLearning Video | Duration: 63 lectures (7 hour, 24 mins) | Language: English

All Exercise Files are Included

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.



Requirements



Nothing! This course assumes you are a beginner to Excel.



Use Winrar to Extract. And use a shorter path when extracting, such as C: drive



ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)



Download More Latest Courses Visit -->> https://FreeCourseWeb.com



Get Latest Apps Tips and Tricks -->> https://AppWikia.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...