Microsoft Excel 2013: Essentials

Overview

Total Training for Microsoft Excel 2013 Essentials shows you 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.

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).

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.

Entry Requirement:

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Career Path:

This course could help you to pursue a career in any of the following industries:

• Administration
• Reception
• Accounting
• Bookkeeping
• Business ownership
• PA professionals

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.

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 Course Reviews