This workshop is jointly organized by BITM & PONDIT. Training will be held in PONDIT.
This course is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the Bangladesh and Abroad, millions of job advertisements requiring Excel skills are posted every day. Research shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.
INTRODUCTION
Introduction
Interface
Tabs and Ribbons
Document Windows
Navigation Tips
Office Button and Save
ENTERING, EDITING AND FORMATTING DATA
Introduction
Entering Data
Fonts, Fills, and Alignment
Cut, Copy, and Paste ***
Paste Special ***
Undo and Redo
Moving, Finding, and Replacing a Value
Comments
FORMATTING NUMBERS
Introduction
Currency Format ***
Format Painter
Formatting Dates
Custom and Special Formats
MANAGING WORKSHEETS
Introduction
Naming and Moving Worksheets
Copying Worksheets
Adding, Deleting and Hiding Worksheets
Moving, Copying, Deleting and Hiding Grouped Worksheets ***
MODIFYING ROWS AND COLUMNS
Introduction
Inserting and Deleting Columns and Rows
Inserting & Deleting Cells
Inserting Multiple Columns & Rows
Modifying Cell Width and Height
Hiding and Unhiding Rows and Columns
UNDERSTANDING FORMULAS
Introduction
Using Operations
Creating Formulas
AutoSum ***
Common Formulas
Searching for Formulas
Copying Formulas
Using Relative and Absolute References
CHANGING VIEWS
Introduction
Workbook Views
Show/Hide
Zoom Features
Freeze Panes ***
Split Windows
Viewing Multiple Windows
Minimize The Ribbon
Worksheet Backgrounds
CONDITIONAL FORMATTING
Introduction
Highlight Cells Rules
Custom Formatting Rule
TABLES
Introduction
Insert a Table and Style Options
Add Rows and Columns
Perform a Function in a Table
Summarise With Pivot Table
DATA TOOLS
Introduction
Data Validation ***
Drop-Down Lists
Removing Duplicates
Text To Columns
REFERENCING FORMULAS
Introduction
Multiple Sheet References
Trace the Precedents and Dependents
RANGES AND DATES
Introduction
Cell Names
Formulas with Cell Names
Date Formulas
LOOKUPS
Introduction
VLOOKUP ***
HLOOKUP
CONDITIONAL LOGIC
Introduction
IF Statement / Nested IF
AND / OR / NOT
IFERROR
SUMIF / SUMIFS
COUNTIF & COUNTIFS
TEXT FORMULAS
Introduction
Case Formulas
Fix Number Fields
Trim Spaces
INTRODUCTION TO CHARTS
Introduction
Chart Types
Instant Chart
Update Chart
Column Chart
Picture Fill
Adjust Chart Size
Line Chart, Scatter Chart
FORMATTING CHARTS
Introduction
Chart Styles
Chart Layouts
Add Labels
Axis Options
Chart Title
Legends
Data Labels
ADDING GRAPHICS TO SPREADSHEETS
Introduction
Insert Pictures
Modifying Pictures
Insert Shapes
Insert SmartArt
OUTLINE, SORT, FILTER, AND SUBTOTAL
Introduction
Group and Ungroup
Sort Data
Sort Multiple Levels
Filter Data ***
Advanced Filter
PIVOTTABLES
Introduction
Creating PivotTables
Choosing Fields
PivotTable Layout
Filtering PivotTables
Modifying PivotTable Data
PivotCharts
PROTECTING DATA
Introduction
Workbook Passwords
Protecting Workbooks
Unlocking Cells
PRINTING
Introduction
Page Orientation
Print Area ***
Margins
Headers and Footers
Scaling
SAVING A WORKBOOK
Introduction
Save As Previous Version
Templates
Save As PDF ***
MACROS
Introduction and Macro Security
Recording a Macro
Assign a Macro to a Button or Shape
Run a Macro upon Opening a Workbook
Curriculum
Module
Business Excel
8 Hrs
Tentative Class Start
20th March, 2020
Available Seat
10 / 20
who can join
This course is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today.
