Gaining Productivity in Microsoft Excel

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

This course applies to clients with a knowledge of Excel that are looking to enhance the productivity by working efficiently. The tips and trick will provide the user a smart way to use Excel to his benefit. The best practices demonstrated in this course are geared towards enhancing your skills in Excel.

COURSE OUTLINE

LEARNING ABOUT KEYBOARD SHORTCUTS.

• Learn the basic keyboard shortcuts

• Use Keyboard Shortcuts in all facets of the application

• The quick analysis smart tag

• Use the tell me tool

• Data Selection Ctrl + end, or Ctrl + (down arrows)

• Using the Auto Fill features edit the custom Lists

• Using the Flash Fill tool

• Using the Fill Series Icon on the toolbar

• Creating Keyboard Shortcuts with Macro’s

• Using Name Ranges

• Using Absolute Cell reference

KNOWING THE SOFTWARE CAPABILITIES

• Overview of main Functions

• Knowing how Functions work

• Taking away Redundancy (Using Macros)

• Saving Charts as Templates

• Using 3d Sums features

• Hiding worksheets, Rows, Columns, Cells

• Using the Page Layout View

• Learning about the Forecast Sheet Icon

• Using the Smart Lookup Icon

STREAMLINING YOUR DATA

• Ensuring Data can be Streamlined

• Knowing the Data

         o Working with your data, understanding bottlenecks

         o Using Data to your advantage

• Creating formulas in a streamlined fashion

• Avoiding recreating or duplicating information

• Ease of access for all end users

• Using text to Column tool

• Using the Remove Duplicates tool

• Using the Paste special with formulas

DATA LIST MANAGEMENT

• Working with data to get to Nominal Values

• Taking Away Redundancy of Data

• Linking data instead of appending data

• Breaking down huge lists to create a series of tables

• Validating Data to Make Drop Down list

• Using the Data Analysis tool

CREATE, MODIFY YOUR VIEWS

• Modifying the quick access toolbar

• Creating a Power tab on the ribbon

• Saving your ribbons and quick access

• Setting up views as required

• Creating the Styles required and have them available

• Using Conditional Formatting

• Changing a Spreadsheet into a Table

• Converting a table to a range of data

TRACKING CHANGES ON SHARED FILES

• Sharing Files

• Adding the Track changes icons on your Ribbon or Quick Access toolbar.

• Enabling the Track Changes

• Protect sheet and Workbook as needed

INTERACTING WITH OTHER OFFICE SUITE APPLICATIONS

• Inserting Excel Data into Word

• Inserting Excel Data into PowerPoint

• Difference between linking and embedding data

Register
Price
Quantity
Total
  • 4 or more Course Participants
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 2 - 3 Course Participants
    $399
    +$51.87 HST
    $399
    +$51.87 HST
    0
    $0
  • Course Calendar Date Pricing
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 1 on 1 Training
    $499
    +$64.87 HST
    $499
    +$64.87 HST
    0
    $0
Total$0

Share This Event