Course Outline
Pre-Requisites
Excel Level 1 or equivalent experience
Lessons
This course is designed for users with a good understanding of Excel fundamentals. The course will provide more advanced concepts required to consolidate and navigate data across multiple worksheets and workbooks. Participants will work with built-in functions such as “if statements†“vlookupâ€, “pmtâ€, “datesâ€, “statsâ€. We will analyze and organize data using charts. some functions and security. Some advanced features include creating templates, styles, conditional formatting and protecting your data.
Course Content
Overview
Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Command Shortcut Keys
Workbook Templates
Using Multiple Workbooks and Worksheets
Setting up Multiple worksheets
Copying, Moving, Deleting Worksheets
Consolidating Data
Creating Links with Formulas
Hyperlinks
Name Ranges
Paste Special – linking
Tiling – sheets, workbooks, applications
Freeze Panes
Split
View Side by Side
Review Spreadsheets
Track Changes
Comments
Functions
Function Concepts
Stats: averagea, counta
Logical: if statements, vlookup
Financial: PMT
Math: Round up, Round down
Dates: today, date
Applying Advanced Formatting
Creating Table Styles
Working with Table Styles
Creating Cell Styles
Using Conditional Formatting
Creating and Managing Conditional Formatting Rules
Charts
Creating Charts
Changing Chart Data
Resizing and Moving a Chart
Change Chart Type
Working with Chart Labels
Working with Chart Backgrounds
Changing a Chart's Source Data
Modifying Chart Elements
Using Chart Templates
Worksheet Organization
Protect Sheet
Protect Workbook
Share Workbook
Allow Users to Edit Ranges
Worksheet Security
Inspect Document
Check Compatibility
Mark as Final
Encrypt with Password
Cancellation Policy
10 business days cancellation or full course fee will be charged
Training Location
TTC, B-11 Cameron Library
11320-89 Avenue,
University of Alberta
Edmonton,
Alberta
Canada
I had a very bad experience with the instructor - he centered me out throughout the entire class - asked me continuously if I on pace or knew how to do the work. If I asked him a question he seemed anger made me feel little, stupid, he was very condescending. At one point he helped me and he said things like "this is a desktop" "do you know that?" others laughed. I almost left the course halfway through. I'm a much older person and First Nations and I'm shocked he treated me the way he did. It's like I was less of a person, discriminating, and etc.