X
GO
YLFL public schedule - Instructor-Led Live Online Training
/Portals/0/NADevEventsImages/Excel1_80.png

Excel® Beginning to End

Event Start Date: 5/2/2017 10:00 AM

Event End Date: 5/4/2017 2:00 PM

Average Rating:

Click here to create or view existing reviews.

This course is available to be streamed live online
Email Me A Reminder About This Event:
Email Me!
Sign Up To This Event
There are currently 50 spaces left.
Cost per place: CAD $395.00

Excel® Beginning to End

Course Outline

Part I
Section 1
In this section you will learn:
What Microsoft Office Excel 2007-2010 is
What’s new in Excel 2007-2010
You will also learn how to:
Open and interact with Excel
Close Excel
Create new workbooks
Open and close existing workbooks
Save workbooks
Recognize the different Excel file types
Recognize and work with the active cell
Select multiple cells
Explore worksheets and workbooks
Zoom in and out of a worksheet
Open and use the Help interface
Recognize the difference between online and offline Help
Get help while in a dialog box
 
Section 2
In this section you will learn how to:
Work with the Quick Access Toolbar
Add and remove buttons on the Quick Access Toolbar
Use the File (Backstage) menu
You will also learn about the:
ome tab
Insert tab
Page Layout tab
Formulas tab
Data tab
Review Tab

Section 3
In this section you will learn how to:
Work with columns, rows, cells, and ranges
Create worksheet labels
Enter and delete data
Print a worksheet
Use AutoFill, AutoSum, and AutoComplete
Work with basic formulae
Drag and drop cells
Cut, copy, and paste cells
Use the Clipboard and Paste Special
Insert and delete cells, rows, and columns
Use undo, redo, and repeat
Use Smart Tags
Use the error option button
Use the AutoFill option button
Use the Paste Option button
Use AutoCorrect
Use spell check
Use Find and Replace
Document a worksheet with comments

Section 4
In this section you will learn how to:
Change the size of rows or columns
Adjust cell alignment and rotate text
Create custom number and date formats
Use conditional formatting
Use the Format Painter
Merge adjacent cells together
Use AutoFit
Find and replace formatting
Add patterns, colors, and borders to a worksheet
Work with styles and themes
Create and format charts
Enhance charts with drawing tools
Change the chart type
Change the source data for a chart
Work with chart axes and data series
Save a chart style/layout as a template
Identify absolute and relative cell references

Section 5
In this section you will learn how to:
Use Normal view, Page Break Preview, Page Layout view, and Full Screen view
Manage a single window
Create, hide, or unhide a window
Freeze a pane
Split a worksheet to view multiple areas at once
Manage multiple windows
Switch between open workbooks
Arrange windows
Compare workbooks side by side
Reset windows
Use synchronous scrolling
Save a workspace
Print your workbook
Use Print Preview
Set printer options

PART II
Section 1
In this section you will learn how to:
Navigate around your computer using Windows Explorer
Perform some basic file management tasks in Windows Explorer
View files in Windows Explorer
Use the Navigation Pane in Windows Explorer
Use AutoRecover
Publish a workbook in PDF or XPS format
Protect an entire workbook and a single worksheet
Convert files in XLS format to the new XLSX format
Save workbooks in XLS format
Mark a workbook as final
Encrypt the contents of a workbook
Digitally sign a workbook
Manage file properties
Manage file versions
View a summary of issues that could occur when sharing the file
Use the Document Inspector, Accessibility Checker, and Compatibility Checker
Set compatibility options when working with different file formats

Section 2
In this section you will learn how to:
Understand the difference between relative and absolute cell references
Use basic mathematical operators
Use formulas with multiple cell references
Use the formula auditing commands
Fix formula errors and recognize common errors
Change error checking options
Display and print formulas
Recognize a function
Search for functions included with Excel
Add functions to your worksheet
Use some useful and simple functions
Use the IF function
Work with nested functions
Break up complex or long functions so they are easier to read
Use functions and AutoFill together
Recognize range names
Define and use range names
Use commands associated with range names
Select non-adjacent ranges in the same worksheet
Use AutoCalculate
Recognize array formulas
Define basic array formulas
Use functions with array formulas
Use the IF function in an array formula

Section 3
In this section you will learn how to:
Recognize a table and its features
Create tables from existing ranges
Modifying tables
Use items in the Table Tools contextual tab
Use the total row
Recognize records and fields
Add fields and records by inserting columns and rows
Delete records or fields
Clean up duplicate records
Sort data in a table
Create AutoFilters to perform custom filtering
Use advanced filters to fine-tune filtered records
Copy filtered records to a new location
Filter your data using wildcard characters
Validate your data against different criteria
Validate your data using lists and formulas
Recognize and use database functions

Section 4
In this section you will learn how to:
Check spelling in your worksheet
Open and browse the Research Pane
Use the thesaurus to look for synonyms
Use the translator to translate words and phrases
Set the display and editing language in Office 2010
Use themes to make your work consistent
Customize theme colors, fonts, and effects
Save and manage custom theme files
Add a text box to your worksheet
Use commands in the Drawing Tools tab
Edit text box contents
Add and edit WordArt
Add a picture to your worksheet from your computer
Search for and add Clip Art
Insert a screenshot
Recognize commands in the Picture Tools tab
Use the mini toolbar for pictures
Resize images
Move images around your worksheet
Crop images
Rotate and flip images
Describe functionality in the Format Picture dialog

Section 5
In this section you will learn how to:
Add SmartArt to your worksheet
Add text and photos to SmartArt
Use commands on the SmartArt Tools tabs
Edit existing SmartArt
Change the layout of a SmartArt diagram
Choose the color and style for a SmartArt diagram
Reset the SmartArt diagram back to its default settings
Convert a SmartArt diagram into individual shapes
Add symbols or special characters to a worksheet
Insert an equation
Use the Equation Tools tab to create custom equations
Draw and edit shapes in your worksheet
Recognize a Sparkline and its use
Add Sparklines to your worksheet
Use the commands on the Sparkline Tools tab
Edit Sparkline data
Clear Sparklines from a worksheet
Show and hide elements of your Sparkline
Change the Sparkline style
Change the Sparkline and marker colors
Set Sparkline axis options

Part III
Section 1
In this section you will learn how to:
Use automatic outlining
Display and collapse levels
Manually group data
Create subtotals
Describe scenarios
Create a scenario
Save multiple scenarios
Merge scenarios together
Create a scenario summary report
Enable data analysis tools
Identify available analysis and add-in tools
Use a one or two input data table
Use Goal Seek
Generate reports and scenarios with Solver
Change Solver values and manage constraints
Choose a solving method
Use Solver as a goal seek tool
Insert, edit, format, and use hyperlinks

Section 2
In this section you will learn how to:
Describe and create PivotTables
Use the contextual PivotTable Tools tabs
Add and remove PivotTable information using the Field List
Change the Field List layout
Pivot data
Expand and collapse data
Filter, sort, group, and refresh data
Edit a data source
Modify PivotTable row and column labels and values
Use the Layout group on the Design tab
Apply a style to a PivotTable
Change PivotTable style options
Manually format a PivotTable
Use the PivotTable Options dialog
Create and use a classic PivotTable frame
Switch to a classic PivotTable frame
Add data to a classic PivotTable
Pivot data in a classic PivotTable
Create a PivotTable based on external data
Refresh external data
Create a Slicer and use the Slicer Tools tab
Download, install, and use PowerPivot
Integrate Access and Excel data using PowerPivot
Create a PivotTable from PowerPivot data

Section 3
In this section you will learn how to:
Create a PivotChart from scratch or from an existing PivotTable
Add data to a PivotChart
Pivot chart data
Use the PivotChart contextual tabs (Design, Layout, Format, and Analyze)
Rename fields
Change the chart type
Apply a style to a chart
Manually format chart elements
Change the layout of chart elements
Create a PivotChart based on external data
Create a slicer for a PivotChart
Create a scenario-based PivotTable and PivotChart
Create a PivotChart with PowerPivot data

Section 4
Advanced Excel Tasks
In this section you will learn how to:
Use the PMT and FV functions
Understand and use logical functions
Use the IFERROR function with array formulas
Differentiate between VLOOKUP and HLOOKUP
Find an exact or approximate match with VLOOKUP
Use VLOOKUP in an array formula
Understand AutoFill lists
Create, use, modify, and delete custom AutoFill lists
Link, consolidate, and combine workbooks
Pivot consolidated data using the PivotTable and PivotChart Wizard

Expert Facilitator
  • MRI
  
 

What is live online training (LOT) and how do we do it so well?

Convinced you need an in-person class? Not comfortable with the idea of learning “online”? So were some of our students – until they attended one of our classes. We offer an extensive schedule of live, instructor-led online classes. Our instructor-led online classes allow you to attend a class from home or the office without the need to travel.
When you register for one of our instructor-led online courses you will receive:
Expert instruction from a live instructor who will guide you through the course material. This is not recorded eLearning, but a live, hands-on, interactive class. The only difference is that you and your instructor are not in the same room!
All of your course materials are shipped directly to your home or office.
Six months of post-class email support from an instructor.
Retake your class for free at any time in the future.
Access to our state-of-the-art online classroom which allows you to see and hear everything the instructor does. You can also ask questions using voice or chat at any time during the class, hear fellow student’s questions and even share your work with your instructor if you need assistance.

The best part about our instructor-led online classes is that they are guaranteed to run, even if you are the only student enrolled in the class! We are so confident your will completely enjoy your class experience that we offer a complete money-back guarantee if you are not completely satisfied. See commonly asked questions about our live, instructor-led online classes or watch a short demonstration of how our live, instructor-led online classes work.When we're talking about an online classroom, we mean a synchronous environment with a leader and participants in multiple locations speaking and interacting with one another at the same time, much as they would in a physical classroom. Participants can raise their hands, take surveys or tests, and participate in learning activities in a number of different ways. Audio is included in some products through Voice over IP, although some products provide only the collaboration and information-sharing tools and a phone is used for audio. What are the similarities and differences?  Our training organization has been using live, online training for over four years and our experience indicates that moving from the traditional classroom environment is not a difficult task. We train both employees and customers using this technology. READ MORE>

 
  Still not convinced, why not bring our course to your site with Onsite Training.  Private Group Training At Your Site
Youlearnforless specializes in providing expert training at your site for groups as small as 3 people.  Setup for most of our courses is usually simple and straight-forward and our staff guides you through the entire process. If your staff is geographically dispersed, or if you have fewer than 3 people to train, our Instructor-Led online course delivery may also be an option for your group (see above.) 
We’ve delivered training for many Fortune 500 companies – request an onsite training price quote.
View our full course catalog above.
 

 

CyberSafe

Is your staff cyber aware

CyberSec

Is your technical staff cyber certified?