• LOGIN
  • No products in the basket.

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
Excel 2013: Essentials FREE 00:00:00
1: GETTING ACQUAINTED WITH EXCEL
1. If You’re in a Hurry, Use a Template 00:00:00
2. What’s on the Screen 00:00:00
3. File Management Basics 00:00:00
4. Editing the Content & Structure of a Worksheet 00:00:00
5. Creating a Sample Worksheet 00:00:00
2: TECHNIQUES FOR EASIER DATA ENTRY
1. Using Auto Fill 00:00:00
2. Selecting an Area for Faster Data Entry 00:00:00
3. Using Automatic Decimals 00:00:00
4. Using Flash Fill 00:00:00
3: MANAGING LISTS WITH EXCEL
1. Sorting a List of Names & Addresses 00:00:00
2. Formatting & Editing a Table 00:00:00
3. Advanced Filter 00:00:00
4. Finding & Replacing Data 00:00:00
5. Splitting Cells 00:00:00
4: Basic Calculations with Formulas
1. How Do You Write a Formula? 00:00:00
2. Adding, Subtracting & Basic Number Formatting 00:00:00
3. Squaring & Cubing Numbers 00:00:00
4. Absolutely Understand Absolute References 00:00:00
5. Formatting Numbers 00:00:00
6. The Order of Calculations is Critical 00:00:00
7. Joining Cells 00:00:00
5: CALCULATING WITH FUNCTIONS
1. Understanding How Functions Work 00:00:00
2. SUM Function & AutoSum Tool 00:00:00
3. Adding a Whole Worksheet with Just Two Clicks 00:00:00
4. Calculating an Average 00:00:00
5. Finding the Highest, Lowest & Quantity of Values 00:00:00
6. Inserting, Calculating & Formatting Dates 00:00:00
7. Automatic Subtotals 00:00:00
8. Calculations across Worksheets 00:00:00
6: FUNCTIONS THAT MAKE DECISIONS
1. IF: Values that Depend on a Condition 00:00:00
2. SUMIF & AVERAGEIF: Sums & Averages That Depend on a Condition 00:00:00
3. VLOOKUP: Extract Data from a Table 00:00:00
7: MATH, STATISTICAL & FINANCIAL FUNCTIONS
1. Square Roots & Logarithms 00:00:00
2. Correlation, Standard Deviation, Median & Large 00:00:00
3. Calculating Monthly Loan Payments 00:00:00
4. Using Net Present Value to Evaluate an Investment 00:00:00
8: FORMATTING WORKSHEETS
1. Row & Column Size & Cell Alignment 00:00:00
2. Using & Modifying Built-in Styles 00:00:00
3. Analyzing Data with Conditional Formatting 00:00:00
4. Inserting & Modifying Pictures 00:00:00
5. Inserting Pictures from Online Sources 00:00:00
6. Drawing & Modifying Shapes 00:00:00
7. Using Shortcuts to Draw & Modify Shapes 00:00:00
8. Creating Diagrams with SmartArt 00:00:00
9: Managing Workbooks
1. Arranging, Inserting, Moving & Copying Worksheets 00:00:00
2. Freezing Row & Column Titles in Place 00:00:00
3. Repeating Row & Column Titles 00:00:00
4. Hiding & Un-hiding Rows & Columns 00:00:00
10: DATA ANALYSIS TECHNIQUES
1. Goal Seek 00:00:00
2. Creating Scenarios for Multiple What-Ifs 00:00:00
3. Using the Quick Analysis Tool 00:00:00
4. Using the Inquire Add-in to Compare Worksheets 00:00:00
11: CREATING CHARTS IN EXCEL
1. Creating Charts Instantly: Two Methods 00:00:00
2. Creating a Column Chart Manually 00:00:00
3. Creating a Pie Chart Manually 00:00:00
4. Sparklines: Miniature Charts in Cells 00:00:00
5. Setting Up a GeoFlow 3D Map 00:00:00
6. Animating a GeoFlow 3D Map 00:00:00
12: PIVOTTABLES & POWER VIEWS
1. Overview of PivotTables 00:00:00
2. Inserting a Recommended PivotTable 00:00:00
3. Creating a PivotTable Manually 00:00:00
4. Modifying a PivotTable & Filtering with Slicers 00:00:00
5. Creating a PivotChart 00:00:00
6. Creating a Power View Report 00:00:00
13: PRINTING A WORKSHEET
1. Print Layout, What Should Fit & How 00:00:00
2. Inserting Headers & Footers 00:00:00
3. Printing & Print Settings 00:00:00
14: COLLABORATION
1. Writing & Editing Comments 00:00:00
2. Creating PDF Documents 00:00:00
3. Importing & Exporting Data 00:00:00
4. Restricting Editing of a Workbook 00:00:00
5. Protecting Workbook Structure, Finalizing & Password Protection 00:00:00
6. Tracking Changes Other People Make to a Workbook 00:00:00
7. Saving a Workbook in SkyDrive, SharePoint, or Dropbox 00:00:00
8. Allowing Others to Modify Your Open Workbook 00:00:00
9. Inviting Others to Share Your Workbook 00:00:00
10. Sharing a Workbook on a Social Network 00:00:00
11. Share Workbooks on the Web with the Excel Button 00:00:00
15: AUTOMATING TASKS
1. Overview of Automation 00:00:00
2. Installing & Using Office Apps 00:00:00
3. Creating Macros by Recording Keystrokes 00:00:00
4. Editing Macros in Visual Basic for Applications 00:00:00
16: CUSTOMIZING EXCEL
1. Modifying the Ribbon Bar & Quick Access Toolbar 00:00:00
2. Setting Excel’s Options 00:00:00
3. Credits 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

409 STUDENTS ENROLLED

    CPD Accredited

    UKRLP

    ACCREDITED CERTIFICATE

    certificate

    Awarded by iAP

    Awarded by iAP

    CPD Accredited Partner

    CPD Accredited

    CPD Membership No: 10582

    Study independently accredited and recognised CPD courses. Gain your certification today.

    cvAll students enrolled with STUDY365 are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews.
    MORE INFO

    cvIf you need career support STUDY365 is here for you. We provide excellent career support through our Career Support Service.
    MORE INFO

    NUS Extra Card

    NUS Extra Card

    Course Reviews

    • Office Skills, Secretarial & PA Training

      Office Skills, Secretarial & PA Training 2

      I regret doing this course- only a few units were actually useful! *A lot of it is just common sense *The units on Microsoft Word and Outlook were shown using the obsolete versions *Some of the videos were shot & edited very poorly *Some of the written tutorials were shoddy and seemed 'rushed' *A couple of videos were looped *I couldn't find the exercise files for at least one of the units (not at the end where they usually are) *The mock exams and final exam had questions on things that weren't even in the course! All I got from this course is an idea of what I need to work on and how NOT to do it.
      Sally Eastman
    • Adult Nursing & Social Care Training

      Adult Nursing & Social Care Training 4

      Learnt how to work in a practical sense with those who really need you after taking this course.
      Emma Hanks




    Address: Study365, 406 White Horse Lane, London E1 3FY
    Phone: 0203 874 9355​
    Email: support@study365.co.uk

    Certificate Code

    Secure Payment
    top