Description

Overview

This course will teach students about information systems risk. Topics covered include risk identification, assessment, evaluation, response, and monitoring, as well as information systems control design and implementation.

Series Taught By: John Glover

Available CEUs for Course Series Completion: 6
Students can earn up to 6 CEUs for fully completing this course series. This information will be displayed on the certificate of completion. Learn More

Course Details

  • 09:11:00 Hours
  • 12 Months Access
  • Presented by highly qualified, industry leading experts

About this Course

Excel 2016 Advanced explores ways to enhance Excel workbooks with topics in analyzing data, collaborating and workbook security, and adding graphical elements. This series covers important Excel functionality such as format as table, conditional formatting, shared workbooks and tracked changes, and data validation. While Excel 2016 Advanced is a continuation from the Excel 2016 Essentials series, it can be viewed as a standalone show for users looking to excel to the next level of skills. This series is specifically for locally installed Excel 2016 on Windows operating system.

Objectives

  • Analyse data with functions
  • Analyse data using functions and PivotTables
  • Work with tables
  • Create advanced formulas

Audience

  • This course is aimed at the general office worker working on Office daily.

Prerequisites

  • Managing and organizing worksheets
  • Editing and formatting Excel data
  • Printing and saving Excel files
  • Using absolute, relative, and mixed references
  • Using formulas and functions in a worksheet

Course Outline

Top of Form

ANALYZE DATA

  • Overview
  • Sort and Filter
  • Conditional Formatting
  • Outline and Subtotals
  • Tables
  • Data Tables
  • Consolidate Data
  • Scenarios
  • Goal Seek
  • Remove Duplicates
  • Advanced Filter

GRAPHICAL ELEMENTS

  • Image: Basics
  • Images: Format
  • Shapes: Add and Format
  • Shapes: Multiple Shapes and Icons
  • Smart Art
  • Create an Invitation

COLLABORATION AND SECURITY

  • Shared Workbooks
  • Track Changes
  • Data Validation
  • Workbook Security
  • Document Properties

ADDITIONAL TOPICS

  • Customize Interface