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
CompuEase works hard to schedule our training and other services around your convenience. With that in mind we have the following cancellation policy for all booked training. Notice of cancellation must be received by CompuEase 10 working days prior to the confirmed date for a no financial penalty to be incurred. Registrants who wish to reschedule their course may do so at least 10 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course.
Training Location
CompuEase Training Classroom
130 Albert Street
Suite 801
Ottawa,
ON
Canada
