ADVANCED EXCEL COURSES – THE KEY TOOL TO MANAGE ALL REPORTS

Administrator Expert

Description

कौशल – MIS & Automation program is intended to make you Excel & VBA Automation champion by acquiring the fundamentals of Excel spreadsheets to perform basic data analysis and VBA automation to automate your daily task.

Core & Advanced Excel with Dashboard

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

VBA Automation with Real time project implementation

This course is designed to teach you the basics of Microsoft Excel & VBA Automation all the way to Excel & VBA mastery. It’s perfect for you if you are a beginner or intermediate Excel VBA  user who needs to drastically increase your excel vba 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 as well as automation of your daily office task. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. You will learn how to build professional dashboards in Excel & VBA.

What you will learn:

  • Enhance your current Excel files & automate your work with VBA.
  • 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 Excel & VBA dashboards.
  • Master Excel VBA & Macros
  • Explore Google Sheets
  • Learn Excel with ChatGPT
  • Reduce manual routine tasks to the click of a button

Download Brochure

Topics for this course

91 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

GOOGLE SHEETS ESSENTIAL

CHATGPT FOR EXCEL

VBA MACROS

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