
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 NowUsing 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: |
|
Class-02 |
Useful Functions & Formulas in Excel: |
|
Class-03 |
Useful Functions & Formulas in Excel: |
|
Class-04 |
Advanced Reporting & Printing Tools In Excel: |
|
Class-05 |
Excel Day-05 |
|
Class-06 |
Use of Date and Time, Timeline in Excel |
|
Class-07 |
Analyzing Data Using PivotTables, Slicers, and Pivot Charts |
|
Class-08 |
Excel Day-08 |
|
Class-09 |
Protections, Securities & Formula Auditing in Excel |
|
Class-10 |
Excel Day-10 |
|
Class-11 |
PowerPoint Day-01 |
|
Class-12 |
PowerPoint Day-02 |
|
Class-13 |
PowerPoint Day-03 |
|
Class-14 |
PowerPoint Day-04 |
|