We can train your staff, in your offices and cater to your specific needs.
What makes us so successful? Our hands-on personal training approach with top-notch MOS certified, expert instructors (covering the topics you need) .
Please select the Microsoft Excel 2016, 2013, 2010, 2007, 2003 topics that interest you.
Contact us or call (905) 271 1119 for more information about courses. If there is an Excel topic not listed please let us know and we can add it to the agenda (we also cover statistical functions such as CORREL which shows the coefficient or correlation between 2 data sets e.g. daily temperature and ice cream sold)
MS Excel Training Course Outlines
Listed below are some topics in MS Excel 2016, 2013, 2010, 2007 and Excel 2003. We also customize onsite Excel training Toronto, Mississauga, Oakville, Hamilton, GTA Ontario areas. If people are already using Microsoft Excel we can make very rapid progress through many topics and work on their own Excel formulas
MS Excel Training Toronto Mississauga
Microsoft Excel - Training Level 1 - Fundamentals
Training Topic A: Microsoft Excel basics
The workbook/worksheet environment
The specifications of the electronic spreadsheet
Training Topic B: Formatting a worksheet in Microsoft Excel
Formatting the worksheets
Various number formats and text alignment options
Copying and pasting formats (Format Painter)
Special and custom formatting
Insert & Modify Comments in MS Excel
Training Topic C: Entering data and navigating in a worksheet
Entering and correcting data in MS Excel worksheets
Editing cell contents
Saving a file
Navigation and movement techniques – shortcut keys
Training Topic D: Formulas & Functions in Microsoft Excel
Creating formulas (SUM, COUNT, MAX, AVERAGE, MIN etc)
Working with built-in functions
Absolute references in Excel formulas
Creating & working with Named Ranges
Training Topic E: Moving and copying data
Inserting rows and columns in MS Excel 2003/2007/2010
Moving data from cell to cell
Copying data (values and/or formulas)
Using the Fill Series feature (to create logical sequences)
Training Topic F: Printing a worksheet
Checking spelling in MS Excel
Using the Print Preview command and & page breaks
Printing a large worksheet
Training Topic G: Multiple worksheets
Setting up and using a multiple-sheet workbook
Inserting new worksheets
Outlining Spreadsheet Solutions
Microsoft Excel – Training Level 2 Intermediate
Training Topic A: Creating charts
Creating charts in MS Excel
Creating an embedded chart
Comparing chart worksheets with embedded charts
Training Topic B: Modifying charts in Microsoft Excel
Chart types – Column, Bar, Line, Pie etc.
Modifying embedded charts
Adding and deleting chart items such as values & labels
Moving and sizing chart items
Training Topic C: Formatting a chart
Formatting chart text in MS Excel
Formatting labels
Changing the format of a chart
Printing a chart sheet
Training Topic D: Using graphic objects in Microsoft Excel
Drawing graphic objects
Formatting graphic objects – Fill colour & line colour
Using graphic objects to enhance worksheets and charts
Training Topic E: Sorting data
Setting up Single-level sorting in MS Excel
Multiple-level sorting
Sorting options
Design considerations re the data table
Training Topic F: Filtering data in Microsoft Excel
Setting up and Filtering a list
Custom criteria options (AND versus OR)
Multiple-condition criteria (Advanced Filter)
Managing a filtered list
Training Topic G: Useful Functions
SUMIF to sum by specified criteria or label
SUBTOTAL function creates the Subtotal sum formulas automatically
Microsoft Excel – Training Level 3 Advanced
Topic A: Customizing the Work Area
Using Custom Tabs
Creating and Using Styles
Using Templates to save time
Training Topic B: Advanced Formula Construction
Using Named Ranges in formulas in MS Excel
Using the IF Function (multiple IFs are possible)
VLOOKUP Function to retrieve matching data
HLOOKUP Function to retrieve matching data
Using IS Functions to spot errors
Auditing the worksheet
Training Topic C: Using Pivot Tables in Microsoft Excel
Creating Pivot Tables for analysis
Modifying Pivot Tables
Grouping and Summarizing Data in a Pivot Table
Training Topic D: Working with Multiple Worksheets
Working with Workbooks
Dynamic Linking Cells in Different Worksheets or Workbooks
Excel Workspaces
Training Topic E: Consolidating and Analyzing Data
Consolidating Data from More Than One Worksheet
3D formulas for identical worksheets
Goal Seek and Solver Utilities in MS Excel
Scenario Manager to View a Worksheet with Different Input Values
Training Topic F: Using Protection and View Options
Protecting cells from changes
Using Custom Views: see data a needed
Training Topic G: Introduction to Macros in Microsoft Excel
Running Macros
Recording a basic Macro
Training Topic H: Working with Interactive Excel
Web Documents
Saving an Excel Worksheet as a Web Document
Spreadsheet Web Components
Please contact us or call 905 271 1119 for more information
Action eBiz offers Microsoft Excel 2013, 2010, 2007, training courses in Toronto, Mississauga Ontario, . In MS Excel courses trainer covers MS Excel data analysis, Microsoft Excel Charts, MS Excel pivot tables, Microsoft Excel Graphs, MS Excel sorting and filtering, MS Excel database. Microsoft Excel training also includes MS Excel formulas, Microsoft Excel VLOOKUP Function for data automation, Microsoft Excel HLOOKUP Function for data automation, Microsoft Excel marketing and sales analysis and creating MS Excel formula. We offer MS Excel training in Toronto, Mississauga, Hamilton, Brampton, Ontario, Kitchener, Waterloo, Cambridge, Canada We offer customized MS Excel training for Employees, Managers, Executives involved in Financial, Accounting, Marketing, Sales etc.. in Toronto, Mississauga, Brampton, Ontario, Kitchener, Waterloo, Hamilton, Cambridge, Canada On-site Training Microsoft MS Excel Courses Trainer Toronto Mississauga Brampton Ontario
We also offer on site training in other Microsoft Office software: MS Project, MS PowerPoint, MS Access, MS Outlook
MS Excel onsite training Toronto, Mississauga, Hamilton Ontario
http://trainingexcel.wordpress.com
http://trainingexcel.blogspot.ca
http://www.squidoo.com/trainingexcel
http://www.Exceltraininggta.weebly.com
http://training4excel.livejournal.com/380.html
Excel Training Toronto Mississauga Ontario
MS Excel 2010 Training Toronto Mississauga Ontario
Excel Training
See the Excel Post at Squidoo
Excel Forecast Function
Excel 2016 has a Forecast Sheet function that makes it easy to
turn a worksheet with past data into a Chart forecast worksheet
for the next year or so. Open the worksheet with your data, select the data then click the Forecast Sheet button (Data
Tab) – Excel does the rest for you.
Excel examines all the data in the table - usually includes
a column for dates as well as one for the related sales data). At the same time
creating a Forecast Chart with dialog box.
You define the options for a new line chart that shows past
sales and projected sales. Important to set interval which would be 12 months
if a yearly cycle. Excel then creates a line or column chart to show the trends in
its forecast. Click the Column Chart
icon to the immediate right of the Line Chart icon at the top of the Create
Forecast Worksheet dialog box. For more on Excel training in Toronto, Mississauga, Oakville, Hamilton KW Guelph area click here.
You can also set the date at which the forecast chart
ends. Do this by selecting a new date in the Forecast End text box that
appears below the preview of the embedded line or column chart. Select a
another date
