.jpg){kind=logo}
UOP-BIS340v1.AD1 ISBN: 978-1-61691-069-3
BIS-340v1: Advanced Spreadsheet Applications
Self-paced · 1 year access
27 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
5 Interactive Lessons · 24 topics01 Data Analysis Fundamentals 3 topics · 3 LiveLab +
- Topic A: Introduction to Data Science
- Topic B: Create and Modify Tables
- Topic C: Sort and Filter Data
3 LiveLab in this lesson — see the labs panel →
02 Visualizing Data with Excel 3 topics · 3 LiveLab +
- Topic A: Visualize Data with Charts
- Topic B: Modify and Format Charts
- Topic C: Apply Best Practices in Chart Design
3 LiveLab in this lesson — see the labs panel →
03 Analyzing Data with Formula, Functions and Pivot Tables 8 topics · 9 LiveLab +
- Topic A: Analyze Data with Formulas and Named Ranges
- Topic B: Analyze Data with Functions
- Topic C: Implement Data Validation, Forms, and Controls
- Topic D: Create Conditional Visualizations with Lookup Functions
- Topic E: Create a PivotTable
- Topic F: Analyze PivotTable Data
- Topic G: Recording Macros
- Topic H: Running Macros
9 LiveLab in this lesson — see the labs panel →
04 Visualizing Data Geospatially and with Dashboard 5 topics · 6 LiveLab +
- Topic A: Visualize Data with PivotCharts
- Topic B: Filter Data Using Slicers and Timelines
- Topic C: Create a Dashboard in Excel
- Topic D: Create Map Charts in Excel
- Topic E: Customize Map Charts in Excel
6 LiveLab in this lesson — see the labs panel →
05 Performing Statistical Analysis and Transforming Data 5 topics · 6 LiveLab +
- Topic A: Visualize Trendlines and Sparklines with Excel
- Topic B: Analyze Data with the Data Analysis ToolPak
- Topic C: Connect to Data with Queries
- Topic D: Clean and Combine Data
- Topic E: Shape and Transform Data
6 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
27 LiveLabs- Analyzing Data
- Creating and Modifying a Table
- Sorting and Filtering Data
- Creating Charts
- Modifying and Formatting Charts
- Applying the Best Practices of Chart Design
- Analyzing Data Using Formulas
- Analyzing Data Using Functions
- Working with Logical Functions
- Implementing Data Validation
- Implementing Form Controls
- Using LOOKUP Functions
- Creating PivotTables
- Analyzing the PivotTable Data
- Creating Simple Macros
- Visualizing Data with PivotCharts
- Filtering Data Using Slicers
- Filtering Data Using Timelines
- Creating a Dashboard in Excel
- Creating Map Charts in Excel
- Formatting and Customizing Map Charts
- Visualizing Trendlines in Excel
- Visualizing Sparklines in Excel
- Installing and Activating the Data Analysis ToolPak
- Performing Statistical Analysis with the Data Analysis ToolPak
- Connecting to Data with Microsoft Power Query
- Cleaning and Combining Data using the Power Query Editor
Labs run in your browser — nothing to install.
Keep going
You might also like
Prepare for BIS-340v1: Advanced Spreadsheet Applications
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
- 27 LiveLab included
- Certificate of completion
No credit card required