2021 Microsoft Excel - Certification Training For... (MSO-01)
-
An Introduction to Excel for Beginners
- INTRODUCTION AND OVERVIEW
- An Introduction to Excel for Beginners
- EXCEL BASIC SKILLS
- Launching Excel
- Introduction to the Excel Interface
- Ribbons and Tabs
- The Backstage Area
- The Quick Access Toolbar
- Useful Keyboard Shortcuts
- Getting Help
- Contextual Menus and the Mini Toolbar
- Status Bar
- Exercise 01 with Solutions
- CREATING YOUR FIRST EXCEL SPREADSHEET
- Working with Templates
- Working with Workbooks and Worksheets
- Excel Shortcuts - Worksheets and Workbooks
- Saving your Excel Spreadsheet
- Custom Lists and Series Fill
- Entering and Editing Data
- Basic Number Formatting
- Navigating and Selecting Cells and Ranges
- Shortcuts - When operating within a cell in a shee...
- Exercise 02 with Solutions
- INTRODUCTION TO EXCEL FORMULAS AND FUNCTIONS
- Introduction to Functions and Formulas
- The Order of Calculation
- Counting Items in a List
- Finding Averages
- Finding the Minimum and Maximum Value
- Using Multiple Functions in a Formula
- Errors in Calculations
- Relative, Absolute and Mixed Referencing
- Exercise 03 with Solutions
- NAMED RANGES
- Creating Named Ranges
- Managing Named Ranges
- Using Named Ranges in Formulas
- Named Ranges Tips and Tricks
- Exercise 04 with Solutions
- FORMATTING NUMBERS, CELLS AND WORKSHEETS
- Formatting Numbers
- Formatting Dates
- Applying Formatting to Cells
- Formatting Columns and Rows
- Alignment
- Deleting and Clearing Formatting
- Themes and Styles
- Using the Format Painter
- Exercise 05 with Solutions
- WORKING WITH EXCEL LISTS
- How to Structure a List
- Sorting a List (Single-level sort)
- Sorting a List (Multi-level sort)
- Sorting using Custom Lists
- Using Auto-Filter to Filter a List
- Format As a Table
- Creating Subtotals in a List
- Flash Fill
- Exercise 06 with Solutions
- MOVING AND LINKING TO DATA
- Cut Copy and Paste Basics
- Paste Options
- Using the Clipboard
- Linking to cells in other Worksheets
- 3D Referencing
- Inserting Hyperlinks to Worksheets
- Exercise 07 with Solutions
- USEFUL FUNCTIONS
- The VLOOKUP Function (Exact Match)
- The VLOOKUP Function (Approx Match)
- The HLOOKUP Function
- Error Handling in Formulas
- Logical Functions - Part 1
- Logical Functions - Part 2
- COUNTIF and SUMIF
- Text Functions
- Date and Time Functions
- Exercise 08 with Solutions
- ANALYZING DATA WITH CHARTS
- Creating Charts to Present Data
- Formatting a Chart
- Other Useful Charts
- Updating Charts
- Exercise 09 with Solutions
- SORTING AND FILTERING DATA
- Sorting Data
- Filtering Data
- Exercise 10 with Solutions
- CONDITIONAL FORMATTING
- Highlight Cell Rules
- Data Bars
- Color Scales
- Icon Sets
- Exercise 11 with Solutions
- INSERTING ITEMS INTO A SPREADSHEET
- Inserting Pictures
- Inserting Shapes
- Inserting Icons and 3D Models
- Inserting SmartArt
- Inserting Screenshots
- Inserting Comments and Notes
- Exercise 12 with Solutions
- WORKING WITH VIEWS AND ZOOM
- Workbook Views
- Zooming in and Out of a Worksheet
- Arranging Workbooks and Worksheets
- Freezing Panes
- Exercise 13 with Solutions
- PAGE LAYOUT AND PRINTING OPTIONS
- Margins and Orientation
- The Print Area
- Page Breaks
- Print Titles-and-Background
- Headers-and-Footers
- Printing a Workbook
- Exercise 14 with Solutions
- FINALIZING YOUR SPREADSHEET
- Protecting Workbooks and Worksheets
- Spell Checking
- Inspecting the Workbook
- Saving in Different Formats
- Sharing a Workbook
- Exercise 15 with Solutions
- BONUS LECTURE AND COURSE CLOSURE
- Bonus Lecture and Course Closure
- Course info
