Course curriculum
-
-
Ask Questions
-
Course Exercise Files
-
Certificate of Completion
-
-
-
Launching Excel
-
Microsoft Excel Startup Screen
-
Introduction to the Excel Interface
-
Customizing the Excel Quick Access Toolbar
-
More on the Excel Interface
-
Understanding the Structure of an Excel Workbook
-
Saving an Excel Document
-
Opening an Existing Excel Document
-
Common Excel Shortcut Keys
-
Quiz 1: Excel Fundamentals Quiz
-
-
-
Entering Text to Create Spreadsheet Titles
-
Working with Numeric Data in Excel
-
Entering Date Values in Excel
-
Working with Cell References
-
Creating Basic Formulas in Excel
-
Relative Versus Absolute Cell References in Formulas
-
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
-
Quiz 2: Entering and Editing Text and Formulas Quiz
-
-
-
The structure of an Excel Function
-
Working with the SUM() Function
-
Working with the MIN() and MAX() Functions
-
Working with the AVERAGE() Function
-
Working with the COUNT() Function
-
Adjacent Cells Error in Excel Calculations
-
Using the AutoSum Command
-
Excel's AutoSum Shortcut Key
-
Using the AutoFill Command to Copy Formulas
-
Quiz 3: Basic Excel Functions Quiz
-
-
-
Moving and Copying Data in an Excel Worksheet
-
Inserting and Deleting Rows and Columns
-
Changing the Width and Height of Cells
-
Hiding and Unhiding Excel Rows and Columns
-
Renaming an Excel Worksheet
-
Deleting an Excel Worksheet
-
Moving and Copying an Excel Worksheet
-
Quiz 4: Modifying Worksheets Quiz
-
-
-
Working with Font Formatting Commands
-
Changing the Background Color of a Cell
-
Adding Borders to Cells
-
Formatting Data as Currency Values
-
Formatting Percentages
-
Using Excel's Format Painter
-
Creating Styles to Format Data
-
Merging and Centering Cells
-
Using Conditional Formatting
-
Quiz 5: Formatting Data Quiz
-
About this course
- Free
- 216 lessons
- 17.5 hours of video content