Microsoft Excel Formulas & Functions in Depth

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
  • 28 Feb - 9 Mar 2017

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

IT
Price 3,000 Tk + VAT
Abu Shams Mahmood Arif
  • Friday, March 3, 2017

Day to day advanced corporate analysis, reporting, tools ...

IT
Price 6,000 Tk + VAT
Muhammad Arif-ur-Rahman
  • 3 - 4 Mar 2017 (2 Days)

SPSS Statistics is a GUI and syntax based statistical ...

IT
Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 6 Mar - 12 Apr 2017

Certified Information Systems Auditor (CISA) is a ...

IT

Price: Tk. 3,000+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01926673098, 01847213994

workshop@bdjobs.com

Executives, Managers, Teachers, Developers, Students, Researchers and people who use Microsoft Excel for their daily tasks and activities.