Description

This master course is designed to teach you the advanced level of Excel formulas all the way to Excel mastery. It’s perfect for you if you are a working professional to drastically increase your excel skills to impress your boss, or even get a handsome job. Everything in the course is taught step-by-step in an easy, stress-free way. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare Pivot, data for analysis, and learn how to work with dates and financial functions.

Everything in the course is taught step-by-step in an easy, stress-free way. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and tricks. Exeller Learning has started this Advanced Excel Training Program online during weekend (Saturday & Sunday) at the convenient of your time. Get guidance from our expert professionals and be your own guiding star. From finding the right job to career growth.

If you have any questions or concerns about this course and would like to know how to enroll and proceed, please request a call back and we will gladly contact you to provide all the necessary information and details.

Benefits of the course

  • Build financial models from scratch (shown step-by-step)
  • Format sheets and charts professionally
  • Learn new keyboard shortcuts and be even faster in Excel
  • Use Cell Styles and format spreadsheets easier and faster
  • Writing Formulas and performing Calculations
  • Create charts with Trend Lines, and Dual Axis
  • Use Excel as a Database with Sort and Filter options
  • How to avoid the most common Database Design flaws
  • Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
  • Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions
  • Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
  • MIS Reporting
  • Learn several hidden Excel tips and tricks

Topics for this course

42 Lessons 20 hours

ADVANCED ARRAY FUNCTIONS

Basic Examples of Arrays (Using ctrl+shift+enter)
Advanced Use of formulas with Array
Sum product & Aggregate Function

LOOKUP MAHARAJ FUNCTIONS

PIVOT TABLES

INTRODUCTION TO POWER QUERY & POWER PIVOT

CHARTS AND SLICERS

EXCEL REPORTING DASHBOARD

NEW FUNCTION IN EXCEL OFFICE 365

Requirements

  • Access to a good internet connection
  • Laptop with Microsoft Office Installed

Your Instructor

Sajjad Hussain

MIS & Data Analytics

I am a pro in Excel, Power BI, MIS Reporting & Creating a Visual Dashboard with almost 7 years of corporate working experience.

Free

  • Duration 20 hours
  • Lessons42
  • Skill levelExpert
  • CategoryExcel

Secure Payment:
X

Company

Get in touch!

Transform your career with our online learning courses and master’s program. Contact us today to get started.

Exeller Digittal Marketing Online Classes
© 2022 Exeller Learning All Rights Reserved.