Certificate In Excel 2010 Essentials

£199.00

The course will take you through the complete essentials of Excel 2013.

Who is this course for?

A recent study reported in the Wall Street Journal found that a massive 78% of middle-skill jobs now require digital skills like Excel and Word. As well as that, jobs that require said skills also pay 13% more than those that don’t. This course is perfect for those who are not familiar with the software and hope to learn and gain a general understanding of its essential features and what it can be used for.

Only 6 to 8 hours of study is required.

Category: Tag:

The course will take you through the complete essentials of Excel 2013.

Who is this course for?

A recent study reported in the Wall Street Journal found that a massive 78% of middle-skill jobs now require digital skills like Excel and Word. As well as that, jobs that require said skills also pay 13% more than those that don’t. This course is perfect for those who are not familiar with the software and hope to learn and gain a general understanding of its essential features and what it can be used for.

Only 6 to 8 hours of study is required.

What’s Included?

Wiki_tick  Unlimited  lifetime access
Wiki_tick  Access anywhere, any time
Wiki_tick  Fast effective training, written and designed by industry experts
Wiki_tick  Track your progress with our Learning Management System
Wiki_tick  Unlimited support
Wiki_tick  Save money, time and travel costs
Wiki_tick  Learn at your own pace and leisure
Wiki_tick  Easier to retain knowledge and revise topics than traditional methods
Wiki_tick  Exam preparation quizzes, tests and mock exams to ensure that you are 100% ready

£199.00Add to cart

Modules

Only 6 to 8 hours of study is required.

Module One: Getting Started

Course Objectives

Module Two: Opening and Closing Excel

Opening Excel
Understanding the Interface
Using Backstage View
Understanding Worksheets
Understanding Workbooks

Module Three: Your First Worksheet

Entering Data
Editing Data
Using the Wrap Command
Adding Rows and Columns
Checking Your Spelling

Module Four: Working with Excel Files

Saving Files
Publishing Files to PDF
Sending Files via E-Mail
Closing Files
Opening Files

Module Five: Viewing Excel Data

An Overview of Excel’s Views
Switching Views
Creating Custom Views
Using Zoom
Switching Between Open Files

Module Six: Printing Excel Data

An Overview of the Page Layout Tab
Setting Up Your Page
Using Print Preview
Printing Data

Module Seven: Building Formulas

The Math Basics of Excel
Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References

Module Eight: Using Excel Functions

Formulas vs. Functions
Using the SUM Function
Using Other Basic Excel Functions
Understanding the Formulas Tab
Using the Status Bar to Perform Calculations
Understanding the New Function Names

Module Nine: Using Time Saving Tools

Using AutoFill
Using AutoComplete
Sorting Data
Filtering Data
Adding Sparklines

Module Ten: Formatting Your Data

Changing the Appearance of Text
Changing the Appearance of Numbers
Setting Alignment Options
Using Merge
Removing Formatting

Module Eleven: Advanced Formatting Tools

Adding Borders
Adding Fill Color
Using Cell Styles
Using Conditional Formatting
Changing the Theme

Module Twelve: Wrapping Up

System Requirements

Minimum specifications for the computer are:

Windows:

Microsoft Windows XP, or later
Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS:

OSX/iOS 6 or later
Modern and up to date Browser (Firefox, Chrome, Safari)

All systems:

Internet bandwidth of 1Mb or faster
Flash player or a browser with HTML5 video capabilities (We recommend Google Chrome)