Course Content
المحتوى
0/47
Introduction to Excel
04:21
Getting Started with Excel
04:21
Creating and Opening Workbooks
04:21
Saving and Sharing Workbooks
04:21
Cell Basics in Excel
04:21
Modifying Columns, Rows, and Cells
04:21
Formatting Cells
04:21
Understanding Number Formats
04:21
Working with Multiple Worksheets
04:21
Using Find and Replace
04:21
Page Layout and Printing in Excel
04:21
Introduction to Formulas
04:21
Creating More Complex Formulas
04:21
Relative and Absolute Cell References
04:21
Using Functions in Excel
04:21
Solving Real-Life Problems in Excel
04:21
Freeze Panes and View Options
04:21
Sorting Data in Excel
04:21
Filtering Data
04:21
Using Groups and Subtotals
04:21
Creating Tables in Excel
04:21
Creating Charts
04:21
Applying Conditional Formatting
04:21
Using Comments and Co-authoring
04:21
Inspecting and Protecting Workbooks
04:21
Introduction to PivotTables
04:21
Advanced PivotTable Techniques
04:21
What-If Analysis in Excel
04:21
Quick Tip: Add the Current Date to a Cell
04:21
Quick Tip: A Faster Way to Use the Fill Handle
04:21
Quick Tip: Two Ways to Use the Format Painter
04:21
Quick Tip: A Shortcut to AutoSum
04:21
Quick Tip: Quick Access Toolbar Shortcuts
04:21
Quick Tip: How to Quickly Duplicate a Sheet
04:21
Quick Tip: Jump to Any Sheet with a Shortcut
04:21
Quick Tip: Select an Entire Row or Column
04:21
Quick Tip: Find a Sum Without Using a Formula
04:21
Quick Tip: Why You Should Avoid Merging Cells
04:21
Quick Tip: Using the Quick Analysis Tool
04:21
Quick Tip: How to Make Charts Auto Update
04:21
Quick Tip: Use Transpose to Flip Data
04:21
Quick Tip: Absolute References with the F4 Key
04:21
Quick Tip: Add a New Row with a Shortcut
04:21
Quick Tip: Use an Entire Column as a Cell Range
04:21
Quick Tip: What are Named Ranges
04:21
Quick Tip: A Trick for Finding Inconsistent Data
04:21
Final Exam - Introduction to Excel: A Beginner’s Guide
Introduction to Excel: A Beginner’s Guide

Learn about named ranges and how they can simplify your formulas.

Previous
Next
0% Complete