Course Outline
Lessons
Course Length: 6hrs (1 Day)
Managing your data is a key to success in any business. Microsoft Excel is the standard spreadsheet application used extensively worldwide for this purpose. Excel 2016 allows users to build and calculate formulas quickly, efficiently and accurately. Excel's database functions enable users to find, extract, and analyze valuable data in order to make effective business decisions.
Learning Objectives:
In this course, you will create advanced formulas, utilize and maintain database records, and add graphic elements to your worksheets for greater visual impact. You will:
- Work with Named Ranges
- Use VLOOKUP, HLOOKUP, PMT, FV, and IF Functions
- Insert and modify graphic objects such as SmartArt and images
- Organize worksheet data with tables
- Visualize data with charts
Target Student:
This course is for individuals who are familiar with the basics of Excel and who wish to learn additional functions and tools to more fully organize and analyze their data.
Course Outline:
Section 1: Creating Advanced Formulas
Apply Range Names
Use Specialized Functions
Section 2: Analyzing Data with Logical and Lookup Functions
Use Logical Functions
Use Lookup Functions
Use Date Functions
Section 3: Organizing Worksheet Data with Tables
Create and Modify Tables
Sort and Filter Data
Section 4: Visualizing Data with Charts
Create Charts
Modify and Format Charts
Create a Trendline
Â
Section 5: Auditing Worksheets
Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Section 6: Inserting Graphics
Insert and Modify Graphic Objects
Layer and Group Graphic Objects
Incorporate SmartArt
Cancellation Policy
Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.
Training Location
CompuEase Training Classroom
130 Albert Street
Suite 801
Ottawa,
ON
Canada
