• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Office 2007 Excel Intermediate

Microsoft Office 2007 Excel Intermediate

By Course Gate

5.0(1)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 4 hours 11 minutes

  • All levels

Description

This Microsoft Office 2007 Excel Intermediate will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well.

Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel.

Who is this Course for?

Microsoft Office 2007 Excel Intermediate is perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Entry Requirement:
  • This course is available to all learners, of all academic backgrounds.

  • Learners should be aged 16 or over to undertake the qualification.

  • Good understanding of English language, numeracy and ICT are required to attend this course.


Course Curriculum

Using Multiple Worksheets and Workbooks

Using Multiple Workbooks

00:04:00

Linking Worksheets with 3-D Formulas

00:06:00

Linking Workbooks

00:11:00

Managing Workbooks

00:04:00

Advanced Formatting

Using Special Number Formats

00:17:00

Using Functions to Format Text

00:13:00

Working with Styles

00:07:00

Working with Themes

00:11:00

Other Advanced Formatting

00:13:00

Outlining and Subtotals

Outlining and Consolidating Data

00:11:00

Creating Subtotals

00:06:00

Cell and Range Names

Creating and Using Names

00:12:00

Managing Names

00:04:00

Lists and Tables

Examining Lists

00:03:00

Sorting and Filtering Lists

00:07:00

Advanced Filtering

00:12:00

Working with Tables

00:22:00

Web and Internet Features

Saving Workbooks as Web Pages

00:11:00

Using Hyperlinks

00:04:00

Distributing Workbooks

00:03:00

Advanced Charting

Chart Formatting Options

00:08:00

Combination Charts

00:05:00

Graphic Elements

00:09:00

Documenting and Auditing

Auditing Features

00:05:00

Creating A Body Of Work

00:03:00

Protection

00:05:00

Workgroup Collaboration

00:13:00

Templates and Settings

Application Settings

00:05:00

Built-in Templates

00:07:00

Creating and Managing Templates

00:10:00

Certificate and Transcript

Order Your Certificates or Transcripts

00:00:00

About The Provider

Course Gate
Course Gate
London
5.0(1)

Welcome to Course Gate, your gateway to a world of knowledge and oppo...

Read more about Course Gate

Tags

Reviews