Explore Microsoft Excel

Teacher

Categories

৳750.00

Introduction

Excel is one of today’s most powerful and multipurpose business tools. If we are not aware with its effective/ wonderful functions, formulas, commands and keystrokes, we may set ourselves up for frustration and disappointment. The training will show us how to turn Excel into your most impressive productivity and useful Excel tips to help your everyday works faster.

Who will be benefited?

This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.

Learning Outcomes:

Learn the most common Excel functions used in the Office
Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.
Use formulas and functions to perform calculations on data.
Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.
Create dynamic reports by mastering one of the most popular tools, PivotTables

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 the 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.

Delivery Details:

Total Class: 06 with an assessment

Total Duration: Total 9 hrs.

Class Per Week: 2 Days per week (Friday & Saturday)

Time: 8:00 pm to 09:30 Pm

Class Duration: 1.5 hours/Day

Language: Bangla, English

Delivery Mode: Online

Online: e-campus.lcbsdhaka.com

Standard Course Fees: BDT- 750

Course Features

Lectures 11
Quizzes 0
Duration 9 hours
Skill level All levels
Language English
Students 0
Assessments Yes

Day 1 3
Day 2 2
- Lecture2.1
  Print — Page Break, Page Setup, Page Layout, Print Titles, Margins, Preview
- Lecture2.2
  Conditional Formatting — Duplicate values, Icon Sets, Format Rules
Day 3 2
- Lecture3.1
  Data Linking — Data Linking concept, Linking between Worksheets or Workbooks
- Lecture3.2
  Formula/Function — SUM, IF, AND, OR, IFERROR, DATEDIF
Day 4 2
- Lecture4.1
  Data Validation — Setting, Message, Drop-Down List, Alert
- Lecture4.2
  View – Page Break, Free Panes
Day 5 1
- Lecture5.1
  Pivot Table with Chart — Creating Pivot Table, Add/remove fields, Filtering, Use of Slicer, Pivot Charts, Power Pivot
Day 6 1
- Lecture6.1
  Assessment

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.