Basic to Advanced MS Office Excel Essentials | Weekend Course

Teacher

LCBS Dhaka

Categories

Freelancing Courses, Soft Skills

Review

(0 review)

৳5,000.00

Basic to Advanced MS Office Excel Essentials | Weekend Course
Course Fees @ BDT 4000/=

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: [email protected]
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:

https://www.facebook.com/lcbs.dhaka

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

Certification & Membership

Upcoming Batch

1415600cookie-checkBasic to Advanced MS Office Excel Essentials | Weekend Course

Course Features

Lectures 0
Quizzes 0
Duration 50 hours
Skill level All levels
Language English
Students 780
Assessments Yes

Curriculum is empty

LCBS Dhaka

Incorporated in 2007 in Ireland, LCBS Professional Tuition Ltd traded as Limerick College of Business Studies Ireland established itself as a leading institute in Ireland, and in 2010 established an identical but separate entity called LCBS Dhaka (Limerick College of Business Studies Dhaka) in Bangladesh, catering for all levels of finance both in practices and in industry.

From its inception, LCBS Dhaka has been working to promote the belief that it is not just education & skill but Quality education & Applicable skill” is what we need to cater to materialize our vision. Our services are focused and tailor made towards the development of human capital so that they can serve with the best interest of their nation by upholding and implementing the highest standards of professionalism, promoting good governance and accountability through accomplishing the socio-economic objectives of the respective countries.

LCBS Dhaka is an expert in market development of skill development services and qualifications. It has proved its expertise by contributing to the market expansion of many of the globally recognised professional accountancy qualifications.We have launched three of the world’s largest and most prestigious chartered qualifications CIMA and CIPFA in Bangladesh. LCBS Dhaka proudly represented CIMA in Bangladesh from 2010 to 2011 and now we are working as CIPFA Bangladesh. Since its inception LCBS Dhaka has been working closely with ACCA Global for its market development & growth in Bangladesh.