uCertify

CSC 175 DATABASES AND SPREADSHEETS

(ASU-CSC175.AD1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

Working with Functions

  • 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
2

Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data
3

Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting
4

Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features
5

Using PivotTables and PivotCharts

  • 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
A

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

B

Appendix B: Financial Functions

C

Appendix C: Working with Graphical Objects

  • Topic A: Insert Graphical Objects
  • Topic B: Modify Graphical Objects
  • Topic C: Work with SmartArt
9

Working with Multiple Worksheets and Workbooks

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data
10

Sharing and Protecting Workbooks

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks
11

Automating Workbook Functionality

  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros
12

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • Topic A: Use Lookup Functions
  • Topic B: Use Dynamic Arrays and Dynamic Array Functions
  • Topic C: Trace Cells
  • Topic D: Watch and Evaluate Formulas
13

Forecasting Data

  • 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
14

Creating Sparklines and Mapping Data

  • Topic A: Create Sparklines
  • Topic B: Map Data
D

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

E

Appendix B: Cube Functions

F

Appendix C: Importing and Exporting Data

  • Topic A: Import and Export Data
G

Appendix D: Internationalizing Workbooks

  • Topic A: Internationalize Workbooks
H

Appendix E: Working with Power Pivot

  • Topic A: Work with Power Pivot
I

Appendix F: Advanced Customization Options

  • Topic A: Customize Advanced Options
J

Appendix G: Working with Forms and Controls

  • Topic A: Work with Forms and Controls
K

Appendix H: Using Array Formulas

  • Topic A: Use Array Formulas
23

Getting Started with Access 2021

  • 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 
24

Creating Tables

  • Topic A: Plan an Access Database
  • Topic B: Start a New Access Database
  • Topic C: Create a New Table
  • Topic D: Establish Table Relationships
25

Creating Queries

  • Topic A: Create Basic Queries
  • Topic B: Perform Calculations in a Query
  • Topic C: Sort and Filter Data in a Query
26

Creating Forms

  • Topic A: Start a New Form
  • Topic B: Enhance a Form
27

Creating Reports

  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout
L

Appendix A: Microsoft® Office Access® 2021 Common Keyboard Shortcuts

1

Working with Functions

  • 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
2

Working with Lists

  • Filtering the Data for all Employees
  • Creating a Custom Filter
  • Using Database Functions
3

Analyzing Data

  • Converting the Data into a Table
  • Applying a Quick Style to a Table
  • Adding New Entries to a Table
4

Visualizing Data with Charts

  • 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
5

Using PivotTables and PivotCharts

  • 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
6

Working with Multiple Worksheets and Workbooks

  • Creating Links
  • Creating External Links
  • Creating a 3-D Formula
  • Consolidating Data
7

Sharing and Protecting Workbooks

  • 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
8

Automating Workbook Functionality

  • 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
9

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • 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
10

Forecasting Data

  • Creating a Two-Variable Data Table
  • Creating a Forecast Sheet
11

Creating Sparklines and Mapping Data

  • Creating Sparklines
12

Getting Started with Access 2021

  • 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
13

Creating Tables

  • Creating a New Database
  • Creating a New Table
  • Preparing Keys for Table Relationships
  • Establishing Table Relationships
14

Creating Queries

  • 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
15

Creating Forms

  • 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
16

Creating Reports

  • Creating a Simple Report
  • Using the Report Wizard
  • Enhancing a Report Layout

Related Courses

All Courses