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, PRODUCT)
Key Excel Functions: If
Key Excel Functions: Count and Counta
Key Excel Functions: Min , Max , Small and Large
Key Excel Functions: Average & Averageif
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate
Understanding cell references and relative vs. absolute references
Find and Replace formula
Practice Workbook
3 : Data Analysis
3 : Data Analysis
Creating PivotTables
Using PivotTables for data analysis
Sorting and filtering data
Using conditional formatting to highlight data
Practice Workbook
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
Practice Workbook
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
Beauty Saving - The Professional Way of Saving Files
Conditional Formatting
Practice Workbook
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
Practice Workbook
Page updated
Google Sites
Report abuse