Microsoft Excel 2007

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

Stand out from the crowd by creating perfect spreadsheets quickly and cleanly in Microsoft Excel 2007, the world’s most widely-used spreadsheet software. With lessons divided into basic, intermediate and advanced chapters, this online learning cour...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft excel training
  • Microsoft Excel
  • IT
  • MS Excel
  • Excel

Course programme

Stand out from the crowd by creating perfect spreadsheets quickly and cleanly in Microsoft Excel 2007, the world’s most widely-used spreadsheet software. With lessons divided into basic, intermediate and advanced chapters, this online learning course goes well beyond the levels of training offered by many books and classes.

Many people use Excel 2007 at home or at work, but very few know how to use the simple inbuilt tools effectively to get the best return on their effort. Don’t be one of these people! Spreadsheets are more than just a place to write down your financial information; learn how to use this powerful software to calculate, sort, analyse and report. Whether using only basic formulas or needing to create complex pivot tables and analysis tools, our Microsoft Excel 2007 Online Training will get you there.

With spreadsheets already a commonplace tool in a wide variety of workplaces, the lessons presented here will serve any learner well in their career. Some workplaces give their employees only a basic overview of Excel, which can lead to sloppy spreadsheets that actually slow workers down, rather than increase efficiency. You can shine as the star in your workplace by learning expert skills which will help you create true time-saving files.

Whether familiar with the Excel interface or a complete newcomer, this comprehensive course that will ensure every student feels comfortable using Excel 2007 to its fullest potential.

Key Learning Points

Learn the meaning of every icon on the toolbar, as well as how to use them all in creating productive and professional spreadsheets. Once you understand the tools at your disposal, you’ll be able to quickly and effectively produce detailed data records, complex financial calculators, and professional looking charts and reports.

Lessons in this course are arranged into basic, intermediate and advanced chapters, covering topics such as:

Basic Skills

  • Understanding spreadsheet layouts.
  • Entering and editing data.
  • Selecting and manipulating cells.
  • Printing.
  • Basic formulas and calculations
  • Basic Numeric functions
  • Translating data into charts
  • Altering Excel settings

Intermediate Skills

  • Setting and applying conditional formatting.
  • Autofilling cells.
  • Sorting and filtering data.
  • Creating pivot tables.
  • Using Excel for database management.
  • Finding and correcting errors.
  • Functions for working with times and dates.
  • Functions for working with text.
  • Advanced numeric functions.
  • The financial applications of spreadsheets.
  • Working between sheets and workbooks.

Advanced Skills

  • Creating forms.
  • Working with conditional calculations.
  • Importing and merging data.
  • The analytical and organisational applications of spreadsheets.
  • Using What-if Analysis and Goal Seek.
  • Advanced statistical analysis and functions.
  • Setting file permissions and security.
  • Running calculations in a database format.
  • Advanced programming using macros, VBA and XML.

And that’s only an overview! If you’ve ever wondered what a menu or toolbar button does, we will show you how to use it to work smarter, faster and more effectively in Excel 2007. All lessons are self-paced and accompanied by interactive practice and assessment activities.

Advantages of this course

By completing the Excel 2007 course, students will:

  • Become an expert in the world’s most commonly used spreadsheet software.
  • Excellent employment prospects in computer-related fields; deeper skills mean more job opportunities and higher pay.
  • Gain competence in using Excel for a variety of tasks: calculation, analysis, reporting, database management and more.
  • Save time and energy by learning to use inbuilt tools and functions effectively.
  • Use sorting tools to ensure that all data is easy to find and understand.
  • Use formulas to complete complex calculations, saving time and avoiding the possibility of manual errors.
  • Learn to use macros to make the software do more of the hard work for you.
  • Stop creating every document from scratch; create functional spreadsheets and templates that can be used again and again.
  • Fast-track your home or business administration with professional tips and tricks that you’ll love to use.

Good understanding of spreadsheet use is now an essential part of many jobs, making the Excel 2007 training an excellent choice for students wishing to increase their employability.

  • Units of study
Introduction In this course you will learn how to create Excel tables, to complete them with data, to format this data and to alter the graphic layout of tables. You will be performing calculations using simple formulas and you will familiarize yourself with the basics of chart creation and formatting.
List of Lessons:
  • Introduction to Excel
  • Data inserting and editing
  • Navigating the spreadsheet and basic settings
  • Area selection
  • Area Manipulations
  • Area inserting and deleting
  • Text and Cell Appearance Formatting
  • Number, Date and Time Format
  • Formatting Using Style Gallery
  • Files and Windows Handling
  • Printing Small Tables
  • Calculations using AutoSum and formula copying
  • Custom Formula Creation
  • Using Functions
  • Chart Creation
  • Chart Formatting
  • Spell Checking
  • Basic Excel Settings
  • Using the Help
Intermediate In this course you will learn advanced techniques for data processing (formatting, locking, using templates, advanced copying etc.). You will be creating more complex formulas and using functions belonging to the date and time and text categories and also logical, financial and database functions. You will learn how to filter sheet records and how to create Pivot Tables. You will also practice advanced chart editing.
List of Lessons:
  • Lock
  • Advanced cell formatting
  • Conditional formatting and custom format
  • Templates
  • Workbook properties and work with sheets
  • Sharing and merging workbooks
  • Comments and comparing workbooks
  • Copying options, orders and lists
  • Creating Formulas and Absolute Links
  • Errors and Dependencies of Formulas
  • Connected Sheets
  • The IF, MIN and COUNT functions
  • Functions and formulas for working with date, time
  • Functions for working with text
  • Rounding off
  • Financial Functions
  • Relation table techniques
  • Validation and sorting
  • Go to, find and replace
  • Printing large tables
  • AutoFilter, lists
  • Criteria tables and advanced filter
  • Database functions
  • Outlines and totals
  • Splitting text into columns
  • Pivot Table Creation
  • Editing Pivot Tables and Pivot Chart
  • Advanced chart editing
Advanced In this course you will learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with creating macros, with the XML format and its use in MS Excel, with security and management of permissions for accessing workbooks.
List of Lessons:
  • Work with Area Names
  • Creating a Form in a Sheet
  • Protection Options and Embedded Objects
  • Conditional Calculations
  • Conditional Calculations - SUMIF and COUNTIF
  • Working with an Array
  • Calculation Criteria in Database Functions
  • Searching in Tables by Using Functions
  • Data Import
  • Working with Microsoft Query
  • Microsoft Query Program - Complicated Queries
  • Merging Data
  • Sheet Scenarios
  • Solver
  • What-if Analysis and Goal Seek
  • Statistical Methods and Functions
  • Use and Recording of Macros
  • View and Editing VBA Code
  • Web Pages, Links and E-mail Sending
  • File Security
  • Permission Control
  • Introduction to XML Format
  • Working with Data in XML Format

Microsoft Excel 2007

Price on request