CSE 148 at Miami University

Uh oh! Curriculum schedule or syllabus needed.
Click here to upload! Here's how this abides by academic integrity.

Excel Exam 1 Cram Kit

Unlock Exam Kit ($33.33)

Cell References 3 Concepts | 1 Practice Exercise Sample Module

Expand

Module Content

0% Complete 0/3 Steps

Relative

Absolute

When to use relative vs. absolute?

Cell References – Practice!

Basic Calculations 6 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/6 Steps

Basic Calculations – Practice!

Advanced Calculations 5 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/5 Steps

Advanced Calculations – Practice!

Working with Dates 3 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/3 Steps

YEAR, MONTH, DAY

WEEKDAY

WORKDAY

Working with Dates – Practice!

VLOOKUP 1 Concept | 1 Practice Exercise

Expand

Module Content

0% Complete 0/1 Steps

VLOOKUP

VLOOKUP – Practice!

Excel Charts 8 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/8 Steps

Why are Excel charts necessary?

How to create an Excel chart

Insert Excel chart title

Change style of Excel chart

Edit the axis of Excel chart

Add data labels to Excel chart

Add trendline in Excel chart

Select data range for Excel chart

Excel Charts – Practice!

Text files 2 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/2 Steps

Why use text files?

How to import a text file

Text files – Practice!

Practice Excel Exam 1, Module 1

Practice Excel Exam 1, Module 2

Practice Excel Exam 1, Module 3

Practice Excel Exam 1, Module 4

Excel Exam 2 Cram Kit

Unlock Exam Kit ($33.33)

AND vs. OR 2 Concepts | 1 Practice Exercise Sample Module

Expand

Module Content

0% Complete 0/2 Steps

AND

AND vs. OR – Practice!

Advanced IFs 4 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/4 Steps

IFERROR

What if you have multiple conditions?

Nested IFs

IFS

Advanced IFs – Practice!

HLOOKUP 1 Concept | 1 Practice Exercise

Expand

Module Content

0% Complete 0/1 Steps

HLOOKUP

HLOOKUP – Practice!

Excel Tables 6 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/6 Steps

Why use Excel Tables?

Create an Excel Table

Excel Tables – Practice!

PivotTables 13 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/13 Steps

Why use PivotTables?

Create a PivotTable

Assign rows / columns

Specify values for rows / columns + Slicers

Assign sub-rows / sub-columns

Top / Bottom results

Filter for records that meet condition

Place “all other values” in a different column

Handling no data in row / column

Order rows / columns

Percentages for rows / columns

Group records in range of values

Calculated field

PivotTables – Practice!

COUNTIF, SUMIF, AVERAGEIF 4 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/4 Steps

What do COUNTIF, SUMIF, & AVERAGEIF do?

COUNTIF

SUMIF

AVERAGEIF

COUNTIF, SUMIF, AVERAGEIF – Practice!

SUMPRODUCT 1 Concept | 1 Practice Exercise

Expand

Module Content

0% Complete 0/1 Steps

SUMPRODUCT

SUMPRODUCT – Practice!

3D Cell References 1 Concept | 1 Practice Exercise

Expand

Module Content

0% Complete 0/1 Steps

3D Cell References

3D Cell References – Practice!

Practice Excel Exam 2, Module 1

7 min

Practice Excel Exam 2, Module 2

13 min

Practice Excel Exam 2, Module 3

5 min

Practice Excel Exam 2, Module 4

17 min

Practice Excel Exam 2, Module 5

3 min

Access Exam Cram Kit
1 hr 52 min

Unlock Exam Kit ($33.33)

Practice Access Exam, Module 1 – Query (Design View)

17 min

Practice Access Exam, Module 2 – Relationships

5 min

Practice Access Exam, Module 3 – Query (Design View)

23 min

Practice Access Exam, Module 4 – Query (SQL)

30 min

Practice Access Exam, Module 5 – Data Analysis

37 min

CSE 148

Excel Exam 1 Cram Kit

Excel Exam 2 Cram Kit

Access Exam Cram Kit 1 hr 52 min

Connect with us!

Access Exam Cram Kit
1 hr 52 min