I. Overview of Microsoft Excel
- Using Microsoft Excel
- Moving Around Excel
- Saving with Password and Protect Sheet
- Cells Note
- Cell Data Can Be Text or Value
- Entering Numbers
- Filing with a Series and Track Changes
II. Working with Cells Format and Worksheets
- Copying and Moving Cells
- Find and Replaces
- Format Cells
- Expanding Worksheet
- Format Table and Cell Styles
- Setting Column Width and Row Heights
- Hide, Unhide Worksheet, Background Picture
- Define Range Names
- Clear Data
III. Page Setup, Graphic, and Windows
- Page Setup
- Print Preview and Printing Documents
- Creating Chart
- Working with View tab
IV. Excel Formulas
1. Introduction to Formulas
- IF and IFS
- VLOOKUP and HLOOKUP
- MATCH
- INDEX
- INDIRECT
- OFFSET
- CHOOSE
- ADDRESS
- FIND and SEARCH
- LEFT, RIGHT and MID
- LEN
- SUBSTITUTE
- TEXT
- TEXTJOIN
- TRIM
- DATE
- DATEVALUE
- EOMONTH
- NETWORKDAYS
- NOW
- TODAY
- AVERAGEIF
- COUNTIF and COUNTIFS
- SUMIF and SUMIFS
- SUMPRODUCT
2. Examples of Using Formulas
- Introduction per Hour
- Calculate the Age of a person in days
- Calculate a Price Reduction
- Convert Currency
- Convert from Hours to Minutes
- Determine Gasoline Consumption
- Create Simple Calendar
- Design your own To-Do List
- Incrementing row numbers
- Convert Negative Values to Positive
- Calculate VAT Output
- Calculate Withholding Tax
- Combine Text and Numbers
- Combine Text and Date
- Combine Text and Time
- A Special Ranking List
- Determine the Average Output
- Stocks – gains and losses
- Evaluate Profitability
- Determine Percentage of Completion
- Convert Miles per Hour to Km per Hour
- Convert Feet per Minute to Meters per Second
- Convert Liters to Barrels, Gallons, Quarts, and Prints
- Convert from Fahrenheit to Celsius
- Convert from Celsius to Fahrenheit
- Calculation with Percentage
- Monitor the Daily Production Plan
- Calculate Number of flours between Two Dates
- Determine how many pieces to put in a case
- Calculate manpower required for a project
- Distribute Sales
- Calculate your Net Income
- Calculate percentage of price reduction
V. Excel Functions
1. Function of Formulas
- Logical Functions
- Text Functions
- Date and Time Functions
- Statistical Functions
- Mathematical Functions
- Database Functions
- Financial Function
- Lookup and Reference Functions
VI. Database Management and Analysis
- Database Overview
- Data Sort
- Data Filter
- Data Form
- Data Subtotal
- Data Validation
- Data Consolidate
- Pivot Table Data Pivot Table
- Using Data Group and Outline
- Using Text to Columns and Remove Duplicates
- Data Tools and Analysis
- Excel Shortcut and Function Key
