Advanced Microsoft  Excel
Mr. Abdul Karim Sumon

Mr. Abdul Karim Sumon

View Profile

Advanced Microsoft Excel (9th Batch)

Start Date : 2022-09-20  
End Date : 2022-11-20

Total Class : 10   Total Hours: 20

Location : 102/1 Shukrabad, Mirpur Road, Dhanmondi, Dhaka-1207

Friday : 9:00 PM - 11:00 PM

Saturday : 9:00 PM - 11:00 PM

Registration Now

Using Excel for business has almost no limits for applications. Here are some examples:

  • When planning a team outing to a baseball game, you can use Excel to track the RSVP list and costs
  • Excel creates revenue growth models for new products based on new customer forecasts.
  • When planning an editorial calendar for a website, you can list out dates and topics in a spreadsheet.
  • When creating a budget for a small product, you can list expense categories in a spreadsheet, update it monthly and create a chart to show how close the product is to budget across each category.
  • You can calculate customer discounts based on monthly purchase volume by product.
  • Users can summarize customer revenue by product to find areas where to build a stronger customer relationship.

Learning Objectives:

After successful completion of this Exclusive Excel training course, the participants will be able to:

  • understand the basic and advanced features of MS Excel 2016
  • build confidence to use Excel on a daily basis
  • gain knowledge of functions and formulae to save time and reduce workload
  • feel competent to use advanced excel functions and features
  • Preparing Professional PowerPoint Presentation.
  • Learning shortest ways to prepare a presentation instantly.

Course Content

Course Content


Presenting Data Using Formatting, Filter & Reference:

  • Conditional Formatting

  • Advanced Filter

  • Custom Sort

  • Basic Calculations


Useful Functions & Formulas in Excel:

  • Logical Functions (IF, AND, OR)

  • Nested Ifs


Useful Functions & Formulas in Excel:

  • Sumfs, Countifs, Averageifs

  • Lookup Functions (Lookup,


Advanced Reporting & Printing Tools In Excel:


  • Vlookup & Hlookup

  • Subtotal




Excel Day-05


  • Table

  • Printing Using Different Views


Use of Date and Time, Timeline in Excel

  • Date and Time Functions

  • Duration Calculation

  • Timeline in Excel


Analyzing Data Using PivotTables, Slicers, and Pivot Charts


  • Charts in Excel

  • PivotTable in Calculations and Reporting


Excel Day-08


  • PivotTable in Forecasting

  • PivotTable in Advanced Reporting


Protections, Securities & Formula Auditing in Excel


  • Protections in Excel

  • Formula Auditing

  • Errors Managing (###error, N/A, DIV!,VALUE!,0, REF!e #NULL!, NAME?)



Excel Day-10


  • Queries on practical files

  • Evolution Test

  • Effective Learning Resources Sharing


 PowerPoint Day-01

  • Inserting objects

  • Creating charts

  • Modifying and formatting graphs


  PowerPoint Day-02

  • Drawing and modifying lines/shapes/text boxes

  • Aligning objects


PowerPoint Day-03

  • Adding slide transitions

  • Adding videos/movies


PowerPoint Day-04

  • Using custom animations

  • Rehearse timings