overview

Excel Beyond the Basics

Uncover Hidden Features and Boost Efficiency

apply now
Play Video
View Brochure

6343

Alumni

78.6%

Placements

114

Startups

1540

Corporate Trainings

Enroll today

Detail

This workshop will help to take your analytical skills to the next level of accuracy. Intensive and hands-on, the course is designed to equip you with step-by-step guides for structuring and managing accurate financial data. In this workshop, participants can learn advanced formulas, conditional formatting, pivot tables, form controls, and interactive charts and learn how to develop and devise the required business and financial reports.

Key Features:

  • Introduction to MS Excel Environment, Worksheets, Rows, Columns, and Cells operations.
  • Working with basic Formulae
  • Working with advanced Formulae
  • Organizing table data
  • Working with Pivot table
  • Practice Exercises
  • Formatting and Conditional formatting
  • Visualization in MS Excel
  • Excel Solver – Introduction and case study
  • Practice Exercises – Excel Solver
  • Data validation,
  • Import/Export Data
  • Data analytics in MS Excel
  • Data modeling in MS Excel
  • Descriptive Statistics in MS Excel
  • Correlation and Regression
  • Practice exercises in data analytics
  • Mid Term Exam
  • Case Studies
  • Summarizing data using advanced functions, Conditional formatting
  • Database operations & management
  • Logical and lookup functions, Array functions, Macros
  • Optimizing solutions with “What if” analysis
  • Reporting with power pivot
  • Data visualization with graphs and charts
  • Power Query and Power Pivot
  • Business Intelligence Tools & Forecasting.

Program Fee

  • Program fee PKR 40,000/- (excluding SST), is required to be submitted prior to the commencement of classes (Discounts are Available).
  • A special incentive of 10% discount is available for those who choose to pay the full program fee in advance.

Installment Plan

-We provide a flexible installment plan that consists of two payments:

  • The initial installment amount is 20,000.
  • The second installment amount is 20,000. 

Program Duration

  • 2 – Months program

Timings

  • Monday: 6:00 PM to 9:00 PM
  • Wednesday: 6:00 PM to 9:00 PM
  • Friday: 6:00 PM to 9:00 PM

Student Policy

  • It is essential for program participants to fulfill the requirement of clearing the program fee.
  • Non-compliance with fee payment may result in termination from the program.

Eligibility Criteria

  • Minimum Qualification: A levels/ Intermediate.

Mr. Sohail Imran:

For more than 18 years, Mr. Sohail Imran is conducting training and workshops for databases (SQL and NoSQL), Big Data Infrastructure, and Machine Learning for different institutes, universities, and the corporate sector. More than 8 years of professional experience in Big Data Analytics, Data Science, Data Mining, Data Warehousing, and DBMS (SQL and NoSQL). Providing consultancy in designing and developing Big Data Analytics platforms using Java, RapideMiner, Radoop, Python, Hadoop, Hive, Spark, Kafka, Spark Streaming, Storm, etc.

Mr. Syed Aftab Ahmed:

Mr. Aftab is a highly experienced Data Analytics expert, his expertise lies in collecting, analyzing, and interpreting large datasets, developing new forecasting models, and performing data management tasks. he has been working as Manager of Analytics & Sales Operations in KEENU Pakistan.