Menu
Menu
  • No products in the basket.

Microsoft Excel 2007 Advanced Training Course

0( 0 REVIEWS )
94 STUDENTS
ACCREDITED BY

Overview:

The Microsoft Excel 2007 Advanced course combines the basic and intermediate aspects and gives learners insight on how to analyse and manage data. This course will teach learners how to explore data analysis tools which include goal seek, formula auditing and Scenario Manager. Getting certified in Microsoft Excel 2007 Advanced course will help individuals display their Microsoft skills in an office environment and showcase their competency in Excel.

The Microsoft Excel 2007 Advanced course will teach individuals how to use pivot charts and tables, record basic macros and, format, filter and manage data lists.

The Microsoft Excel 2007 Advanced course will give learners a basic understanding of data collection and functions and can expand their skills. You will be issued an internationally recognised qualification following full completion of Microsoft Excel 2007 Advanced course.

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 audit formulas for errors
  • Learn how to use key advanced functions for financial, logical, text and maths
  • Learn how to analyse data using subtotals
  • Import and export data from workbook
  • Learn how to use custom and conditional formatting

Course Titles

  • Module 01: Advanced Functions
  • Module 02: Lookups and Data Tables
  • Module 03: Advanced List Management
  • Module 04: PivotTables and PivotCharts
  • Module 05: Exporting and Importing
  • Module 06: Analytical Options
  • Module 07: Macros and Custom Functions
  • Module 08: Conditional Formatting, SmartArt

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 intermediate 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 Advanced 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.

Certification

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

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 Advanced you will be qualified to work in the following positions. The Microsoft Office Excel 2007 I Advanced qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com 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 : 126
➤ Module 1 - Advanced Functions
1.0 Topic A: Logical Functions
1.1 The IF Function
1.2 Demo – A-1: Using the IF Function
1.3 AND, OR, and NOT Functions
1.4 Demo – A-2: Using OR, AND, and NOT as Nested Functions
1.5 Nested IF Functions
1.6 Demo – A-3: Using Nested IF Functions
1.7 The IFERROR Function
1.8 Demo – A-4: Using the IFERROR Function
2.0 Topic B: Math and Statistical Functions
2.1 The SUMIF Function
2.2 Demo – B-1: Using SUMIF
2.3 The COUNTIF Function
2.4 The AVERAGEIF Function
2.5 SUMIFS, COUNTIFS, AVERAGEIFS
2.6 Demo – B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
2.7 The ROUND Function
2.8 Evaluate Formula Dialog Box
2.9 Demo – B-5: Using ROUND
3.0 Topic C: Financial Functions
3.1 The PMT Function
3.2 Demo – C-1: Using the PMT Function
4.0 Topic D: Displaying/Printing Formulas
4.1 Displaying Formulas in Cells
4.2 Hiding Formulas from Users
4.3 Showing Hidden Formulas
4.4 Unit 01 Review
➤ Module 2 - Lookups and Data Tables
1.0 Topic A: Using Lookup Functions
1.1 The HLOOKUP Function
1.2 The VLOOKUP Function
1.3 Demo – A-1: Examining VLOOKUP
1.4 VLOOKUP for Exact Matches
1.5 VLOOKUP for Approximate Matches
1.6 Demo – A-4: Using HLOOKUP for Exact Matches
1.7 HLOOKUP for Approximate Matches
1.8 Demo – A-5: Using HLOOKUP for Approximate Matches
2.0 Topic B: Using MATCH and INDEX
2.1 The MATCH Function
2.2 Demo – B-1: Using the MATCH Function
2.3 The INDEX Function
2.4 Demo – B-2: Using the INDEX Function
3.0 Topic C: Creating Data Tables
3.1 One-Variable Data Tables
3.2 Two-Variable Data Tables
3.3 Demo – C-2: Creating a Two-Variable Data Table
3.4 Unit 02 Review
➤ Module 03 - Advanced List Management
1.0 Topic A: Validating Cell Entries
1.1 Validating Data
1.2 Setting Data Validation Rules
1.3 Demo – A-2: Setting Up Data Validation
2.0 Topic B: Exploring Database Functions
2.1 Structure of Database Functions
2.2 Demo – B-1: Examining the Structure of Database Functions
2.3 DSUM and DAVERAGE
2.4 Unit 03 Review
➤ Module 4 - PivotTables and PivotCharts
1.0 Topic A: Working with PivotTables
1.1 A Sample PivotTable
1.2 Creating a PivotTable
1.3 Demo – A-1: Creating a PivotTable
1.4 Adding Fields
1.5 Demo – A-2: Adding Fields to a PivotTable
2.0 Topic B: Rearranging PivotTables
2.1 Moving Fields
2.2 Hiding and Showing Details
2.3 Refreshing Data
3.0 Topic C: Formatting PivotTables
3.1 Using Styles
3.2 Demo – C-1: Formatting by Using a Pivot Style
3.3 Changing Field Settings
3.4 Value Field Settings Dialog Box
3.5 Demo – C-2: Changing Field Settings
4.0 Topic D: PivotCharts
4.1 Creating PivotCharts
4.2 Unit 04 Review
➤ Module 5 - Exporting and Importing
1.0 Topic A: Exporting and Importing Text Files
1.1 The Save As Command
1.2 Importing Data
1.3 The Text Import Wizard
1.4 Demo – A-2: Importing Data from a Text File into a Workbook
1.5 Converting Text to Columns
1.6 Demo – A-3: Converting Text to Columns
1.7 Removing Duplicates
1.8 Demo – A-4: Removing Duplicate Records
2.0 Topic B: Exporting and Importing XML Data
2.1 The XML Source Task Pane
2.2 Demo – B-1: Using the XML Source Task Pane
2.3 Importing XML Data
2.4 Demo – B-2: Importing XML Data into a Workbook
2.5 Exporting Data to an XML File
2.6 Demo – B-3: Exporting Data from a Workbook to an XML Data File
2.7 Deleting XML Maps
2.8 Demo – B-4: Deleting an XML Map
3.0 Topic C: Querying External Databases
3.1 Using Microsoft Query
3.2 Using Microsoft Query, Continued
3.3 Demo – C-1: Using Microsoft Query to Get Data from an External Database
3.4 Web Query
3.5 Retrieving Data from a Web page
3.6 Demo – C-3: Using a Web Query to Get Data from the Web
3.7 Unit 05 Review
➤ Module 6 - Analytical Options
1.0 Topic A: Goal Seek and Solver
1.1 Using the Goal Seek Utility
1.2 The Goal Seek Dialog Box
1.3 Demo – A-1: Using Goal Seek to Solve for a Single Variable
1.4 Adding in Add-Ins
1.5 The Add-Ins Dialog Box
1.6 Demo – A-2: Installing Solver and the Analysis ToolPak
1.7 Solver Parameters Dialog Box
1.8 Demo – A-3: Using Solver to Solve for Multiple Variables
2.0 Topic B: The Analysis ToolPak
2.1 Using the Sampling Analysis Tool
2.2 Demo – B-1: Using the Sampling Analysis Tool
3.0 Topic C: Scenarios
3.1 Creating a Scenario
3.2 Demo – C-1: Creating Scenarios
3.3 Switching Among Scenarios
3.4 Merging Scenarios
4.0 Topic D: Views
4.1 Creating Views
4.2 Demo – D-1: Creating Views
4.3 Switching Among Custom Views
4.4 Demo – D-2: Switching Among Views
4.5 Unit 06 Review
➤ Module 7 - Macros and Custom Functions
1.0 Topic A: Running and Recording a Macro
1.1 Running Macros
1.2 Recording Macros
1.3 Demo – A-2: Recording a Macro
1.4 Assigning Macros to Buttons
2.0 Topic B: Working with VBA Code
2.1 VBA Code
2.2 Observing VBA Code
2.3 Demo – B-1: Observing a VBA Code Module
2.4 Example of Editing VBA Code
2.5 Demo – B-2: Editing VBA Code
3.0 Topic C: Creating Functions
3.1 Function Procedures
3.2 Unit 07 Review
➤ Module 8 - Conditional Formatting, SmartArt
1.0 Topic A: Conditional Formatting with Graphics
1.1 Data Bars
1.2 Demo – A-1: Creating Data Bars
1.3 Color Scales
1.4 Demo – A-2: Using Color Scales
1.5 Icon Sets
1.6 Demo – A-3: Creating Icon Sets
2.0 Topic B: SmartArt Graphics
2.1 Starting SmartArt Formats
2.2 Demo – B-1: Inserting a SmartArt Graphic
2.3 SmartArt with 3-D Effects
2.4 Demo – B-2: Modifying a SmartArt Graphic
2.5 Unit 08 Review
2.6 Course Closure
WhatsApp chat