• Excel Introduction
○ Excel - Getting Started
○ Excel - Entering Values
○ Excel - Move Around
○ Excel - Save Workbook
○ Excel - Open Workbook
○ Excel - Insert Data
○ Excel - Select Data
○ Excel - Delete Data
○ Excel - Move Data
○ Excel - Rows & Columns
○ Excel - Copy & Paste
○ Excel - Find & Replace
○ Excel - Auto Fill
○ Excel - Undo Changes
• Formatting Cells
○ Excel - Setting Cell Type
○ Excel - Move or Copy Cells
○ Excel - Setting Fonts
○ Excel - Text Decoration
○ Excel - Setting Colors
○ Excel - Text Alignments
○ Excel - Merge & Wrap
○ Excel - Apply Formatting
• Formatting Worksheets
○ Excel - Freeze Panes
○ Excel - Conditional Format
○ Excel - Highlight Cell Rules
○ Excel - Data Bars
○ Excel - Color Scales
○ Excel - Clear Rules
• Working With Formula
○ Excel - Formulas
○ Excel - Creating Formulas
○ Excel - Copying Formulas
○ Excel - Formula Reference
○ Excel - Relative References
○ Excel - Absolute References
○ Excel - Arithmetic Operators
○ Excel - Parentheses
○ Excel - Using Functions
○ Excel - Builtin Functions
○ Excel - Format Numbers
• Advanced Operations
○ Excel - Data Filtering
○ Excel - Data Sorting
○ Excel - Using Ranges
○ Excel - Data Validation
○ Excel - Using Macros
○ Excel - Printing Worksheets
○ Excel - Workbook Security
○ Excel - Data Tables
○ Excel - Pivot Tables
○ Excel - Simple Charts
○ Excel - Pivot Charts
○ Excel - Sparklines
○ Excel - Protection and Security
○ Excel - Formula Auditing
○ Excel - Remove Duplicates
• Excel Useful Resources
○ Excel - Keyboard Shortcuts
.jpg)
