Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk
* call us on 0121 248 2400
To receive updates and new
releases, subscribe today
*
* HOME * CONTACT US
* ABOUT US * HOW TO ORDER * PURCHASE ORDERS * RESELLERS * ARTICLE * VIEW BASKET
*
Featured Courses
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*

Excel 2007

By K Alliance
Excel 2007
Single User CD Course £75.00 + VAT
Buy Now
Multi User CD Course £150.00 + VAT
Buy Now
 

PACKAGE INCLUDES

  • 3 Multimedia Training CD-ROMs featuring Basic, Intermediate and Advanced Training
  • Hands-on Lab Simulations with detailed instructions


    COURSE INTRODUCTION

    Proficiency in MS Excel is practically a pre-requisite for most jobs today. Businesses use Excel for everyday tasks including expense reports, inventory, sales reports, ROI calculations, budgets, time cards, planners, purchase orders, schedules, tracking, statements, evaluations, estimates, and many more uses. The more you know about Excel, the more you will come to rely on it to assist you in becoming more productive.

    If you’re intimidated at the prospect of learning a spreadsheet product, put your mind at rest and choose the Microsoft Excel 2007 computer based training (CBT). This format takes any topic and makes it less intimidating right off the bat. Learning from the comfort of your computer means that you can work at your own pace.

    In addition, this format features self-study Microsoft Excel 2007 video training with expert instructors in full motion video. They explain the tasks and show you exactly what they’re talking about. You learn by watching videos! But our self-paced Microsoft Excel 2007 video training takes your learning to the next level because we include a simulated Excel environment where you can perform hands-on activities and get actual experience working with the program – even if you don’t have a copy of Excel installed on your computer.

    The Microsoft Excel 2007 training CD comes packed with everything you need including interactive content, assessments, videos, demos, quizzes, animations, printable courseware, and hands-on simulations.

    You will not fall behind with the Microsoft Excel 2007 training CD-ROMs because your pace is your own to set. The course is ready whenever you have the free time for studying. If it’s been a while since your last session, handy review sections will get you back on track.

    The self-paced Microsoft Excel training course is appropriate for new and existing Excel users. Existing users will appreciate learning about the new interface and major changes made with the 2007 release. In addition, many users never bother to learn about all of the features available and only know enough to get by. The interactive Microsoft Excel 2007 study course gets you past this plateau and encourages you to get the most out of MS Excel. Levels: Basic, Intermediate, and Advanced

  • COURSE OUTLINE

    Microsoft Excel 2007 Basic
    1.0 Creating a Basic Worksheet
    1.1 Explore the User Interface and the Ribbon
    1.2 Customize the Quick Access Toolbar
    1.3 Navigate and Select in Excel
    1.4 Enter Data and Save a Workbook
    2.0 Performing Calculations
    2.1 Create Basic Formulas
    2.2 Calculate with Functions
    2.3 Copy Formulas and Functions
    3.0 Modifying a Worksheet
    3.1 Manipulate Data
    3.2 Working with Cells, Columns, and Rows
    3.3 Search for Data in a Worksheet
    3.4 Spell Check a Worksheet
    4.0 Formatting a Worksheet
    4.1 Modify Fonts
    4.2 Add Borders and Color to Cells
    4.3 Change Column Width and Row Height
    4.4 Apply Number Formats
    4.5 Using Styles
    5.0 Printing Workbook Contents
    5.1 Print Workbook Contents Using Default Print Options
    5.2 Setting Page Breaks
    6.0 Managing Large Workbooks
    6.1 Format Worksheet Tabs
    6.2 Manage Worksheets in a Workbook
    6.3 Manage the View of Large Worksheets

    Microsoft Excel 2007 Intermediate
    1.0 Calculating Data with Advanced Formulas
    1.1 Manage Cell and Range Names
    1.2 Calculating Data Across Worksheets
    1.3 Analyzing Data with Logical and Lookup Functions
    2.0 Organizing Worksheet and Table Data
    2.1 Creating and Modifying Tables
    2.2 Formatting Tables
    2.3 Sorting or Filtering Worksheet or Table Data
    2.4 Calculating Data in a Table or Worksheet
    3.0 Presenting Data Using Charts
    3.1 How to Create a Chart
    3.2 Modifying Charts
    3.3 Formatting Charts
    4.0 Analyzing Data Using PivotTables and PivotCharts
    4.1 Creating a PivotTable Report
    4.2 Analyzing and Modifying a PivotTable
    5.0 Inserting Graphic Objects
    5.1 Inserting and Modifying Pictures and ClipArt
    5.2 Drawing and Modifying Shapes
    6.0 Customizing and Enhancing Workbooks and the Excel Environment
    6.1 How to Customize the Excel Environment
    6.2 Customizing Workbooks
    6.3 Managing Themes
    6.4 How to Create and Use Templates

    Microsoft Excel 2007 Advanced
    1.0 Streamlining Workflow
    1.1 Creating Macros
    1.2 Adding Macros to the Quick Access Toolbar
    1.3 Editing a Macro
    1.4 Using Conditional Formatting
    1.5 Applying Data Validation to a Worksheet
    1.6 Updating Workbook Properties
    1.7 Modifying Excel Options
    2.0 Collaborating with Others
    2.1 Protecting Files and Sharing Workbooks
    2.2 Merging Multiple Workbooks
    2.3 Adjusting Macro Settings
    2.4 Restricting Document Access
    3.0 Auditing Worksheets
    3.1 Tracing Cell Precedents and Dependents
    3.2 Troubleshooting Errors in Formulas
    3.3 Watching and Evaluating Formulas
    3.4 Creating a Data List Outline
    4.0 Analyzing Data
    4.1 Adding a Trend Line to Charts
    4.2 Create Scenarios and Performing What-If Analysis
    5.0 Working with Multiple Workbooks
    5.1 Create a Workspace
    5.2 Consolidate Data
    5.3 Managing Linked Cells in Different Workbooks
    6.0 Importing and Exporting Data
    6.1 Exporting Excel Data
    6.2 Importing a Table from Word
     
    Print Image Printer friendly version   
    Top of page
    *
    *
    A-Z COURSE LIST   PROVIDERS   CONTACT US   SITEMAP  
    *

    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk


    red arrow Website design by Aimpro UK red arrow Terms