Embedded Files
Introduction
Microsoft Excel is a competent spreadsheet and data analysis tool with a broad range of features. Excel skills are highly appreciated by employers for the variety of ways they can be leveraged. Excel skills will increase your efficiency to complete a variety of projects.
Objective
This Basic to Advanced MS Excel Training program is designed to efficiently manage spreadsheets and analyze data. This lesson is composed of some advanced Excel features. It assumes basic prior knowledge of Excel is known. This lesson will talk about the advanced customization and formatting features that allow for easier data manipulation and organization.
Schedule
Schedule
Basic to Advanced Excel
Basic to Advanced Excel
Class Begins: August 31, 2022
Class Time: 8:00 PM to 9:00 PM
Benefits
Benefits
UGC-approved certificate
A concern of Daffodil International University
Recorded Video of the sessions
Class materials
Outcomes
Outcomes
At the end of the course, participants should be able to -
Apply advanced formulas to lay data in readiness for analysis
Use advanced techniques for report visualizations
Leverage on various methodologies of summarizing data understand and apply basic principles of laying out Excel models for decision making
Training outcome for the company/organization
Training outcome for the company/organization
Will get skilled employee
Will impact on companies' Data Management System
Assessment plan
Assessment plan
Participants will submit their daily practice homework
Participants will give a quiz exam at the lecture
Course Outline
Course Outline
Day 1
Marge and Centering
Managing List & Database Concept
Creating Workbook
Data Type
Format Painter
Day 2
Cell Reference
Offset Function
Excel Functions (Basic)
Structure of Excel Function
Order of operation
Basic Excel Formulas
DAY 3
Find and Replace
Text Find & Replace
Advanced Find & Replace
Data Validation
Basic Data Validation
DAY 4
Calculation Based on Logic
IF Function (Basic)
Multiple use of IF Function in one formula
3D Formula
Sum product Functions
DAY 5
Vlookup Hlookup Functions
Index and Match Functions
Loan Calculation and financial formulas
Manage Duplicate Data
Managing Data by Group
DAY 6
Date Formulas
Mention Date inside Function
Import or Export Date by Formula
Working Day Calculation
Time-Related Functions
DAY 7
Managing Multiple Windows
Template
Formatting by Formula
Timeline
Formula Auditing
Managing Comments in Excel
DAY 8
Introduction to Excel Macro
Macro Project
Mr. Faham Kabir
Mr. Faham Kabir
Corporate Trainer
Asst. Manager, Group HR
Metrocem Group
Duration
Duration
12 Hours
Cost Per Person
Cost Per Person
1000 BDT
Instructor Portfolio
Instructor Portfolio
Faham Kabir
Corporate Trainer
Asst. Manager, Group HR
Metrocem Group
Mr. Faham Kabir is an industry expert in the Human Resource Information System (HRIS) and organizations' development through automation. He has nine years of work experience with different organizations and presently he is serving Metrocem Group as an Asst. Manager, Group HR. He has finished his BBA in HRM, MBA in HRM & MIS from Daffodil International University and also finished HRMC from IBA, Dhaka University. He has been directly involved with the training industry as a freelance trainer since 2010
Report abuse