Basic to Advanced MS Office Excel Essentials | Weekend Course

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…/

For More Details:
Tel: 02-9142957-8,

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:

https://www.lcbsdhaka.com
LCBS E-Campus: e-campus.lcbsdhaka.com
Facebook: https://www.facebook.com/lcbs.dhakaLinkedin:https://www.linkedin.com/company/lcbsdhaka
Instagram:https://www.instagram.com/lcbs.dhaka/
YouTube: https://www.youtube.com/Lcbsdhaka