Skip to content
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Login
Sign Up
Login
Sign Up
Login
Sign Up
Home
All Programs
Computers
Software Development & Engineering
Tools
Excel 365
Excel 365
Curriculum
5 Sections
31 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 1: Up and Running with Excel
12
1.1
Creating a New Excel Workbook
1.1
Quiz for Creating a New Excel Workbook
6 Questions
1.2
Getting Acquainted with Excel
1.2
Quiz for Getting Acquainted with Excel
7 Questions
1.3
Entering Data in a Worksheet
1.3
Quiz for Entering Data in a Worksheet
7 Questions
1.4
Quickly Entering Lists and Serial Data with the AutoFill Command
1.4
Quiz for Quickly Entering Lists and Serial Data with the AutoFill Command
6 Questions
1.5
Formatting Numbers, Dates, and Time Values
1.5
Quiz for Formatting Numbers, Dates, and Time Values
6 Questions
1.6
Establishing Data-Validation Rules
1.6
Quiz for Establishing Data-Validation Rules
6 Questions
Chapter 2: Refining Your Worksheet
18
2.1
Editing Worksheet Data
2.1
Quiz for Editing Worksheet Data
5 Questions
2.2
Moving Around in a Worksheet
2.2
Quiz for Moving Around in a Worksheet
7 Questions
2.3
Getting a Better Look at the Worksheet
2.3
Quiz for Getting a Better Look at the Worksheet
7 Questions
2.4
Notes for Documenting Your Worksheet
2.4
Quiz for Notes for Documenting Your Worksheet
6 Questions
2.5
Comments for Collaborating with Others on a Workbooks
2.5
Quiz for Comments for Collaborating with Others on a Workbooks
6 Questions
2.6
Selecting Cells in a Worksheet
2.6
Quiz for Selecting Cells in a Worksheet
5 Questions
2.7
Deleting, Copying, and Moving Data
2.7
Quiz for Deleting, Copying, and Moving Data
5 Questions
2.8
Handling the Worksheets in a Workbook
2.8
Quiz for Handling the Worksheets in a Workbook
7 Questions
2.9
Keeping Others from Tampering with Worksheets
2.9
Quiz for Keeping Others from Tampering with Worksheets
6 Questions
Chapter 3: Formulas and Functions for Crunching Numbers
14
3.1
How Formulas Work
3.1
Quiz for How Formulas Work
8 Questions
3.2
The Basics of Entering a Formula
3.2
Quiz for The Basics of Entering a Formula
5 Questions
3.3
Speed Techniques for Entering Formulas
3.3
Quiz for Speed Techniques for Entering Formulas
5 Questions
3.4
Copying Formulas from Cell to Cell
3.4
Quiz for Copying Formulas from Cell to Cell
5 Questions
3.5
Detecting and Correcting Errors in Formulas
3.5
Quiz for Detecting and Correcting Errors in Formulas
6 Questions
3.6
Working with Functions
3.6
Quiz for Working with Functions
7 Questions
3.7
A Look at Some Very Useful Functions
3.7
Quiz for A Look at Some Very Useful Functions
7 Questions
Chapter 4: Making a Worksheet Easier to Read and Understand
6
4.1
Laying Out a Worksheet
4.1
Quiz for Laying Out a Worksheet
7 Questions
4.2
Decorating a Worksheet with Borders and Colors
4.2
Quiz for Decorating a Worksheet with Borders and Colors
6 Questions
4.3
Getting Ready to Print a Worksheet
4.3
Quiz for Getting Ready to Print a Worksheet
6 Questions
Chapter 5: Advanced Techniques for Analyzing Data
12
5.1
Getting Quick Analyses from Excel
5.1
Quiz for Getting Quick Analyses from Excel
7 Questions
5.2
Conditional Formats for Calling Attention to Data
5.2
Quiz for Conditional Formats for Calling Attention to Data
6 Questions
5.3
Managing Information in Lists
5.3
Quiz for Managing Information in Lists
7 Questions
5.4
Forecasting with the Goal Seek Command
5.4
Quiz for Forecasting with the Goal Seek Command
5 Questions
5.5
Performing What-If Analyses with Data Tables
5.5
Quiz for Performing What-If Analyses with Data Tables
6 Questions
5.6
Analyzing Data with PivotTables
5.6
Quiz for Analyzing Data with PivotTables
6 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Login
or
Sign Up
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Cybersecurity
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Linkedin
Instagram
Modal title
Main Content