Advance Excel-VBA

Advance Excel-VBA

Advance VBA Course

Introduction:

Microsoft Excel is the leading & most demanding tool used in the industry for data analysis and reporting. Excel has hundreds of formulas & functions, dozens of data analysis & reporting tools and thousands of hidden tips & tricks to take care of all of your professional spreadsheet analysis needs!

This course will help you to master all the essential functions. tools and features of Microsoft Excel, taking your Excel efficiency form Basic to Advance level. On the completion of this course, participants are qualified to use the full features of the Microsoft Excel, making them an invaluable resource for their companies, accelerate their productivity and improve organizational performance.

 SALIENT FEATURES

  • Vastly experienced and certified trainers.
  • State of the art fully air-conditioned computer labs with multimedia projectors.
  • Individual guidance & support to every participant during lab sessions.
  • Up-to-date course material & manual.
  • Thousands of MS Excel productivity  tips & tricks.

WHO SHOULD ATTEND

This program is hugely beneficial for engineers, project managers, finance and account professionals, business analysts, fresh graduates or anyone who want to boost their spreadsheet analysis and reporting skills.

COURSE CONTENTS

Fundamentals of Excel

  • Understanding Ribbon Interface
  • Formula Basics & Cell References
  • Auto Fills & Custom Lists
  • Working with Basic Excel Functions
  • Using Smart Tables
  • Sorting & Filtering Data
  • Working with Conditional Formats
  • Working with Charts
  • Using Subtotal

Advanced Features

  • Using Array Formula
  • Working with Named Ranges
  • Using Complex Excel Functions:
  • Using Multi-sheet Formulas
  • Using Advanced Filters
  • Data Validation & Protection
  • Consolidation & List Management
  • Automating with Macros
  • Using Form Controls

Advanced Reporting & BI

  • Business Reporting with Pivot Tables
  • Working with Slicers
  • Advanced Charting & Visualizations
  • Using Sparkline Charts
  • Creating Interactive Dashboard Reports
  • Using Power View & Power Pivot Features

Financial Modeling

  • Using What-If-Analysis Tools: Goal Seek, Data Table, Scenario Manager & Solver
  • Working with Financial  Functions

 Using External Data

  • Mail Merge with Excel
  • Managing External Data Connections

Programming with VBA

  • Writing Customized Macros
  • Creating Custom Excel Functions
  • Working with Excel Addins

PROGRAM DURATION

The program is of 3 months. Classes will be conducted on Sundays only (10:00 A.M. to 4:00 P.M)

FEE

The fee for the entire program is Rs.30,000/-.

IMPORTANT DATES

Seminar Date & Time
Last Date of Submission of Forms & FeesJan 15, 2024
Commencement of ClassesJan 17, 2024
DaysSunday Only 10:00 AM to 4:00 PM
Classes Schedule

For details and registration, please contact or visit:

CREATIVE INSTITUTE OF IT MULTAN

Block W/1, New Multan, Multan-60000: Tel: +92 300 738 3401 | 333 763 5061

E–Mail: creativesoftec@gmail.com ||  Website: www.creativeitedu.com