• No products in the basket.

MS Excel 2007 Basic to Intermediate Level Course Online

0( 0 REVIEWS )
MS Excel 2007 Basic to Intermediate Level Course Online


The Microsoft Excel 2007 Intermediate course goes a step further than the basics where individuals learn to create charts and tables. This course will teach individuals to expand on their skills learned in the first course. Learn how to use multiple worksheets and workbooks, create and apply spreadsheet templates, create and manipulate charts and use drawing tools for spreadsheets. Getting certified in Microsoft Excel 2007 Intermediate will give individuals the chance of showcasing your skills and knowledge in an office environment amongst peers and colleagues.

The Microsoft Excel 2007 Intermediate course will teach learners how to use formulas for advanced analysis, create shared workbooks, track changes in workbooks and protecting workbooks and worksheets.

The Microsoft Excel 2007 Intermediate course will give learners an understanding on how to create formulas, create and use range names, create and use outlines and add objects to chart and worksheet. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Excel 2007 Intermediate.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

  • Learn how to summarise data and correct errors in calculation
  • Learn formatting and calculation
  • Learn how to customise appearance of charts
  • Learn how to print charts separately from worksheets
  • Learn how to create an outline, showcase different groups of data

Course Titles

  • Module 01: Using Multiple Worksheets and Workbooks
  • Module 02: Advanced Formatting
  • Module 03: Outlining and Subtotals
  • Module 04: Cell and Range Names
  • Module 05: Lists and Tables
  • Module 06: Web and Internet Features
  • Module 07: Advanced Charting
  • Module 08: Documenting and Auditing
  • Module 09: Templates and Settings

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

  • The course is aimed at individuals who have basic experience of Excel 2007.
  • Students wishing to expand their skills in Microsoft Office Excel 2007.
  • The course is ideal for individuals working in an office environment.
  • Anyone interested in developing their skills in Microsoft Office Excel 2007.

Entry Requirements

  • You must be 16 or over
  • You should have a basic understanding of English and basic IT knowledge
  • You will need a computer or tablet with internet connection (or access to one)

Method of Assessment

At the end of the Microsoft Excel 2007 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.


Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2007 Intermediate.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Excel 2007 Intermediate you will be qualified to work in the following positions. The Microsoft Excel 2007 Intermediate qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to is given below.

  • Office Administrator – £17,158 per annum
  • Office Manager – £24,073 per annum
  • Receptionist – £15,961 per annum
  • Personal Assistant – £25,003 per annum
  • Project Assistant – £20,785 per annum
  • Business Executive – £23,667 per annum
  • Secretary – £19,460 per annum
  • Business Analyst – £35,543 per annum
  • Technical Support Analyst – £22,753 per annum

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for a NUS discount card
  • Free Career Support Service
  • 25% Discount on personal Statement and covering letter writing service
  • Free Access to Over 150 courses for 2 days (48 hours)
  • Free access to course before you purchase (For selected courses only)

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 147
➤ Module 01 - Using Multiple Worksheets and Workbooks
1.0 Topic A: Using Multiple Workbooks
1.1. Switch between Workbooks
1.2 Demo – A-1: Switching Between Workbooks
1.3 Demo – A-2: Copying a Worksheet to another Workbook
2.0 Topic B: Linking Worksheets with 3-D Formulas
2.1 Inserting a 3-D Reference
2.2 Demo – B-1: Creating 3-D Formulas
2.3 Adding a Watch Window
2.4 Demo – B-2: Adding a Watch Window
3.0 Topic C: Linking Workbooks
3.1 Syntax for External Links
3.2 Demo – C-1: Examining External Links in a Worksheet
3.3 Creating External Links
3.4 Demo – C-2: Creating External Links in a Worksheet
3.5 Redirecting Links
3.6 Demo – C-3: Editing Links
4.0 Topic D: Managing Workbooks
4.1 Creating a Workspace
4.2 Demo – D-1: Creating a Workspace
4.3 Unit 01 Review
➤ Module 02: Advanced Formatting
1.0 Topic A: Using Special Number Formats
1.1 Format Cells, Number Tab
1.2 Demo – A-1: Applying Special Formats
1.3 Hiding Zero Values
1.4 Demo – A-2: Controlling the Display of Zero Values
1.5 Customizing Number Formats
1.6 Custom Number Formats
1.7 Demo – A-3: Creating Custom Formats
2.0 Topic B: Using Functions to Format Text
2.1 Text Functions
2.2 Demo – B-1: Using PROPER, UPPER, and LOWER
2.3 The SUBSTITUTE Function
2.4 Demo – B-2: Using SUBSTITUTE
3.0 Topic C: Working with Styles
3.1 The Cell Styles Gallery
3.2 Creating Styles
3.3 Demo – C-1: Creating and Applying Styles
3.4 Modifying Styles
3.5 Demo – C-2: Modifying Styles
4.0 Topic D: Working with Themes
4.1 Theme Colors
4.2 Demo – D-1: Changing to a Different Theme
4.3 Creating New Theme Colors
5.0 Topic E: Other Advanced Formatting
5.1 Demo – E-1: Merging Cells
5.2 Changing Orientation of Text
5.3 Demo – E-2: Changing the Orientation of Text in a Cell
5.4 Demo – E-3: Splitting Cells
5.5 Demo – E-4: Transposing Data During a Paste
5.6 Demo – E-5: Adding and Deleting Backgrounds
5.7 Demo – E-6: Adding a Watermark
5.8 Unit 02 Review
➤ Module 03 - Outlining and Subtotals
1.0 Topic A: Outlining and Consolidating Data
1.1 Outlines (Expanded Form)
1.2 Outlines (Collapsed Form)
1.3 Demo – A-1: Creating an Outline
1.4 The Consolidate Dialog Box
1.5 Demo – A-2: Using the Consolidate Command
2.0 Topic B: Creating Subtotals
2.1 The Subtotal Dialog Box
2.2 Demo – B-1: Creating Subtotals in a List
2.3 Demo – B-2: Using Multiple Subtotal Functions
2.4 Unit 03 Review
➤ Module 04 - Cell and Range Names
1.0 Topic A: Creating and Using Names
1.1 Defining Names
1.2 Demo – A-1: Naming and Selecting Ranges
1.3 Demo – A-2: Using Names in Formulas
1.4 Create from Selection
1.5 Demo – A-3: Using the Create from Selection Command
1.6 Applying Names
1.7 Demo – A-4: Applying Names to Existing Formulas
2.0 Topic B: Managing Names
2.1 Demo – B-1: Modifying and Deleting Named Ranges
2.2 Creating a 3-D Name
2.3 Demo – B-2: Defining and Applying 3-D Names
2.4 Unit 04 Review
➤ Module - 05: Lists and Tables
1.0 Topic A: Examining Lists
1.1 Structure of a List
1.2 Demo – A-1: Examining the Structure of a List
2.0 Topic B: Sorting and Filtering Lists
2.1 Sorting a List Based on a Cell
2.2 Sorting by Multiple Columns
2.3 Demo – B-1: Sorting a List
2.4 Filtering
2.5 Demo – B-2: Filtering a List by Using AutoFilter
3.0 Topic C: Advanced Filtering
3.1 Custom AutoFilter Dialog Box
3.2 Demo – C-1: Using Custom AutoFilter Criteria
3.3 Creating a Criteria Range
3.4 Demo – C-2: Using the Advanced Filter Dialog Box
3.5 Demo – C-3: Copying Filtered Results to Another Range
4.0 Topic D: Working with Tables
4.1 Creating a Table
4.2 Demo – D-1: Creating a Table
4.3 Demo – D-2: Formatting a Table
4.4 Demo – D-3: Adding and Deleting Rows and Columns
4.5 Structured Referencing
4.6 Demo – D-4: Applying Structured Referencing
4.7 Demo – D-5: Naming Tables
4.8 The [#This Row] Argument
4.9 Demo – D-6: Creating Functions with [#This Row]
4.10 Unit 05 Review
➤ Module 06 - Web and Internet Features
1.0 Topic A: Saving Workbooks as Web Pages
1.1 Demo – A-1: Making Web Commands Available
1.2 Saving Workbooks
1.3 Demo – A-2: Saving a Workbook as a Web Page
1.4 Publishing a Web Page
1.5 Demo – A-3: Using the Publish as Web Page Dialog Box
2.0 Topic B: Using Hyperlinks
2.1 Inserting a Hyperlink
2.2 Demo – B-1: Inserting and Editing Hyperlinks
3.0 Topic C: Distributing Workbooks
3.1 Demo – C-1: Saving a Workbook as a PDF File
3.2 Sharing Workbooks by E-mail
3.3 Unit 06 Review
➤ Module 07 - Advanced Charting
1.0 Topic A: Chart Formatting Options
1.1 Format Axis: Axis Options
1.2 Demo – A-1: Adjusting the Scale of a Chart
1.3 Labeling a Data Point
1.4 Demo – A-2: Formatting a Data Point
2.0 Topic B: Combination Charts
2.1 Create a Combination Chart
2.2 Demo – B-1: Creating a Combination Chart
2.3 Creating a Trendline
2.4 Demo – B-2: Creating a Trendline
3.0 Topic C: Graphic Elements
3.1 Drawing Objects
3.2 Demo – C-1: Adding Graphic Elements
3.3 Formatting Graphic Elements
3.4 Demo – C-2: Formatting a Graphic Element
3.5 Inserting a Picture from a File
3.6 Demo – C-3: Adding a Picture to a Worksheet
3.7 Unit 07 Review
➤ Module 08 - Documenting and Auditing
1.0 Topic A: Auditing Features
1.1 Dependent and Precedent Cells
1.2 Demo – A-1: Tracing Precedent and Dependent Cells
1.3 Demo – A-2: Tracing Errors
2.0 Topic B: Comments in Cells and Workbooks
2.1 Viewing Comments
2.2 Demo – B-1: Viewing Comments in a Worksheet
2.3 Adding Cell Comments
2.4 Demo – B-2: Adding a Comment to a Cell
2.5 Document Information Panel
2.6 Demo – B-3: Adding Comments to a Workbook
3.0 Topic C: Protection
3.1 Protecting a Worksheet
3.2 Demo – C-1: Password-protecting a Worksheet
3.3 Protecting Parts of a Worksheet
3.4 Demo – C-2: Protecting Part of a Worksheet by Unlocking Cells
3.5 Using Digital Signatures
4.0 Topic D: Workgroup Collaboration
4.1 Sharing a Workbook
4.2 Demo – D-1: Sharing a Workbook
4.3 Share Workbook: Advanced Tab
4.4 Demo – D-2: Merging Workbooks
4.5 Highlighting Changes
4.6 Accepting and Rejecting Changes
4.7 Demo – D-3: Tracking Changes in a Workbook
4.8 Demo – D-4: Using the Document Inspector
4.9 Demo – D-5: Marking a Workbook as Final
4.10 Unit 08 Review
➤ Module 09 - Templates and Settings
1.0 Topic A: Application Settings
1.1 Excel Options Dialog Box
1.2 Demo – A-1: Exploring Application Settings
2.0 Topic B: Built-in Templates
2.1 New Workbook Dialog Box
2.2 Using the Sales Invoice Template
2.3 Demo – B-1: Using a Downloaded Template
3.0 Topic C: Creating and Managing Templates
3.1 Creating a Template
3.2 Demo – C-1: Creating a Template
3.3 Modifying a Template
3.4 Demo – C-2: Modifying a Template
3.5 Using an Alternate Template Location
3.6 Demo – C-3: Specifying an Alternate Template Location
3.7 Unit 09 Review
3.8 Course Closure
WhatsApp chat