uCertify

BIS-340v1: Advanced Spreadsheet Applications

(UOP-BIS340v1.AD1) / ISBN : 978-1-61691-069-3
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Data Analysis Fundamentals

  • Topic A: Introduction to Data Science
  • Topic B: Create and Modify Tables
  • Topic C: Sort and Filter Data
2

Visualizing Data with Excel

  • Topic A: Visualize Data with Charts
  • Topic B: Modify and Format Charts
  • Topic C: Apply Best Practices in Chart Design
3

Analyzing Data with Formula, Functions and Pivot Tables

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

Visualizing Data Geospatially and with Dashboard

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

Performing Statistical Analysis and Transforming Data

  • 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

1

Data Analysis Fundamentals

  • Analyzing Data
  • Creating and Modifying a Table
  • Sorting and Filtering Data
2

Visualizing Data with Excel

  • Creating Charts
  • Modifying and Formatting Charts
  • Applying the Best Practices of Chart Design
3

Analyzing Data with Formula, Functions and Pivot Tables

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

Visualizing Data Geospatially and with Dashboard

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

Performing Statistical Analysis and Transforming Data

  • 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

Related Courses

All Courses