CFCC - CTS 130 - Spreadsheets
38 videos • 516 views • by Adam Gaweda
1
Setting Up a Cengage SAM Account
Adam Gaweda
Download
2
[Private video]
Download
3
What is a Table?
Adam Gaweda
Download
4
Formatting Workbook Text and Data
Adam Gaweda
Download
5
Basic Calculations in Excel
Adam Gaweda
Download
6
Formatting Excel 2013 Chart Elements
Adam Gaweda
Download
7
Sorting Data
Adam Gaweda
Download
8
Number Filters
Adam Gaweda
Download
9
Adding a Slicer
Adam Gaweda
Download
10
Total Rows and Subtotals
Adam Gaweda
Download
11
Creating a PivotTable
Adam Gaweda
Download
12
Adding Filters to Tables
Adam Gaweda
Download
13
Creating a PivotChart
Adam Gaweda
Download
14
Grouping Worksheets
Adam Gaweda
Download
15
Arranging Multiple Worksheets
Adam Gaweda
Download
16
Referencing Cells from Different Files
Adam Gaweda
Download
17
Referencing Cells from Another Worksheet
Adam Gaweda
Download
18
Enabling the Developer Tab in Excel
Adam Gaweda
Download
19
Creating a Button for a Macro in Excel
Adam Gaweda
Download
20
Validating User Inputs in Excel
Adam Gaweda
Download
21
Naming Cells and Ranges in Excel
Adam Gaweda
Download
22
Advanced IF Functions in Excel
Adam Gaweda
Download
23
Using the AND Function in Excel
Adam Gaweda
Download
24
Nesting IF Functions inside IF Functions in Excel
Adam Gaweda
Download
25
Understanding Compound Conditionals in Excel
Adam Gaweda
Download
26
Calculating Cumulative Interest and Principal Payments in Excel
Adam Gaweda
Download
27
Choosing a Rate of Return and Calculating an Internal Return on Investment in Excel
Adam Gaweda
Download
28
Straight Line and Declining Balance Depreciation in Excel
Adam Gaweda
Download
29
Projecting Future Income in Excel
Adam Gaweda
Download
30
Tracing an Error in Excel
Adam Gaweda
Download
31
Using the Solver Add In to Find an Optimal Product Mix in Excel
Adam Gaweda
Download
32
Creating a Break Even Point in Excel
Adam Gaweda
Download
33
Creating a Two Variable Data Table in Excel
Adam Gaweda
Download
34
Developing Scenarios with the Scenario Manager in Excel
Adam Gaweda
Download
35
Importing Data from Multiple Tables into a PivotTable in Excel
Adam Gaweda
Download
36
Formatting a Web Query in Excel
Adam Gaweda
Download
37
Modifying Data Connection Properties in Excel
Adam Gaweda
Download
38
Importing Fixed Width Text into Excel
Adam Gaweda
Download