Course Curriculum
- Create Chart
- Moving a Chart
- Resizing a Chart
- Changing a Chart Type
- Editing Chart Type
- Modifying Chart Options
- Formatting a Data Series
- Changing a chart’s Source Data
- Using the Drawing Toolbar
- Formatting Objects
- Inserting Word Art
- Modifying an Smart Art
- Using Conditional Formatting
- Removing Text Data into Excel
- Importing Data from Database
- Exporting Data from Excel
- Pivot Table / Chart
- Error Checking
- Filtered Pivot Tables
- Tracing Formula
- Using of HLOOKUP Function
- Using of VLOOKUP Function
- Sorting
- Records in a List
- Using
- Auto Filler in a List
- Creating a Macro
- Running a Macro
- Editing a Macro
- Adding a menu to the Menu Bar
- Adding Buttons to a toolbar
- Locking / Unlocking Cells in a Worksheet
- Locking / Unlocking Cells in a Worksheet
- Protecting a Workbook
- Creating a Shared Workbook
- Tracking Changes to a Workbook
- Accepting & Rejecting Changes to a Workbook
- Password Protecting a Workbook
- Merging Workbooks
- Adding Subtotals to a List
- Nesting Subtotals
- Applying Advance Filters
- Adding Group & Outline Criteria to Range
- Using Data Validation
- Text to Column
- SUM
- AVERAGE
- IF
- DAY 360
- DATE ROUND
- ROUND UP
- ROUND DOWN
- COUNT
- COUNT IF
- COUNTA
- SUM IF VLOOKUP
- HLOOKUP
- MAXIMUM
- MINIMUM NOW
- TODAY
- WEEKDAY UPPER
- LOWER
- LEFT
- RIGHT
- EXACT
- ROMAN
- PROPER
- Excel CEILING Function
- Excel 2010 FLOOR Function
- PRODUCT Function Overview
- Count cells that contain negative numbers
- Count cells that contain positive numbers
- Count cells that contain odd numbers
- Count cells that contain specific text
- Count cells that contain text
- Count cells that do not contain
- Count if row meets internal criteria
- Count if two criteria match
- Count matches between two columns
- Count unique text values in a range
- Count visible rows in a filtered list
- Countif by weekday
- COUNTIFS with multiple criteria and OR logic
- Group numbers into ranges with COUNTIFS
- Summary count with percentage breakdown
- Excel DAYS360 Function
- How to Calculate Expiration Date
- Excel DATE Function
- Count cells between two numbers
- Count cells equal to
- Count cells greater than
- Count cells equal to one of many things
- Count cells equal to either x or y
- Count cells equal to case sensitve
- Count unique values in a range with COUNTIF
- Count cells not equal to
- How to use the POWER Function
- POWER Function Description:
- Excel SUMIF Function
- Excel SUMIFS
- Show and print formulas in Excel
- If NOT this or that
- If color is NOT red or green
- Excel ISERROR Function
- Financial Functions
- Pmt
- Rate
- Nper
- Pv
- Fv
- Excel MOD Function
- Averageif
- Median
- Mode
- Standard Deviation
- Large
- Small
- How to use the LOG Function
- Excel DOLLAR Function
- Excel LARGE Function
- Excel SMALL Function
- Datedif
- How to use the RANK Function
- Calculate running total
- Subtotal by color
- Subtotal invoices by age
- Sum bottom n values
- Sum columns based on adjacent criteria
- Sum Entire Column
- Sum every nth column
- Sum if between
- Sum if by year
- Sum if cell contains text in another cell
- Sum if cells contain an asterisk
- Sum if cells contain both x and y
- Sum if date is between
- Sum if date is greater than
- Sum if ends with
- Sum if equal to either x or y
- Sum if multiple criteria
- Sum if not blank
- Sum same cell in all sheets
- Sum top n values
- Sum visible rows in a filtered list
- Sumif by weekday
- SUMIFS with multiple criteria and OR logic
- nth largest value with criteria
- nth smallest value
- nth smallest value with criteria
- Basic INDEX MATCH approximate
- Basic INDEX MATCH exact
- Calculate shipping cost with VLOOKUP
- Count missing values
- Dynamic lookup table with INDIRECT
- Exact match lookup with INDEX and MATCH
- Exact match lookup with SUMPRODUCT
- Group arbitrary text value
- Group no with Vlookup
- Vlookup with 2 lookup tables
- Combined Vlookup and Hlookup
