Excel4life
Excel - Level 11 Day - 4 hours
Pre-requisites
Basic Windows Desktop
What you'll learn
• Launch Excel from Desktop
• Using the Ribbon
• Showing and Collapsing the Ribbon
• Using Shortcut Menus
• Understanding Workbooks
• Using the Blank Workbook Template
• Understanding the Fill Handle
• Using Basic Formulas
• Selecting Ranges
• Understanding Cells and Ranges
• Selecting Contiguous Ranges
• Selecting Non-Contiguous Ranges
• Editing Formulas
• Adding Worksheet Comments
• Filling a Series
• Filling a Growth Series
• Creating a Custom Fill List
• The difference between Formula & Function
• Summing Non-Contiguous Ranges
• Absolute versus Relative Referencing
• Creating Mixed References
• Using the Format Painter
• Applying Strikethrough
• Applying Number Data Type
• Calculating Dates• Opening and working on multiple Workbooks
• Customize Ribbon
• Quick Access Toolbar
• Adding Developer to Ribbon & Explaining Developer
• Excel Level 2 warmup