Microsoft Excel 2013: Essentials

Overview

Microsoft Excel 2013 Essentials demonstrates the fundamentals of entering data and creating spreadsheets, managing lists of data, creating formulas & functions, formatting worksheets for print and electronic delivery, charting, data analysis, collaborating with others, automating tasks, and more.

The course provides a basic understanding of how to use the Excel 2013 essential features and functions. Excel 2013 offers new features and let you become an expert at using them. As a premier spreadsheet application, Excel 2013 will explore a number of key topics such as how to analyse numbers, track data and represent your data in a clear, graphical manner. It is easier to use than the earlier version and you are provided with powerful tools to manage data and make better decisions. Qualifying in this course will make you an attractive candidate to potential employers, as Excel is a must-have skill in an array of job roles.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

COURSE CURRICULUM
FREE INTRODUCTION
1: GETTING ACQUAINTED WITH EXCEL
2: TECHNIQUES FOR EASIER DATA ENTRY
3: MANAGING LISTS WITH EXCEL
4: Basic Calculations with Formulas
5: CALCULATING WITH FUNCTIONS
6: FUNCTIONS THAT MAKE DECISIONS
7: MATH, STATISTICAL & FINANCIAL FUNCTIONS
8: FORMATTING WORKSHEETS
9: Managing Workbooks
10: DATA ANALYSIS TECHNIQUES
11: CREATING CHARTS IN EXCEL
12: PIVOTTABLES & POWER VIEWS
13: PRINTING A WORKSHEET
14: COLLABORATION
15: AUTOMATING TASKS
16: CUSTOMIZING EXCEL

Who is it for?

• Job seekers
• Graduates
• Administrators
• PA professionals
• Accountants
• Bookkeepers
• Business Owners

Course outline

This course is comprised of the following modules:

• Module 01: Getting Acquainted with Excel
• Module 02: Techniques for Easier Data Entry
• Module 03: Managing Lists with Excel
• Module 04: Basic Calculations with Formulas
• Module 05: Calculations with Functions
• Module 06: Functions that make Decisions
• Module 07: Math, Statistical & Financial Functions
• Module 08: Formatting Worksheets
• Module 09: Managing Workbooks
• Module 10: Data Analysis Techniques
• Module 11: Creating Charts in Excel
• Module 12: Pivottables & Power Views
• Module 13: Printing a Worksheet
• Module 14: Collaboration
• Module 15: Automating Tasks
• Module 16: Customizing Excel 2013

Course Duration:

From the day you purchase the course, you will have 12 months access to the online study platform. As the course is self-paced you can decide how fast or slow the training goes, and are able to complete the course in stages, revisiting the training at any time.

Method of Assessment:

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.

Certification:

Successful candidates will be awarded a certificate for Excel 2013: Essentials.

Presenter Information:

Bob Flisser has been providing computer training since the early 1980s. Since 1990, he has been engaged in consulting, technical writing, and creating multimedia presentations and print material. In 1995, when the web was new, Bob added web development to his skills. He has had several video courses published, and is the co-author of a dozen books of computer tips and shortcuts. Bob also has written courseware and magazine articles and has created and run training centers for several companies.