MICROSOFT EXCEL 2013
Vizual Coaching
Summary
- Tutor is available to students
Overview
- 1 Years unlimited access,
- 24 hour support available,
- Certificate awarded upon completion to show employers your new skills!
Focus on your information whilst Excel templates do the majority of setup and design for you!
The first thing you’ll see when you open Excel is a brand new look. It’s 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.
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. That 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.
The new Quick Analysis tool lets you convert your data into a chart or table in two steps or less. 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
Rearrange and reformat your data with ease to gain a whole new insight. Excel will auto-complete your data for you by learning and recognising your pattern! No macros or formulas required.Flash Fill is like a data assistant that finishes your work for you. As soon as it detects what you want to do, Flash Fill enters the rest of your data in one fell swoop, following the pattern it recognizes in your data.
With Chart recommendations, Excel recommends the most suitable charts for your data. Get 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
Complex analyses will be performed quickly and easily! Excel will summarise your data with previews of several pivot-table options – compare and select the option you feel best!
First introduced in Excel 2010 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.
Description
- 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
- 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
If you still have any questions regarding your online course, our technical support team are available 24 hours a day Monday to Friday.
All exam vouchers supplied with e-Careers courses must be used within the duration of your course. Exam Vouchers become invalid once the course has expired.
Job Prospects
Become fully trained and substantially improve your chances of employment or earn more money!
Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.
Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 24hrs a day from Monday to Friday to help you out if you get stuck.
Our Online IT Training Courses are available 24 hours a day, 7 days a week for any computer that
has online access!
Unless otherwise specified, official exams are not included.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.