Get 20% discount

Microsoft Excel 2013 - Starter to Advance (with Case Studies)

  • Date : 14 - 28 August 2017
  • Duration : Evening(6.30pm-9.30pm)
  • No. of Classes/ Sessions : 5 session
  • Class Schedule : Monday & Wednesday
  • Total Hours : 15
  • Last Date of Registration : 12 August, 2017
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

Microsoft Excel has more than 750 Million users worldwide. It’s an electronic spreadsheet and considered as most essential application in Microsoft Office package. The application provides an outstanding combination of functions and tools for working with quantitative data analysing, reporting and decision making. Scientist or Business Manager! Wherever you grow your career. You need Excel. It will give you job, make you essential at your job and bring you tremendous career success.

If you are a new comer in Excel or after all these years of random use of Excel you want to start back learning Excel systematically, this course is for you. This is a 16 Hours course that will build you the skills and level of confidence you need to succeed in your career.

What will you learn?
- Fundamentals of Quantitative Analysis, Database and Programming
- Essential Data Recording and Management Skills in Excel
- Numeric Data Analysis, Reporting and Presentations using Visuals
- Essential and Advanced Functions and Formulas
- Essential Office Skills – Page Layout, Printing, View, Sharing and Protection
- Advance templates, tools and applications
- Macros, Add-ins and Visual Basic Coding

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:

Introduction
Introduction to Microsoft Excel 2013
Tabs, Ribbons and Commands
Accessing Commands with Keyboards
Backstage File Management

Options & Customization
Excel Options
Quick Access Toolbar
Menu Customization
View Tab

Data and Numbers
Data Entry Basics and Tips
Clipboard, Font and Alignment
Number and Styles
Cells and Editing

Looks and Prints
Themes, Colours, Fonts and Effects
Margin, Orientation and Page Size
Scale-to-fit and Shit Options
Printing Workbooks

Number Basics
Introduction to Quantitative Analysis
Arithmetic
Fractions and Decimal
Percentages and Ratios

Algebra, Equations and Formulae
Introductory Definitions
Algebraic Notations
Solving Equations
Formulae

Basic Business Applications
Currency & Exchange Rates
Discounts and Commission
Simple and Compound rates
Pay and Taxation

Excel Functions and Formulas
Defined Names
Formula Auditing
Calculation and Formula Protection

Data Management
Sorting and Filtering
Data Tools
Outline
External Data

Essential Functions
Function Library
Introduction to Statistics
Statistical Functions
Date and Time Functions

Advanced Functions
Introduction to Database
Vlookup Function
Match Function
Index Function

Advanced Functions II
IF
Nested IF
IF with And
IF with OR

Data Presentation
Charts and Sparkline
Pivot Table
Pivot Charts

Macros
Creating Macros
Editing Macro Codes

Controls
Combo Box and List Box
Spin Button and Scroll Bar
Check Box, Options and Group

User Defined Functions
Modules in VB
Creating Functions
Saving Functions as Add-ins

Extras
Cases
Example Files
Practical Problem Solution

Related Courses

Abu Shams Mahmood Arif
  • Friday, July 7, 2017

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

IT
Muhammad Arif-ur-Rahman
  • 7 - 8 Jul 2017 (2 Days)

If you are a new comer in Excel or after all these years of ...

IT
Mostofa Monower
  • 8 - 21 Jul 2017 (4 evenings)

This training program builds upon advanced level knowledge ...

IT
Muhammad Arif-ur-Rahman
  • 9 - 18 Jul 2017 (4 session)

Advanced Microsoft Excel 2007 & 2010 course to develop ...

IT

Contact

9140345, 9117179

certificate@bdjobs.com

Bdjobs.com Ltd.

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

Participants should be experienced users of Microsoft Excel. Logical reasoning and fundamental IT skills are essential to successfully achieve the outcomes of the course.

Resource Person

Muhammad Arif-ur-Rahman

Management Consultant, Trainer and Speaker

Muhammad Arif-ur-Rahman is an independent consultant having expertise on traditional and Islamic finance, Accounting Information System, Cost Accounting, Management Information System, Project Management, Data Driven Business Research, Quality Management, Business Process Outsourcing, Business Deve.....

Courses from this trainer 200

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.