Microsoft Excel - Advanced Excel 2013 Training

Gain command over Advanced and Powerful features and functions of Microsoft Excel 2013.


In this course on Advanced Microsoft Excel 2013, we will be covering advanced functions and features. The course begins with some of the most useful functions of Excel 2013, gradually takes you through prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Important functions like Pivot Table has been taken comprehensively for better understanding. We will also be covering other smart features like Charts and Graphs, Dashboard and Financial Functions in this course. By the completion of this Advanced Excel 2013 training, you will be comfortable with most of the advanced features and functions. Working files are included, allowing you to follow along with the author throughout the lessons.
We will be covering the following modules in this online course on Advanced Excel 2013.
  • Introduction to Useful Excel 2013 Functions
  • Data Functions
  • What If Analysis
  • Arrays
  • Functions for Working with Text
  • Excel 2013 - Pivot Table
  • Summarizing Data Using Pivot Table
  • Data Filtering
  • Basics Pivot Table Formatting
  • Advanced Pivot Table Formatting
  • Introduction of Pivot Chart
  • How to Print the Pivot Table
  • Using Macros In Pivot Tables
  • Introduction of Power Pivot
  • DAX in Power Pivot
  • Introduction of Power View
  • Names and Dynamic Range
  • Auditing and Trouble Shooting Formulas
  • Important Excel Tools
  • Excel 2013 - Charts & Graphs
  • Chart Concept
  • Basic Chart
  • Fine Tuning of Charts
  • Chart Options
  • Format Tab
  • Adjustment of Specific Chart Types
  • Changing Chart Sources
  • Specialised Charts & Graphs
  • Excel 2013 - Excel Dashboard
  • Creating Basic Charts
  • Learning Pivot Table, Pivot Chart and Slicer
  • Using Form Controls
  • Basic Macros
  • Assigning Macros to Buttons to Navigate and Dashboard
  • Financial functions using Excel
  • Future Value, SI, CI, PV, NPER, RATE

Original Price : $99

Yours : 100% Off (Free)
Note: Udemy Free Coupon Codes expires quickly when they reach a certain amount of users or certain time.
Udemy 100% Discount Coupon Code:

Post a Comment