Learn Microsoft Excel: Advanced Tactics for Workplace
Microsoft Excel from Beginner to Advanced level.
What You’ll Learn
- Sorting and Filtering
- Vlook Up in Details
- Pivot Table with examples
- If Function
- Find and Replace
- Remove Duplicates
- Password on Excel file
- Data Validation
- Goal Seek
Requirements
- Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)
- Mac users are welcome, but note that the Pivot Table interface varies across platforms
- Basic experience with Excel functionality (charts & formulas a plus!)
Description
This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I’ll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don’t use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
We’ll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:
- Raw data structure in Excel
- Pivot Table layouts & styles
- Design & formatting options
- Sorting, filtering,
- Calculated fields, items & values
- Pivot Charts, slicers & Chart
At the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE)
Who this course is for
- Students will little knowledge about Microsoft excel
