Embedded Files
1 : Introduction
1 : Introduction
Why learn Excel?
Beginners guide about spreadsheets
Data entry techniques in excel
Make spreadsheet look professional
Inserting, Deleting, Modifying Rows & Columns
Work Effectively by using Cut, Copy and Paste Functions
Creating and formatting tables
Pasting Values, Formulas and Formats with Paste Special Function
Practice Workbook
2 : Formulas and Functions
2 : Formulas and Functions
Understanding formulas and the role of operators
Using common functions (e.g. SUM, AVERAGE, COUNT)
Key Excel Functions: If
Key Excel Functions: Sum, Sumif, Sumifs
Key Excel Functions: Count, Counta, Countif, Countifs
Key Excel Functions: Average & Averageif
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate
Understanding cell references and relative vs. absolute references
3 : Data Analysis
3 : Data Analysis
Creating PivotTables
Using PivotTables for data analysis
Sorting and filtering data
Using conditional formatting to highlight data
4 : Worksheet Management
4 : Worksheet Management
Setting up and using multiple worksheets within a workbook
Copying, moving, and renaming worksheets
Protecting worksheets and cells
Print preview and set up printable excel document
5 : Useful Topics
5 : Useful Topics
Insert Hyperlinks into Excel Spreadsheets
Using Excel's Freeze Panes to Handle Large Datasets
Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
The Secret to Faster Scrolling in Excel
Be even quicker: F5 + Enter
How to Add a Drop-down List in Excel
Beauty Saving - The Professional Way of Saving Files
Conditional Formatting
6 : Charts and Graphs
6 : Charts and Graphs
Introduction to Excel Charts
Beginner's Guide to Inserting Charts in Excel
Creating and formatting charts
Adding data labels and customizing chart appearance
ADVANCED
ADVANCED
All look ups function
- Combine Index Match
- IF Formulas with AND and OR
- Data validation
- What IF analysis
- Charts and graphs
- Dates function
- All about Pivot tables
- SUMIFS, COUNTIFS
- Dynamic naming
- Use of excel as a google sheet
- Tracing precedents and
dependents
- EMI calculator
- Basic Macros
- IFERROR
- Count and Counta
- Charts and graphs including waterfall, stacked column, combo and line charts
Page updated
Google Sites
Report abuse