Excel Beginner: Build a Strong Foundation
Start your Excel journey with confidence! Learn the interface, essential formulas, formatting, charts, and all the basic skills to become proficient in Excel.
Fundamentals of Excel
Launching Excel, workbook structure, saving files, and common shortcuts.
Read MoreModifying Worksheets
Insert/delete rows, adjust cell dimensions, hide/unhide, rename, and copy sheets.
Read MoreFormatting Data
Font, background, borders, currency/percentage, and conditional formatting.
Read MoreInserting Images & Shapes
Add images, shapes, and SmartArt to make your data visually appealing.
Read MoreFundamentals of Excel
- Launching Excel and Startup Screen
- Introduction to Excel Interface (Ribbon, Formula Bar, Status Bar)
- Quick Access Bar customization
- Workbook structure: sheets, rows, columns, cells
- Saving and opening documents
- Common shortcut keys
Entering & Editing Data
- Entering text for titles and numeric data
- Date values
- Cell references
- Creating basic formulas
- Relative vs Absolute references
- Order of operations
Basic Functions
- Structure of an Excel function
- SUM, MIN/MAX, AVERAGE, COUNT
- Error handling
- AutoSum command
- AutoFill feature
Modifying Worksheets
- Modifying data: editing and copying
- Inserting/deleting rows and columns
- Adjusting cell dimensions
- Hiding/unhiding rows and columns
- Renaming and deleting worksheets
- Moving and copying worksheets
Formatting Data
- Font formatting
- Cell backgrounds and borders
- Currency and percentage formatting
- Conditional formatting
Inserting Images & Shapes
- Inserting images
- Shapes and SmartArt for data visualization
Working with Charts
- Creating column and pie charts
- Modifying and formatting charts