Microsoft Excel Formulas & Functions in Depth training centre in Bangladesh

New
Get 20% discount

Microsoft Excel Formulas & Functions in Depth

  • Date : Friday, June 22, 2018
  • Duration : Day(9.30am-5.30pm)
  • No. of Classes/ Sessions : Day Long
  • Last Date of Registration : 19 June, 2018
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
  • 20% OFF at Online or bKash Payment (Written Pad, Pen and Certificate Included)

Introduction

Introduction
Microsoft Excel is most widely used productivity tool in today’s corporate world and education sector. Day to day corporate analysis, reporting, tools and applications are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for office and academic activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.

How participants will benefit after the course:
HANDS ON EXPERIENCES. Most widely practiced Excel topics are covered in the course syllabus with practical exercises. Participants will do the live exercises along with the trainer to learn faster and effectively. Learning the required Excel functionalities in course will ensure participants high performance in their career and academics.

Methodology
PRACTICAL EXAMPLES, EXCERCISES & CASE STUDIES WITH Q&A DISCUSSION SESSIONS. The course is designed for practical Excel applications at participants’ works rather than theoretical notes. Theoretical notes will be provided for participants’ after course usage. Participants will go through with many examples that they can relate to their office or educational works.

Methodology

Office Productivity Series - Microsoft Excel is designed for practical applications at works rather than theoretical notes. Participants will go through with examples that they can relate to their office or educational works.

Contents of Training:

BREAKING THE EXCEL FEAR
Formula and Functions
Using Formula Bar for writing formulas Entering formulas directly in cells Using the Insert Function dialogue box Finding the appropriate function for a task Understanding Function TOOLTIP Architecture

Functions (Math and Statistics)
Adding all numbers in a range using SUM Function
Counting total numbers or texts with COUNT-COUNTA function
Finding smallest and largest values with MIN- MAX function
Finding Nth smallest and largest values
Summing data with multi conditions and criteria using SUMIF-SUMIFS
Rounding decimal numbers
Average or Mean of numbers with AVERAGE function

Functions (Text and String)
Convert texts to UPPER, LOWER or PROPER case
Technique to add NEW LINEs in cells that have formulas inside
Join multiple cell values with CONCATENATE - &
Break or extract a portion of text with LEFT-MID-RIGHT function
Search for a portion of text with FIND-SEARCH
Converting text to numbers quickly

Functions (Logical)
IF function to show certain results if specific conditions are met with
Nested IFs with multiple If-Else conditions and criteria
Join multiple criteria with logical AND-OR-NOT

Functions (Lookup)
Lookup vertically using VLOOKUP
Powerful partial VLOOKUP instead of Nested IF
Advanced Lookup using INDEX- MATCH function

Functions (Finance)
Calculate Future value of an investment with FV function
Calculate Present value of an investment with PV function

Functions (Date/Time)
Construct a Date from partial Day, Month and Year values
Construct a Date from a text format
Automatically update and show today's Date
Automatically show present Time
Calculate Addition and Difference between two Dates
Calculate Birthday age by Year, Month and Day
Find the latest and oldest date from a date list
Understanding Excel Time formatting architecture
Calculate Addition and Difference between two Times

Related Courses

Samiul Huq
  • 22 - 23 Jun 2018 (2 Days Long)

Participants will experience a first look of the latest ...

IT
Samiul Huq
  • 22 - 23 Jun 2018 (2 Days Long)

This course will walk you through the world of business ...

IT
Price 18,000 Tk + VAT
Muhammad Rabiul
  • 24 Jun - 2 Aug 2018

The course has designed to become familiar with an ...

IT
Md. Rabiul Islam
  • 25 Jun - 1 Aug 2018

IT
Executives, Managers, Teachers, Developers, Students, Researchers and people who use Microsoft Excel for their daily tasks and activities.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Abu Shams Mahmood Arif

Associate Director

Mr. Shams has been working in a leading multi-national bank for several years. His extensive work experiences are in Business Analytics & MIS, Process Re-engineering & Automation, Business Research & Development and Project Management.
He has graduated from North South University. After that he completed his MBA. His major accomplishments and contributions are Business Operations Analytics, BOLD (Six Sigma Initiative), CBS (Core Banking System), BEFTN (Bangladesh Electronic Fund Transfer Network). .

He has been a reputed public and corporate trainer for several years on subjects like Management Information System(MIS), Financial Analysis & Modeling, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.
For last several years, he has been a reputed public and corporate trainer on subjects like Business Analytics, Financial Analysis & Modeling, MIS, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.

Courses from this trainer 130

Office Productivity Series - Microsoft Excel is designed for practical applications at works rather than theoretical notes. Participants will go through with examples that they can relate to their office or educational works.