Basic to Advanced MS Office Excel Essentials | Weekend Course

Registration Link:
https://crm.lcbsdhaka.com/view.php?id=152731

Course Overview:
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget or stay organized with checklists. This course will give a full introduction to Excel and then moves on to the more advanced functions, so whether you’re a beginner or have some experience, you’ll become an expert.

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 different sources
-Recording, editing, and using macros

Why LCBS Dhaka:

LCBS Dhaka is unique with its products and services designed and offered locally & Internationally. LCBS Dhaka is the only platform in Bangladesh with international recognition for the premium partnering with International organizations where internationally recognized Chartered qualifications & Certification courses are offered, Exams are taken , Corporate Training & Soft Skills provided as per employers needs and job placement done. Since 2007 LCBS Dhaka has served the highest number of students, Corporate Clients and offered the highest number of courses with success globally. It ensures delivery of quality education & Training with renowned training specialists from home and abroad. Quantity is not the priority- Quality, Commitment & Clients’ Feedback is our wealth. Hear from our clients whom we served already by visiting our YouTube channel- www.youtube.com/lcbsdhaka.

Topics To Be Covered:

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

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

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

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

-Macro Basics
-Developing Macros

-Financial Functions and Working with Dates
-Building Professional Dashboards

To know more about this course please visit: https://www.lcbsdhaka.com/…/basic-to-advanced-ms…/

Delivery Details:
Total Class: 5
Total Duration: Total 15 hrs
Class Start from 16th October 2020
Class Per Week: one Days per week (Friday)
Class Time: 5:00PM
Language: Bangla and English
Delivery Mode: Online
In House: LCBS Dhaka
Online : e-campus.lcbsdhaka.com

Standard Course Fees: BDT- 4000/=

To keep in touch and updates please Download App on Google play store: https://bit.ly/lcbsdhakaapps

For More Details:
Tel: 02-9142957-8, Mobile: 01792162927, Hotline: 09678 505050 WhatsApp: 01680436235 Email: cams@lcbsdhaka.com
Address : House: 105, Road: 9/A, West Dhanmondi, (Beside Dhanmondi party center), Dhanmondi, Dhaka-1209
Visit Us:

https://www.lcbsdhaka.com
LCBS E-Campus: e-campus.lcbsdhaka.com
Facebook:

Linkedin:https://www.linkedin.com/company/lcbsdhaka
instagram:https://www.instagram.com/lcbs.dhaka/
YouTube: https://www.youtube.com/Lcbsdhaka