Advanced Microsoft  Excel
Mr. Abdul Karim Sumon

Mr. Abdul Karim Sumon

View Profile

Advanced Microsoft Excel (7th Batch)

Online: TK 1500

Start Date : 2021-07-02  
End Date : 2021-09-02

Total Class : 14   Total Hours: 28

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

Friday : 7:00 PM - 8:30 PM

Saturday : 7:00 PM - 8:30 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

Class-01

Presenting Data Using Formatting, Filter & Reference:

  • Conditional Formatting

  • Advanced Filter

  • Custom Sort

  • Basic Calculations

Class-02

Useful Functions & Formulas in Excel:

  • Logical Functions (IF, AND, OR)

  • Nested Ifs

Class-03

Useful Functions & Formulas in Excel:

  • Sumfs, Countifs, Averageifs

  • Lookup Functions (Lookup,

Class-04

Advanced Reporting & Printing Tools In Excel:

 

  • Vlookup & Hlookup

  • Subtotal

 

Class-05

 

Excel Day-05

 

  • Table

  • Printing Using Different Views

Class-06

Use of Date and Time, Timeline in Excel

  • Date and Time Functions

  • Duration Calculation

  • Timeline in Excel

Class-07

Analyzing Data Using PivotTables, Slicers, and Pivot Charts

 

  • Charts in Excel

  • PivotTable in Calculations and Reporting

Class-08

Excel Day-08

 

  • PivotTable in Forecasting

  • PivotTable in Advanced Reporting

Class-09

Protections, Securities & Formula Auditing in Excel

 

  • Protections in Excel

  • Formula Auditing

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

Class-10

 

Excel Day-10

 

  • Queries on practical files

  • Evolution Test

  • Effective Learning Resources Sharing

Class-11

 PowerPoint Day-01

  • Inserting objects

  • Creating charts

  • Modifying and formatting graphs

Class-12

  PowerPoint Day-02

  • Drawing and modifying lines/shapes/text boxes

  • Aligning objects

Class-13

PowerPoint Day-03

  • Adding slide transitions

  • Adding videos/movies

Class-14

PowerPoint Day-04

  • Using custom animations

  • Rehearse timings