Menu
Menu
  • No products in the basket.

Microsoft Excel 2007 Basics Online Course

0( 0 REVIEWS )
125 STUDENTS
ACCREDITED BY
Microsoft Excel 2007 Basics Online Course

Overview:

The Microsoft Excel 2007 Basic course is a step by step approach to help learners create effective and elaborate workbooks and worksheets. This course is suitable for learners who have no prior knowledge and those who have a basic background in Excel. It is a popular Microsoft application that can be used in the workplace to showcase your skills and competency in any job role. Getting certified in Microsoft Excel 2007 Basic will give learners the opportunity to acquire basic knowledge of how to work with Excel interface and workbook creation.

The Microsoft Excel 2007 Basic course will help learners gain an understanding of creating formulas, creating conditional logic, modifying text, inserting and formatting objects, modifying images and insert data and format cells.

The Microsoft Excel 2007 Basic course will give you an understanding of how to create relationships between tables, change the look and arrangement of forms and sort information in tables.  The course will help learners become proficient at using Excel 2007 in both their business and personal setting. 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 Basic.

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 create, configure, save Excel workbooks and worksheets
  • Customise views and options on workbooks and worksheets
  • Learn how to create and format Excel charts
  • Learn how to highlight, sort, filter group cells and tables
  • Learn how to navigate and format workbooks and worksheets

Course Titles

  • Module 01: Getting Started
  • Module 02: Entering and Editing Data
  • Module 03: Modifying a Worksheet
  • Module 04:  Using Functions
  • Module 05: Formatting Worksheets
  • Module 06: Printing
  • Module 07: Creating Charts
  • Module 08: Managing Large Workbooks

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 no prior experience of Excel 2007.
  • Students looking 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 over the age of 16 and have a basic understanding of Maths, English and ICT
  • Job seekers / graduates / school leavers

Method of Assessment

At the end of the Microsoft Excel 2007 Basic 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 Basic.

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 Basic you will be qualified to work in the following positions. The Microsoft Excel 2007 Basic 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 : 173
➤ Module 1 - Getting Started
1.0 Topic A: Spreadsheet Terminology
1.1 Spreadsheet Components
2.0 Topic B: Exploring the Excel Window
2.1 Excel Window Components
2.2 The Cells Styles Gallery
2.3 Tabs, Groups, and Live Preview
2.4 Demo – B-1: Examining Excel Window Components
3.0 Topic C: Getting Help
3.1 An Excel Help Topic
3.2 Demo – C-1: Using Help
4.0 Topic D: Navigating Workbooks
4.1 The Open Dialog Box
4.2 Demo – D-1: Navigating a Worksheet
4.3 Unit 01 Review
➤ Module 2 - Entering and Editing Data
1.0 Topic A: Entering and Editing Text and Values
1.1 A Spreadsheet with Text and Values
1.2 Demo – A-1: Entering Text and Values
1.3 Editing Text and Values
1.4 Demo – A-2: Editing Text
1.5 Entering Months with AutoFill
1.6 Demo – A-3: Using AutoFill to Fill a Series
2.0 Topic B: Entering and Editing Formulas
2.1 Formulas
2.2 Operators
2.3 Entering Formulas
2.4 Demo – B-1: Entering a Formula by Typing
2.5 Entering References with the Mouse
2.6 Demo – B-2: Entering Cell References with the Mouse
2.7 Demo – B-3: Editing a Formula
3.0 Topic C: Working with Pictures
3.1 Worksheet with a Picture
3.2 Inserting a Picture
3.3 Demo – C-1: Inserting and Modifying a Picture
4.0 Topic D: Saving and Updating Workbooks
4.1 Saving Workbooks
4.2 The Save As Dialog Box
4.3 Demo – D-1: Saving a Workbook
4.4 Demo – D-2: Changing and Updating a Workbook
4.5 Demo – D-3: Using the Compatibility Checker
4.6 Unit 02 Review
➤ Module 3 - Modifying a Worksheet
1.0 Topic A: Moving and Copying Data
1.1 Moving Data in Worksheets
1.2 Demo – A-1: Moving Data in a Worksheet
1.3 Copying Data in Worksheets
1.4 Demo – A-2: Copying Data in a Worksheet
1.5 Using Drag-and-drop to Move Data
1.6 Using Drag-and-drop to Copy Data
1.7 Demo – A-3: Moving and Copying Data by Using Drag-and-drop
1.8 The Office Clipboard
1.9 View the Clipboard Task Pane
1.10 Demo – A-4: Copying Data by Using the Clipboard
2.0 Topic B: Moving and Copying Formulas
2.1 Formulas
2.2 Shortcut Menus
2.3 Demo – B-1: Moving a Formula
2.4 Relative References
2.5 Demo – B-2: Copying a Formula
2.6 Demo – B-3: Using AutoFill to Copy a Formula
3.0 Topic C: Absolute and Relative References
3.1 Demo – C-1: Observing the Limitations of Relative References
3.2 Absolute References
3.3 Mixed References
3.4 Demo – C-2: Using Absolute References
4.0 Topic D: Inserting and Deleting Ranges, Rows, and Columns
4.1 Inserting Ranges
4.2 Demo – D-1: Inserting a Range
4.3 Inserting Rows or Columns
4.4 Demo – D-2: Inserting Rows
4.5 Deleting Ranges
4.6 Demo – D-3: Deleting a Range
4.7 Unit 03 Review
➤ Module 4 - Using Functions
1.0 Topic A: Entering Functions
1.1 Function
1.2 Arguments
1.3 Range References
1.4 Trace Error Button
1.5 Syntax Errors
1.6 Demo – A-1: Entering a SUM Function
1.7 Demo – A-2: Using the Mouse to Enter a Function Argument
1.8 Inserting Functions
1.9 Function Arguments Dialog Box
1.10 Demo – A-3: Inserting a SUM Function
2.0 Topic B: AutoSum
2.1 AutoSum Button
2.2 Demo – B-1: Using the AutoSum Button
3.0 Topic C: Other Useful Functions
3.1 AVERAGE Function
3.2 Demo – C-1: Using AVERAGE
3.3 MIN Function
3.4 Demo – C-2: Using MIN
3.5 MAX Function
3.6 Demo – C-3: Using MAX
3.7 COUNT Function
3.8 Demo – C-4: Using COUNT and COUNTA
3.9 Unit 04 Review
➤ Module 5 - Formatting Worksheets
1.0 Topic A: Formatting Text
1.1 Demo – A-1: Using the Font Group to Format Text
1.2 Selecting Non-contiguous Ranges
1.3 Demo – A-2: Formatting Non-contiguous Ranges
1.4 Format Cells: Font Tab
1.5 Demo – A-3: Using the Format Cells Dialog Box to Format Text
2.0 Topic B: Formatting Rows and Columns
2.1 Column Width and Row Height
2.2 Demo – B-1: Changing Column Width and Row Height
2.3 Demo – B-2: Applying Color to a Row
2.4 The Merge & Center Button
2.5 Demo – B-3: Setting Alignment
2.6 The Border Tab
2.7 Demo – B-4: Applying Borders to Ranges
2.8 Using the Border-drawing Pencil
2.9 Demo – B-5: Using the Border-drawing Pencil
2.10 Demo – B-6: Using the Paste Special Option
2.11 Demo – B-7: Removing a Border
3.0 Topic C: Formatting Numbers
3.1 Number Formatting
3.2 Demo – C-1: Using the Number Group to Format Numbers
3.3 The Number Tab
3.4 Demo – C-2: Exploring the Number Tab
4.0 Topic D: Conditional Formatting
4.1 Conditional Formatting Options
4.2 New Formatting Rule Dialog Box
4.3 Demo – D-1: Creating a Conditional Format
4.4 Demo – D-2: Editing and Deleting a Conditional Format
5.0 Topic E: Copying Formats and Applying Table Formats
5.1 Copy and Clear Formats
5.2 Demo – E-1: Copying Formats
5.3 Demo – E-2: Using AutoFill to Copy a Format
5.4 Applying a Cell Style
5.5 Cell Styles
5.6 Table Formats
5.7 Demo – E-3: Applying Cell and Table Styles
5.8 Demo – E-4: Using Find and Replace to Change Cell Formats
5.9 Unit 05 Review
➤ Module 6 - Printing
1.0 Topic A: Preparing to Print
1.1 Using the Spelling Checker
1.2 Demo – A-1: Checking Spelling in a Worksheet
1.3 Demo – A-2: Using the Research Task Pane
1.4 Using the Replace Command
1.5 Demo – A-3: Finding and Replacing Text
1.6 Page Layout View
1.7 Demo – A-4: Previewing a Worksheet
2.0 Topic B: Page Setup Options
2.1 Demo – B-1: Setting Page Orientation
2.2 Setting Custom Margins
2.3 Demo – B-2: Setting Margins
2.4 Demo – B-3: Creating and Editing Headers and Footers
2.5 Controlling Sheet Options
2.6 Demo – B-4: Hiding Gridlines and Headings
3.0 Topic C: Printing Worksheets
3.1 The Print Dialog Box
3.2 Printing a Selection
3.3 Demo – C-1: Printing a Worksheet
3.4 Working with the Print Area
3.5 Demo – C-2: Working with the Print Area
3.6 Unit 06 Review
➤ Module 7 - Creating Charts
1.0 Topic A: Chart Basics
1.1 Creating Charts
1.2 Demo – A-1: Creating a Chart
1.3 Demo – A-2: Moving a Chart Within a Workbook
1.4 Chart Elements
1.5 Demo – A-3: Examining Chart Elements
1.6 Demo – A-4: Using an Embedded Chart
2.0 Topic B: Modifying Charts
2.1 Changing the Chart Type
2.2 Demo – B-1: Changing a Chart Type
2.3 Demo – B-2: Applying Quick Layouts and Quick Styles
2.4 Adding Axis Labels
2.5 Demo – B-3: Formatting Chart Elements
2.6 Demo – B-4: Modifying an Embedded Chart
3.0 Topic C: Printing Charts
3.1 The Chart Tab
3.2 Demo – C-1: Printing a Chart
3.3 Unit 07 Review
➤ Module 8 - Managing Large Workbooks
1.0 Topic A: Viewing Large Worksheets
1.1 Freezing Rows and/or Columns
1.2 Demo – A-1: Using the Freeze Panes Command
1.3 Splitting a Worksheet into Panes
1.4 Demo – A-2: Splitting a Worksheet into Panes
1.5 Hiding a Column
1.6 Unhiding Columns
1.7 Hiding a Worksheet
1.8 Hidden Columns
1.9 Demo – A-3: Hiding and Unhiding Columns and Worksheets
1.10 Demo – A-4: Minimizing the Ribbon
2.0 Topic B: Printing Large Worksheets
2.1 Setting Print Titles
2.2 Demo – B-1: Setting Print Titles
2.3 Page Break Preview
2.4 Demo – B-2: Adjusting Page Breaks
3.0 Topic C: Using Multiple Worksheets
3.1 Demo – C-1: Navigating Between Worksheets
3.2 Renaming a Worksheet
3.3 Color-coded Sheet Tabs
3.4 Demo – C-2: Naming Worksheets and Coloring Tabs
3.5 Inserting a Worksheet
3.6 Moving a Worksheet
3.7 Deleting a Worksheet
3.8 Demo – C-3: Working with Multiple Worksheets
3.9 Printing Multiple Worksheets
3.10 Demo – C-4: Previewing and Printing Multiple Worksheets
3.11 Unit 08 Review
3.12 Course Closure
WhatsApp chat