VR SCHOOL
ONLINE
Nexus Home
Course Catalog
Meta-Campus
Status
Enter The Nexus
Home
Courses
Book 3: Excel 365
Curriculum
5 Sections
31 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 1: Up and Running with Excel
6
1.1
Creating a New Excel Workbook
10 mins
1.2
Getting Acquainted with Excel
10 mins
1.3
Entering Data in a Worksheet
10 mins
1.4
Quickly Entering Lists and Serial Data with the AutoFill Command
10 mins
1.5
Formatting Numbers, Dates, and Time Values
10 mins
1.6
Establishing Data-Validation Rules
10 mins
Chapter 2: Refining Your Worksheet
9
2.1
Editing Worksheet Data
10 mins
2.2
Moving Around in a Worksheet
10 mins
2.3
Getting a Better Look at the Worksheet
10 mins
2.4
Notes for Documenting Your Worksheet
10 mins
2.5
Comments for Collaborating with Others on a Workbooks
10 mins
2.6
Selecting Cells in a Worksheet
10 mins
2.7
Deleting, Copying, and Moving Data
10 mins
2.8
Handling the Worksheets in a Workbook
10 mins
2.9
Keeping Others from Tampering with Worksheets
10 mins
Chapter 3: Formulas and Functions for Crunching Numbers
7
3.1
How Formulas Work
10 mins
3.2
The Basics of Entering a Formula
10 mins
3.3
Speed Techniques for Entering Formulas
10 mins
3.4
Copying Formulas from Cell to Cell
10 mins
3.5
Detecting and Correcting Errors in Formulas
10 mins
3.6
Working with Functions
10 mins
3.7
A Look at Some Very Useful Functions
10 mins
Chapter 4: Making a Worksheet Easier to Read and Understand
3
4.1
Laying Out a Worksheet
10 mins
4.2
Decorating a Worksheet with Borders and Colors
10 mins
4.3
Getting Ready to Print a Worksheet
10 mins
Chapter 5: Advanced Techniques for Analyzing Data
6
5.1
Getting Quick Analyses from Excel
10 mins
5.2
Conditional Formats for Calling Attention to Data
10 mins
5.3
Managing Information in Lists
10 mins
5.4
Forecasting with the Goal Seek Command
10 mins
5.5
Performing What-If Analyses with Data Tables
10 mins
5.6
Analyzing Data with PivotTables
10 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content