Learn Microsoft Excel : Advanced Tactics for Workplace

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)

What You Will 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

Who Should Attend!

• Students will little knowledge about Microsoft excel

TAKE THIS COURSE