ADVANCED EXCEL COURSES – THE KEY TOOL TO MANAGE ALL REPORTS

Administrator Expert

Description

आरंभ Mastering Excel program is intended to make you Excel champion by acquiring the fundamentals of Excel spreadsheets to perform basic data analysis.

Core & Advanced Excel with Dashboard

MS Excel from beginner to Advance excel, Formulas, Chart tips and Tricks in MS Office and Office 365.

This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It’s perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your excel skills to impress your boss, get a raise or even land a new 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 data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for your big finale, where you will learn how to build professional dashboards in Excel.

What you will learn:

  • Build a solid understanding on the Basics of Microsoft Excel
  • Master Microsoft Excel from Beginner to Advanced
  • 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 several hidden Excel tips and tricks
  • Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
  • Learn to make dashboards.

Download Brochure

Topics for this course

88 Lessons44h 59m 59s

EXCEL INTRODUCTION & ADVANCED PASTE SPECIAL TECHNIQUES

Excel Interface00:00:00
Shortcut Keys00:00:00
Customizing Excel00:00:00
Paste Formats, Values, Formulas, Comment, Validations00:00:00
Operation – Sum, Multiple, Subtract, Divide00:00:00
Transpose Table00:00:00

FORMULA REFRENCE

FORMATTING BASIC

FORMATTING ADVANCED

EXCEL BUILT IN FUNCTIONS

WORKGROUP COLLABORATIONS

SORTING AND FILTERING

SUMMARIZING DATA

DATA VALIDATION

WORKING WITH EXTERNAL DATA & DATA ANYLYSIS TOOL

USING MACROS

ADVANCED ARRAY FUNCTIONS

LOOKUP MAHARAJ FUNCTIONS

PIVOT TABLES

INTRODUCTION TO POWER QUERY & POWER PIVOT

CHARTS AND SLICERS

EXCEL DASHBOARD

NEW FUNCTION IN EXCEL OFFICE 365

4,999.00
  • Course level: Expert
  • Duration 44h 59m 59s