Get 20% discount

Microsoft Excel 2007/2010 - Starter to Intermediate

Introduction

Background
In today’s modern organizations, Microsoft Excel, as a spreadsheet application, is used by the employees more than any other application software. Good working skills in Microsoft Excel lead to professional success as well as reach benefits to the organizations. It increases productivity, enhances the quality of numbers, provides valuable information and can do many other good things for the employees and employers.

However, it has been found through survey, most of the users of Microsoft Excel are unaware of its full utilities and they don’t use more than 10% functionalities. Main reason behind this unexpected situation is the way the users get introduced to the software, continue learning and keep applying at work. Firstly, Most of the users get introduced to the software without the knowledge that “Microsoft Excel” is very different from other application packages and it can change their career spectrum if they can apply it at work properly. Secondly, they start learning the software without any structured step-by-step learning method and keep learning themselves. Thirdly, they apply the few self-learnt skills at work to do everything they need. As a result, despite using Excel for several years, most of the users do not have the right introductory skills.

Purpose of the Course
This course is developed with the purpose of providing a very quick systematic and structured introduction to Microsoft Excel. This part will introduce and clarify the concept of spreadsheet referencing, formula writing techniques, essential functions and essential options. After a quick introduction, the course will provide highly essential working skills needed to finish most of the tasks at work in style and in time. This part will concentrate on working with large dataset, essential practical calculations and reporting techniques.

Learning Outcomes
At the end of this course the participants will be able to:
(1) Understand the mechanism of spreadsheet applications – the way Microsoft Excel works and covers variety of professional needs;

(2) Will be able to identify and describe various components of the application platform including customization of the application window;

(3) Write formulas with full knowledge of absolute/relative referencing, cell/range naming and concept of independent and dependent cells/variables.

(4) Understand the differences between formulas and function; use very essential statistical, text and date functions.

(5) Prepare data tables with essential skills of data/cell format, lay-out and color concept;

(6) Manage large data tables with sorting and filtering techniques;

(7) Summarize large amount of data very quickly with subtotal and pivot-table tools.

(8) Present summarized graphically with at least four basic charts – column, line, bar and pie charts.

Methodology

The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Contents of Training:

Session One
Understand the Mechanism of Spreadsheet Applications – The way Microsoft Excel works and covers variety of professional needs

1.1 Definition of Spread-Sheet
1.2 Working Method of Electronic Spreadsheet
1.3 How and Where Spreadsheet can help professionals
1.4 What common skills are needed by all employees

Session Two
Identify and Describe Various Components of the Microsoft Excel Application Platform Including Customization of the Application Window

2.1 Fluent Interface of 2007+ versions and difference with older versions
2.2 Various Modules of 2007+ Modules
2.3 Basic Option Configuration
2.4 Basic Customization Techniques

Session Three
Write Formulas with Full Knowledge of Absolute/Relative Referencing, Cell/Range Naming Concept of Independent and Dependent Variables

3.1 Static Formula Writing – Understanding of BODMAS rule and Arithmetic Operators
3.2 Formulas with Relative and Absolute Referencing
3.3 Formulas with Cell Names and Name Management
3.4 Dragging, Clicking, Copying/Pasting of Formula

Session Four
Understand the Differences between Formulas and Functions; Use Very Essential Statistical, Text and Date Functions

4.1 Difference Between Formula and Functions
4.2 Essential Statistical Functions
4.3 Essential Text Functions
4.4 Essential Date Functions

Session Five
Prepare Data Tables with Essential Skills of Data/Cell Format, Lay-Out and Color Concept

5.1 Database and Data-Table Fundamentals
5.2 Table Visuals – Border and Fill Formatting
5.3 Table Data Format
5.4 Layout and Color Scheme

Session Six
Present Summarized Data Graphically with basic charts – Column, Bar, Line & Pie Chart

6.1 Column Chart
6.2 Bar Chart
6.3 Line Chart
6.4 Pie Chart

Session Seven
Manage Large Data Table using Sorting and Filtering Techniques

7.1 Basic and Multi-Level Data Sorting
7.2 Managing Blank Cells
7.3 Apply Filters in Data Table
7.4 Remove Duplicates and Separate Filtered Data

Session Eight
Summarize Large Amount of Data Very Quickly with Subtotal and Pivot-Table Tools

8.1 Subtotal Function
8.2 Subtotal Utility
8.3 Basic Pivot-Tables
8.4 Pivot Charts

Related Courses

Price 18,000 Tk + VAT
Muhammad Rabiul
  • 30 May - 18 Jul 2017

IT
Abu Shams Mahmood Arif
  • Friday, June 2, 2017

Day to day HR and Admin data analysis, reporting, tools and ...

IT
Mostofa Monower
  • 2 - 3 Jun 2017 (2 Days Long)

This training program builds upon advanced level knowledge ...

IT
Md. Rabiul Islam
  • 2 Jun - 29 Jul 2017

There are many high-level languages. Python is one of ...

IT

Contact

9140345, 9117179

workshop@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

Anyone starting from new users to long-time users of Microsoft Excel can participate the course. New users will have a systematic introduction to the software and old users can close their skill gaps through this course.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.