Microsoft Excel 2013


Excel 2013

£160.00

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data.

SKU: EC112116. Category: .

Product Description

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data.
But it also works really well for simple calculations and tracking almost any kind of information.
The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text or formulas. You put data in your cells and group them in rows and columns. This function allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts.
Let’s go through the basic steps to get you started.

One need to focus on your information whilst Excel templates do the majority of setup and design for you!
A brand new look will be cleaner,
but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions.
New Quick Analysis tool lets you convert your data into a chart or table in two steps or less.
It will help you preview your data with conditional formatting, sparklines, or charts, and make your choice stick in just one click.

WHATS NEW IN EXCEL 2013?
Flash Fill
New insights allows you rearrange and reformat your data with ease.
Excel will auto-complete your data for you by learning and recognising your pattern! No macros or formulas required.

Flash Fill enters the entire data in one fell swoop, following the pattern it recognizes in your data, once it detects what function you want to perform.
lash Fill is like a data assistant that finishes your work for you.

With Chart recommendations, Excel recommends the most suitable charts for your data.
Take a quick peek to see how your data looks in the different charts, and then simply pick the one that shows the insights you want to present.

Recommended Pivot Table
Excel will summarise your data with previews of several pivot-table options – compare and select the option you feel best! Complex analyses will be performed quickly and easily!
Excel 2010 is as an interactive way to filter PivotTable data, slicers can now also filter data in Excel tables, query tables, and other data tables.
Simpler to set up and use, slicers show the current filter so you’ll know exactly what data you’re looking at.

Course Study Format
This course is delivered through ONLINE method.
The course is available for you to complete at your convenience over a 12 month period.

IT Training Courseware Support
The entire home study courses include step by step online training and keyword search facilities.
Using show and ask training methods you can access the desired eLearning courseware step by step.
Our technical support team is available for 24 hours a day from Monday to Friday, to help you out regarding any queries related to your online course

Exams
All exam vouchers supplied with our courses must be used within the duration of your course. Exam Vouchers become invalid once the course has expired.

Excel 2013 Basic
Introduction
Create Workbook
Opening an Existing Workbook
Saving a workbook
Entering and editing data
Formatting
Headers & Footers
Copy, pasting and moving data
Working with columns and rows
Using Autofil
Preview and Printing
Formula and Functions
Sorting and Filtering Data

Excel 2013 Intermediate
Charts and Graphs
Named Ranges
Intermediate Formula and Functions
Formula Auditing
Outline Groups
Data Validation
Sparklines
Conditional Formatting
Comments
Protecting a workbook

Excel 2013 Advanced
Create Custom Lists
Forms
Advanced Formula and Functions
Using the Watch Window
Scenarios
Goal Seek
Solver
Pivot Tables
Macros
Working with External Data sources

Job Prospects
Become fully trained and substantially improve your chances of employment or earn more money!

Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.

Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.

Course Completion Certificate

*Please note, unless stated otherwise or included in package, our online courses only offer course completion certificates ( £10 fee) and in all cases official testing (at a charge made by testing centre) is required to gain officially certified recognised qualifications.

Unless otherwise specified, official exams are not included.