BASICS LEVEL EXCEL
Introduction
Basic Calculations
Microsoft Office Button
Using worksheets effectively
Formatting text and numbers
Saving Excel 2007 files
Saving an Excel file as a PDF file
Inbuilt Functions
Sort Function
More on sort data
Formatting data as tables
Absolute and relative cell reference
Page layout and print preview
Priting: display gridlines
Condtional Formatting
Charts
Text to columns
Autofilter
INTERMEDIATE
Library functions use
Circular Reference
Turn on/off Autocomplete
How to avoid auto hyperlinks
Fill data across worksheets
How to use comments
How to remove duplicates
Template based workbook
Themes and smartart diagrams
‘IF’ function
Countif
Nested functions
Advanced filter
Named ranges
Subtotals
In-Cell Graphs
Formatting in-cell graphs
Data validation
Custom Data Validation
ADVANCED
Pivot Tables,
Using slicer Pivot table
Using Slicer Graph Charts
Vlookup/Hlookup
Goal Seek
Get external data - text files
Import data from databases
Import data from an Excel file
Array Formulas
Calculations in Word
Data tables and sensitivity analysis
Printing: Repeat specific rows
Excel Help - Vlookup
Step by step Excel macros...
MISCELLANEOUS 1
How to use comments
Convert function
Factorials
Using 3-D references
Consolidate data
SUMIFS
RANK function
Named ranges use
Advanced filter - unique records
Highlighting duplicates
Database functions
DSUM
DAVERAGE
Vlookup and calculations
Data Analysis and Vlookup
Vlookup using lists
Data Analysis and Hlookup
Left Lookups: Overcome limitations of Vlookup
Lookup functions - nested functions
Convert numerical text data into numbers
Work with Excel data containing blank rows
Lookup function
Highlight blank cells
Compound interest calculations using user form
How to copy a Word table into Excel
Insert a watermark
How to draw in Excel
CHOOSE function
SUBSTITUTE function
MISCELLANEOUS 2
Data Analysis and MATCH function
Max, Match, Vlookup and LARGE functions
analysis using Goalseek
How to avoid duplicate entries
Data validation, Named Ranges, Indirect Function
Trim function
Text functions
Link an Excel worksheet to Word
Keyboard shortcuts
Keyboard & MS-Office Ribbon
Manage Inventory
Accessing data from another workbook
Sumif&S - multiple criteria
Average if &S
Countif &s
“D”sum ,average,min,max,count
Sum product
Iferror
Istext with using Vlookup
Data entry only into specific cells
Ensure all data entries
MS-Access Table using MS-Excel data
Delete empty rows
Open a user form using a command button
Depreciation using the straight line method
Consolidate data from Excel worksheets
MISCELLANEOUS 3
Checkbox form control
Dynamic ranges
Find latest sales data
Datedif Function
Simulations using Random Function
Excel and mail merge in MS-Word
Export data from Outlook to Excel
Track changes
Interest calculations
Extracting numbers from alphanumeric text
Recover excel graph data from powerpoint slide
Financial statements
Data tables and sensitivity analysis
countif - multiple criteria
How to improve readabilty of your Excel data
Track updates
How to enter fractions
Excel tips for beginners and advanced users
Good teaching
ReplyDelete