Professional Certificate On Google Ads


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 analyzing, 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.

Microsoft Excel has numerous functions, tools and options for wide range of users. Topics of this course are of advanced nature. All the topics have real life practical application and may help users to enhance productivity and work quality.


At the end of this course, you will be able to:

  • Explore Excel Options and Apply Protections ;
  • Write Functions and Formulas using Names;
  • Apply Lookup and Reference Functions;
  • Use Advanced Data Tools;
  • Conduct What-if-Analysis and Prepare Risk Analysis Reports;
  • Explore & Apply Pivot Table, Charts and Dynamic Reporting;
  • Design Macros and Run Automation;
  • Apply Microsoft Power BI (Business Intelligence) Tools


Practical Demonstration, Group Discussion and Case Studies.

We will follow a simple, quick and easy method for learning. We will spend almost no time in discussing theories until it is extremely essential. Each module will have an intro session followed by practical examples for understanding the need and importance of the function or tools that you will learn. After that, we go for practical video demonstration followed by exercise session. You will get a sample Excel works for most of the sessions.


Hour 1 – Introduction

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


Hour 2 – Options & Customization

Excel Options Quick Access, Toolbar Menu Customization


Hour 3 – Data and Numbers

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


Hour 4 – Looks and Prints

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


Hour 5 – Number Basics

Introduction to Quantitative Analysis Arithmetic Fractions and Decimal Percentages and Ratios


Hour 6 -Algebra, Equations and Formulae

Introductory Definitions Algebraic Notations Solving Equations Formulae


Hour 7 – Basic Business Applications

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


Hour 8 – Excel Functions and Formulas

Defined Names Formula Auditing Calculation and Formula Protection


Hour 9 – Data Management

Sorting and Filtering Data Tools Outline External Data


Hour 10 – Essential Functions

Function Library Introduction to Statistics Statistical Functions Date and Time Functions


Hour 11 – Advanced Functions

Introduction to Database Vlookup Function Match Function Index Function


Hour 12 – Advanced Functions II

IF Nested IF IF with and IF with OR


Hour 13 – Data Presentation

Charts and Sparkline Pivot Table Pivot Charts


Hour 14 – Macros

Creating Macros Editing Macro Codes


Hour 15 – Controls

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


Hour 16 – User Defined Functions

Modules in VB Creating Functions Saving Functions as Add-ins



Cases Example Files Practical Problem Solution

Course Details
Training Type Live Online Training
Date May 10, 2020
Class Time 08:00 PM- 10:00 PM
No of Classes 32
Class Schedule Saturday, Monday, Wednesday
Duration 64 Hours
Last Date of Reg. May 09 ,2020
Contact 0155 777 0123
Email Us
Venue House-8, Road-4/A, Ground Floor, Dhanmondi, Dhaka.
Price 12,000 BDT 3,000 BDT
75% off if paid before May 6 ,2020
About The Trainer
Instructor Saied Rahaman
Who Should Join
  • E-commerce Entrepreneurs
  • Company Owners
  • Marketing & Brand Professionals
  • Marketing Agency Owners/Professionals
  • Online Marketers & Freelancers
  • University Students
  • Anyone interested in Online Marketing
What Will Be Provided
  • Google Ads for Business Growth Book
  • Course Materials
  • Digital Hub Solutions Ltd. Branded goodies
  • Digital Hub Solutions Ltd. branded certificate