CALL US TOLL FREE: 1-888-694-8302 OR EMAIL US: canada@edupro.ca

Email: canada@edupro.ca

Phone: 1-888-694-8302

4907 50 St ISLAY AB T0B 2J0
290 Moston Lane MANCHESTER M40 9WB
210 Pine Drive SPRUCE HOME, SK S0J 2N0
Fax: 1-506-704-2888
Email: contact@lakelandpro.ca

MICROSOFT EXCEL TRAINING SERIES

MICROSOFT EXCEL TRAINING SERIES In today's fast-paced, technical business environment, numbers are everything. Much of our success hinges on how well we can manage the data - statistics, planning, reporting - that we encounter on a daily basis. We learn how we are doing and discover our next course of action by studying numbers. An incredibly powerful tool for doing this is Microsoft Excel. Microsoft Excel is the standard spreadsheet application for both the business world and personal use.


MICROSOFT EXCEL INTERMEDIATE
  • Lesson 1: Calculating Data with Advanced Formulas
  • Topic 1A: Apply Cell and Range Names
  • Topic 1B: Calculate Data Across Worksheets
  • Topic 1C: Use Specialized Functions
  • Topic 1D: Analyze Data with Logical and Lookup Functions
  • Lesson 2: Organizing Worksheet and Table Data
  • Topic 2A: Create and Modify Tables
  • Topic 2B: Format Tables
  • Topic 2C: Sort or Filter Data
  • Topic 2D: Use Functions to Calculate Data
  • Lesson 3: Presenting Data Using Charts
  • Topic 3A: Create a Chart
  • Topic 3B: Modify Charts
  • Topic 3C: Format Charts
  • Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
  • Topic 4A: Create a PivotTable Report
  • Topic 4B: Filter Data Using Slicers
  • Topic 4C: Analyze Data Using PivotCharts
  • Lesson 5: Inserting Graphic Objects
  • Topic 5A: Insert and Modify Pictures and ClipArt
  • Topic 5B: Draw and Modify Shapes
  • Topic 5C: Illustrate Workflow Using SmartArt Graphics
  • Topic 5D: Layer and Group Graphic Objects
  • Lesson 6: Customizing and Enhancing the Excel Environment
  • Topic 6A: Customize the Excel Environment
  • Topic 6B: Customize Workbooks
  • Topic 6C: Manage Themes
  • Topic 6D: Create and Use Templates
MICROSOFT EXCEL ADVANCED
  • Lesson 1: Streamlining Workflow
  • Topic 1A: Update Workbook Properties
  • Topic 1B: Create a Macro
  • Topic 1C: Edit a Macro
  • Topic 1D: Apply Conditional Formatting
  • Topic 1E: Add Data Validation Criteria
  • Lesson 2: Collaborating with Other Users
  • Topic 2A: Protect Files
  • Topic 2B: Share a Workbook
  • Topic 2C: Set Revision Tracking
  • Topic 2D: Review Tracked Revisions
  • Topic 2E: Merge Workbooks
  • Topic 2F: Administer Digital Signatures
  • Topic 2G: Restrict Document Access
  • Lesson 3: Auditing Worksheets
  • Topic 3A: Trace Cells
  • Topic 3B: Troubleshoot Invalid Data and Formula Errors
  • Topic 3C: Watch and Evaluate Formulas
  • Topic 3D: Create a Data List Outline
  • Lesson 4: Analyzing Data
  • Topic 4A: Create a Trendline
  • Topic 4B: Create Sparklines
  • Topic 4C: Create Scenarios
  • Topic 4D: Perform a What-If Analysis
  • Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak
  • Lesson 5: Working with Multiple Workbooks
  • Topic 5A: Create a Workspace
  • Topic 5B: Consolidate Data
  • Topic 5C: Link Cells in Different Workbooks
  • Topic 5D: Edit Links
  • Lesson 6: Importing and Exporting Data
  • Topic 6A: Export Excel Data
  • Topic 6B: Import a Delimited Text File
  • Topic 6C: Import and Export XML Data
  • Lesson 7: Integrating Excel Data with the Web
  • Topic 7A: Publish a Worksheet to the Web
  • Topic 7B: Import Data from the Web
  • Topic 7C: Create a Web Query

E-mail or Fax the attached form at 1-780-701-4979 or canada@edupro.ca to register. CLICK HERE VISIT EXCEL OR WORD PRACTICE SITE < http://www.edupro.ca/WORD_EXCEL/>

CONTACT US TODAY to see how we can add your name to the list of businesses that have benefited from our services.


ADDRESS:

75 Jennings Crescent Red Deer, AB T4P 4G1

4907 50th ST ISLAY AB T0B 2J0

290 Moston Lane MANCHESTER M40 9WB ENGLAND or

Csillag Utca 50 MATRASZOLOS 3068  HUNGARY (EU)

Email: canada@edupro.ca or europe@edupro.ca

Telephone: 1-780-468-3102 or 1-306-667-3880

Fax: 1-780-701-4979

 
Arabic AR Chinese (Simplified) ZH-CN English EN French FR German DE Greek EL Hungarian HU Russian RU Spanish ES Swahili SW Vietnamese VI

Copyright © 2018 Professional Education. All rights reserved.

CALL US TOLL FREE: 1-888-694-8302 OR EMAIL US: canada@edupro.ca