VR SCHOOL
ONLINE
Nexus Home
Course Catalog
Meta-Campus
Status
Enter The Nexus
Home
Courses
Explaining Excel Fundamentals
Curriculum
5 Sections
38 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 1: Getting Started with Spreadsheets
5
1.1
Exploring Excel’s User Interface
10 mins
1.2
Entering and Editing Data
10 mins
1.3
Handling Workbook Operations
10 mins
1.4
Managing Worksheet Tasks
10 mins
1.5
Collaborating with Others
10 mins
Chapter 2: Carrying Out Basic Calculations
6
2.1
Understanding Operators
10 mins
2.2
Exploring the Order of Operations
10 mins
2.3
Contrasting Cell References
10 mins
2.4
Replicating Formulas
10 mins
2.5
Calculating Sums
10 mins
2.6
Analyzing Data with Statistical Functions
10 mins
Chapter 3: Formatting Cells and Worksheets
13
3.1
Applying Basic Formatting Commands
10 mins
3.2
Exploring the Format Cells Dialog Box
10 mins
3.3
Applying Cell Styles
10 mins
3.4
Merging Cells
10 mins
3.5
Wrapping Text
10 mins
3.6
Tapping into Text Boxes
10 mins
3.7
Inserting Images
10 mins
3.8
Enhancing Accessibility
10 mins
3.9
Adjusting Row Heights and Column Widths
10 mins
3.10
Hiding and Unhiding Rows and Columns
10 mins
3.11
Hiding and Unhiding Worksheets
10 mins
3.12
Hiding and Unhiding Workbooks
10 mins
3.13
Modifying Page Setup
10 mins
Chapter 4: Sifting Through Data
8
4.1
Freezing Panes
10 mins
4.2
Utilizing the Sort Feature
10 mins
4.3
Removing Duplicates
10 mins
4.4
Finessing the Filter Feature
10 mins
4.5
Calculating with SUBTOTAL
10 mins
4.6
Using the AGGREGATE Function
10 mins
4.7
Summarizing Lists with the Subtotal Feature
10 mins
4.8
Jumpstarting Insights with Quick Analysis
10 mins
Chapter 5: Tackling Tables
6
5.1
Comparing Data Ranges to Excel Tables
10 mins
5.2
Creating Excel Tables
10 mins
5.3
Automating Formulas and Features
10 mins
5.4
Unpacking Table Quirks
10 mins
5.5
Troubleshooting Tables
10 mins
5.6
Converting a Table to a Data Range
10 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content