Topics included in this one-day training are: Lookup Functions, Setting Excel Options, Chart Object Formatting, and Understanding Labels and Names.
- Course Outline
- Understanding Data Lookup Functions
- Using CHOOSE
- Using VLOOKUP
- Using VLOOKUP For Exact Matches Using HLOOKUP Using INDEX
- Using MATCH
- Understanding Reference Functions
- Using ROW And ROWS
- Using COLUMN And COLUMNS
- Using ADDRESS
- Using INDIRECT
- Using OFFSET
Setting Excel Options
- Understanding Excel Options
- Personalising Excel
- Setting The Default Font
- Setting Formula Options
- Understanding Save Options
- Setting Save Options
- Setting The Default File Location
- Setting Advanced Options
Chart Object Formatting
- Understanding Chart Object Formatting
- Selecting Chart Elements
- Using Shape Styles To Format Objects Changing Column Colour
- Changing Pie Slice Colour
- Changing Bar Colours
- Changing Chart Line Colours
- Using Shape Effects
- Filling The Chart Area And The Plot Area
- Filling The Background
- The Format Dialog Box
- Using The Format Dialog Box
- Using Themes
Understanding Labels And Names
- Creating Names Using Text Labels
- Using Names In New Formulas
- Applying Names To Existing Formulas
- Creating Names Using The Names Box
- Using Names To Select Ranges
- Pasting Names Into Formulas
- Creating Names For Constants
- Creating Names From A Selection
- Scoping Names To The Worksheet
- Using The Name
- Documenting Range Names
- Prerequisites & Certificates
What's included? •Instruction by an expert facilitator •Small interactive classes •Specialized manual and course materials •Personalized Certificate of Completion •Snacks, Beverages and lunch at Itplanit
- Cancellation Policy
Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to firstname.lastname@example.org.
- Map & Reviews
Itplanit Services Corp.
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 203 times.