Basic to Advanced MS Office Excel Essentials | Weekend Course
Registration Now:
https://crm.lcbsdhaka.com/view.php?id=241767
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:
Topic Covered:
-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 Starts: 22nd October, 2021 (Friday)
||Time: 3.30 pm to 6:30pm.
Course Fee: 5,500 BDT
Get Early bird discount:
Confirm your seat by 15th October 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:
Mostofa Jamal
Upcoming Batch :
https://www.lcbsdhaka.com/upcoming-batch/
https://lcbsdhaka.com/certificate/index.php/get-certified/
For More Details:
Tel: 02-48118935-6,
Mobile: 01792162927,
Hotline: 09678 505050
WhatsApp: 01680436235
Email: info@lcbsdhaka.com
Address: House # 120, Road # 9/A, Shankar Bus Stand, Dhanmondi, Dhaka -1209
Visit Us:
Website:
LCBS E-Campus: https://e-campus.lcbsdhaka.com
Download App: https://bit.ly/lcbsdhakaapps
Facebook: www.facebook.com/lcbs.dhaka
LinkedIn: www.linkedin.com/company/lcbsdhaka
Instagram: www.instagram.com/lcbs.dhaka
Twitter: www.twitter.com/lcbs_dhaka
YouTube: www.youtube.com/Lcbsdhaka
#LCBS_Dhaka #Excel#Course #skillBangladesh #showcasingskillsglobally #LCBS #Advance_Excel #LCBS_Excel