logo
আরবি ভাষা শিক্ষক প্রশিক্ষণ কোর্স - নিবন্ধন করুন এখনি! x

Training on- Excel, ERP APPLICATION DEVELOPMENT & Implementation in your Org.

  • No Rating
  • (0 Reviews)
  • 0 students enrolled

Training on- Excel, ERP APPLICATION DEVELOPMENT & Implementation in your Org.

Its’ a Business Analytics & Intelligence course in MS Excel. The WHOLE Excel Mastery Series In One! To prepare Financial Statements like Income statement, Cash flow statement and Balance sheet including dashboard preparation for MIS/Reporting.

  • No Rating
  • (0 Reviews)
  • 0 students enrolled
  • 7500.00৳
  • 10000.00৳
  • Course Includes
  • A Business Analytics & Intelligence course for FnA
  • Daily online Support
  • Free Performance Review after one Month
  • Completion Certificate


What learn

  • Its’ aBusiness Analytics & Intelligence course in MS Excel. The WHOLE Excel Mastery Series In One! From Excel Novice...
  •  prepare Financial Statements like Income statement, Cash flow statement and Balance sheet including dashboard preparat...
  •  Managing Income and Expenses, Customers & Sales, Purchase & Vendors.
  •  Reporting, Dashboard preparation and Design spreadsheets that better organize data and provide a better picture of the...
  •  Read and comprehend spreadsheets and data from other departments, vendors, and customers.
  •  Visualize, control and evaluate the data.
  •  Text, Formulas and Functions
  •  Formatting and conditional formatting
  • • Creating pivot table, charts and dashboard
  • • Developing Macros and VBA
  • • ... and much more!

Course Content

11 sections • 11 lectures •
1.1 Introduction; 1.2 Overview

Day-1: Overview of the Course

MODULE 1 – Introduction

1.1 Introduction

1.2 Overview

mb
2.1 Target Setup ;2.2 Model Formulation; 2.3 Working with rows and columns; 2.4 Working with sheets
Day-1: Overview of the Course
MODULE 2 –Planning
2.1 Target Setup
2.2 Model Formulation
2.3 Working with rows and columns
2.4 Working with sheets
2.5 Worksheets Management
2.6 Named Models/formats
2.7 Summarize all sheet name for linking
2.8 Hyperlink from Dropdown list
mb
3.1 What is a macro?; 3.2 Recording a Macro; 3.3 Practical case analysis
Day-1: Overview of the Course
MODULE 3 - Macro
3.1 What is a macro?
3.2 Recording a Macro
3.3 Practical case analysis
mb
4.1 Introduction to VBA; 4.2 Object Model; 4.3 Module Worksheets Classes; 4.4 Variables and Constants
Day-2: VBA
MODULE 4 - VBA
4.1 Introduction to VBA
4.2 Object Model
4.3 Module Worksheets Classes
4.4 Variables and Constants
DIM
SUB
END WITH
4.5 Practical case analysis
mb
5.1 Functions; 5.2 SUM Function; 5.3 Copy and Drag Formula; 5.4 More Basic Functions; 5.5 Named Ranges
Day-2: VBA & Functions
MODULE 5 - Functions
5.1 Functions
5.2 SUM Function
5.3 Copy and Drag Formula
5.4 More Basic Functions
5.5 Named Ranges
5.6 Names Constants and Formula
5.7 Shortcuts
5.8 More Shortcuts
mb
6.1 Formatting Font; 6.2 Formatting Alignment; 6.3 Formatting Borders; 6.4 Formatting Numbers; 6.5 Conditional Formatting Pre-Configured
Day-3: Functions and Formatting Technique
MODULE 6 – Conditional Formatting
6.1 Formatting Font
6.2 Formatting Alignment
6.3 Formatting Borders
6.4 Formatting Numbers
6.5 Conditional Formatting Pre-Configured
6.6 Conditional Formatting with Formula
6.7 Conditional Formatting Dialogue Box Formula Trick
mb