Description

Learn at your own pace and get smarter with our Advanced Excel, Process Automation using Power Query, MIS Dashboard, BI Tools, Highcharts, Data Visualization, Data Analytics and MIS Dashboard Reporting online training program.

This master course is designed to teach you the advanced level of Excel formulas, automation, MIS and visualization reporting dashboard all the way to Excel mastery. It’s perfect for you if you are looking for a new opportunity or working professional to drastically increase your excel skills to impress your boss, or even get a promotion.

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. You will clean and prepare data for analysis, and learn how to work with dates and financial functions.

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
  • Power BI & Power Query for Automation
  • Learn several hidden Excel tips and tricks

Topics for this course

71 Lessons 52 hours

EXCEL INTRODUCTION & ADVANCED PASTE SPECIAL TECHNIQUES

Excel Interface
Shortcut Keys
Customizing Excel
Paste Formats, Values, Formulas, Comment, Validations
Operation – Sum, Multiple, Subtract, Divide
Transpose Table

FORMULA REFERENCE

FORMATTING BASIC

FORMATTING ADVANCED

EXCEL BUILT IN FUNCTIONS

WORK GROUP COLLABORATIONS

SORTING AND FILTERING

SUMMARIZING DATA

DATA VALIDATION

WORKING WITH EXTERNAL DATA & DATA ANALYSIS TOOL

USING MACROS

ADVANCED ARRAY FUNCTIONS

LOOKUP MAHARAJ FUNCTIONS

PIVOT TABLES

Requirements

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

Your Instructors

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.

Sajid Akram

SEO, SEM & Analytics

Sajid is the Practice Lead in Digital Marketing (SEO, SEM & Analytics) He has proven results in Performance Marketing from optimizing search engine marketing campaigns, including pay-per-click (PPC), YouTube Ads, Shopping Ads, GDN Ads, Remarketing campaigns, Quora, Reddit to social media marketing, and organic search engine optimization (SEO) and analytics to expose brands to highly discerning customers. In addition, He creates powerful digital marketing and media buying strategies that engage and attract audiences and drive conversions across the omnichannel approach. He has years of combined experience and expertise working with diverse clients in Healthcare, Energy, Telecom, Automobile, E-commerce, Education, Gaming, and FMCG throughout the globe. Hands on Experience with top clients - Abbott (FreeStyle Libre), Wolters Kluwer, Hathway Broadband, Paras Healthcare, Vikram Solar, Amplus Solar, Lohia Auto, Thermage, Diginerve, India@75, Zuju Kickoff, and Relevium.

Free

  • Duration 52 hours
  • Lessons71
  • Skill levelAll Levels
  • 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.