Basic to Advanced MS Office Excel Essentials | Weekend Course

Basic to Advanced MS Office Excel Essentials | Weekend Course

Course Overview:
This Basic to Advanced Microsoft Excel 2013 Basic and Advanced Essentials course focuses rigorously on developing your expertise on the following functions of MS Excel:
-Start Up and Interface
-Formatting Cell Contents
-Basic Formula
-If Statements
-Lookup Functions
-Advanced formulas and functions
-Named ranges
-Resolving formula errors
-Consolidating data, removing duplicates, configuring data validation, and transposing data
-Using outlining, grouping, and subtotal tools
-Working with scenarios
-Using data analysis tools (such as Solver and Goal Seek)
-Creating and using Pivot Tables and Pivot Charts
-Using Power Pivot to integrate data from several different sources
-Recording, editing, and using macros

||Course Outline:

Class No and Course Content:

Class-1
Start Up and Interface
Formatting Cell Contents
Editing a Cell
Formatting a Worksheet
Advanced Sheet Options
Printing

Class-2
Basic Formula
Defining and Auditing Formula
If Statements
Lookup Functions
More Functions
Working with Lists
Advanced Formats and Filters
Data Tools

Class-3
Tables
Slicers
Inserting Objects
Sparkline’s
Charts
Advanced Charts

Class-4
Intro to Pivot Tables
Advanced Pivot tables
Protecting Your Workbook
Sharing your Workbook

Class-5
Macro Basics
Developing Macros

-No. of Classes: 05 (Fridays only)
-Duration of Classes: 03 hours (with 15 minutes break)
-There will be pre-assignment and post assignments.
-After each class, there will be assignments for skills practice.

||Certificate will be awarded after successful completion of the course
||Class Schedule: 20th, 27th March, 3rd, 10th, 17th April, 2020
||Time 9 am to 12 pm.

Course Fee: 6,000 BDT

Get Early bird discount:
Confirm your seat by 10th March and get 500tk off.
*Avail 1 participant’s complimentary entry for a group of 5 participants!
*Avail 1000 BDT off for each participant for a group of 3 participants!

Trainer:
Mr. Kaushik Chakrabartty ACCA
Mr. Kaushik Chakrabartty ACCA is a member of ACCA and specialist in training Microsoft Office Excel. Trainer Details:
http://bit.ly/B2AExcel_Trainer

Pay online and get EMI Facilities:
http://bit.ly/b2aExcel_EMI

For More Details: Tel: 02-9142957-8, Mobile: 01705439940, Hotline: 09678 505050
Address: House: 105, Road: 9/A, West Dhanmondi, (Beside Dhanmondi party center),
Dhanmondi, Dhaka-1209

Subscribe Our YouTube Channel:
http://bit.ly/LCBSDhaka

Visit Our Website: https://www.lcbsdhaka.com

LCBS Dhaka is the leading training institute in Bangladesh Since 2010. More than 400 professionals got trained on MS Office Excel and their feedback were inspiring for arranging further batches. Now we are offering: “MS Office Excel Intermediate” and “Advanced MS Office Excel Essentials” courses. What our trainees say:
http://bit.ly/LCBSDhaka