.jpg){kind=logo}
ASU-CSC175.AD1
CSC 175 DATABASES AND SPREADSHEETS
Intermediate Self-paced · 1 year access
83 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
28 Interactive Lessons · 63 topics01 Working with Functions 5 topics · 12 LiveLab +
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
12 LiveLab in this lesson — see the labs panel →
02 Working with Lists 4 topics · 3 LiveLab +
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
3 LiveLab in this lesson — see the labs panel →
03 Analyzing Data 3 topics · 3 LiveLab +
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
3 LiveLab in this lesson — see the labs panel →
04 Visualizing Data with Charts 3 topics · 6 LiveLab +
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
6 LiveLab in this lesson — see the labs panel →
05 Using PivotTables and PivotCharts 4 topics · 6 LiveLab +
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
6 LiveLab in this lesson — see the labs panel →
06 Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts +
07 Appendix B: Financial Functions +
08 Appendix C: Working with Graphical Objects 3 topics +
- Topic A: Insert Graphical Objects
- Topic B: Modify Graphical Objects
- Topic C: Work with SmartArt
09 Working with Multiple Worksheets and Workbooks 3 topics · 4 LiveLab +
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
4 LiveLab in this lesson — see the labs panel →
10 Sharing and Protecting Workbooks 2 topics · 5 LiveLab +
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
5 LiveLab in this lesson — see the labs panel →
11 Automating Workbook Functionality 3 topics · 4 LiveLab +
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
4 LiveLab in this lesson — see the labs panel →
12 Using Lookup Functions, Dynamic Arrays, and Formula Auditing 4 topics · 12 LiveLab +
- Topic A: Use Lookup Functions
- Topic B: Use Dynamic Arrays and Dynamic Array Functions
- Topic C: Trace Cells
- Topic D: Watch and Evaluate Formulas
12 LiveLab in this lesson — see the labs panel →
13 Forecasting Data 4 topics · 2 LiveLab +
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
2 LiveLab in this lesson — see the labs panel →
14 Creating Sparklines and Mapping Data 2 topics · 1 LiveLab +
- Topic A: Create Sparklines
- Topic B: Map Data
1 LiveLab in this lesson — see the labs panel →
15 Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts +
16 Appendix B: Cube Functions +
17 Appendix C: Importing and Exporting Data 1 topics +
- Topic A: Import and Export Data
18 Appendix D: Internationalizing Workbooks 1 topics +
- Topic A: Internationalize Workbooks
19 Appendix E: Working with Power Pivot 1 topics +
- Topic A: Work with Power Pivot
20 Appendix F: Advanced Customization Options 1 topics +
- Topic A: Customize Advanced Options
21 Appendix G: Working with Forms and Controls 1 topics +
- Topic A: Work with Forms and Controls
22 Appendix H: Using Array Formulas 1 topics +
- Topic A: Use Array Formulas
23 Getting Started with Access 2021 6 topics · 7 LiveLab +
- Topic A: Launch Access and Open a Database
- Topic B: Use Tables to Store Data
- Topic C: Use Queries to Combine, Find, Filter, and Sort Data
- Topic D: Use Forms to View, Add, and Update Data
- Topic E: Use Reports to Present Data
- Topic F: Get Help and Configure Options in Microsoft Access
7 LiveLab in this lesson — see the labs panel →
24 Creating Tables 4 topics · 4 LiveLab +
- Topic A: Plan an Access Database
- Topic B: Start a New Access Database
- Topic C: Create a New Table
- Topic D: Establish Table Relationships
4 LiveLab in this lesson — see the labs panel →
25 Creating Queries 3 topics · 7 LiveLab +
- Topic A: Create Basic Queries
- Topic B: Perform Calculations in a Query
- Topic C: Sort and Filter Data in a Query
7 LiveLab in this lesson — see the labs panel →
26 Creating Forms 2 topics · 4 LiveLab +
- Topic A: Start a New Form
- Topic B: Enhance a Form
4 LiveLab in this lesson — see the labs panel →
27 Creating Reports 2 topics · 3 LiveLab +
- Topic A: Start a New Report
- Topic B: Enhance Report Layout
3 LiveLab in this lesson — see the labs panel →
28 Appendix A: Microsoft® Office Access® 2021 Common Keyboard Shortcuts +
Hands-On Labs Our edge
83 LiveLabs- Creating Named Ranges
- Editing Range Names
- Using an Existing Range in a Function
- Using the Formula AutoComplete Method to Enter Range Names
- Using the TODAY Function
- Calculating the Years of Service for Each Employee
- Adding the Arguments for the IF Portion of the Nested Function
- Calculating the 1 Percent Goal Bonus for Employees
- Using the NETWORKDAYS Function
- Extracting the Building Code from the Combined Field
- Extracting the Floor Code from the Combined Field
- Concatenating the Names in a Single Field
- Filtering the Data for all Employees
- Creating a Custom Filter
- Using Database Functions
- Converting the Data into a Table
- Applying a Quick Style to a Table
- Adding New Entries to a Table
- Creating a Clustered Column Chart
- Changing the Labels of the Line Chart
- Changing the Chart Type
- Creating the Combo Chart
- Adding the Trendline
- Saving a Chart as a Template
- Adding Fields to the PivotTable
- Building the PivotTable Report
- Sorting the Values
- Modifying the Formatting of the PivotTable Report
- Modifying the PivotTable Report
- Inserting a Timeline
- Creating Links
- Creating External Links
- Creating a 3-D Formula
- Consolidating Data
- Fixing the Missing Alternative Text Error by Using the Accessibility Checker
- Exporting the Workbook in the PDF File Format
- Hiding the Worksheet
- Enabling Worksheet Protection
- Hiding the Formulas
- Enabling and Configuring the Settings for Data Validation
- Checking the Worksheet For Errors In Formulas
- Finding and Fixing Invalid Data Entries
- Saving the Workbook as a Macro-Enabled Workbook
- Using the HLOOKUP Function
- Using the INDEX Function
- Using the MATCH Function
- Using the FILTER Function
- Using the SEQUENCE Function
- Using the SORT Function
- Using the LET Function
- Using the XLOOKUP Function
- Using the TRANSPOSE Function
- Using the VLOOKUP Function
- Using the UNIQUE Function
- Using the XMATCH Function
- Creating a Two-Variable Data Table
- Creating a Forecast Sheet
- Creating Sparklines
- Revising and Entering Table Data
- Preventing AutoCorrect Corrections
- Using the Find and Replace Feature
- Adding a Total Row to a Datasheet
- Sorting and Filtering Records
- Using Queries
- Using Reports
- Creating a New Database
- Creating a New Table
- Preparing Keys for Table Relationships
- Establishing Table Relationships
- Creating a Query Using the Query Wizard
- Creating a Query Using Query Design
- Performing Calculations in a Query
- Sorting a Query and Reordering Fields
- Filtering a Query Using a Comparison Operator
- Filtering a Query Using Dates
- Prompting a User for Query Parameters
- Creating a Form by Using the Form Wizard
- Creating and Testing a Form Based on a Selected Table
- Filtering and Sorting Data in a Form
- Configuring a Form Lookup Field
- Creating a Simple Report
- Using the Report Wizard
- Enhancing a Report Layout
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for CSC 175 DATABASES AND SPREADSHEETS
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 83 LiveLab included
- Certificate of completion
No credit card required