• LOGIN
  • No products in the basket.

Overview

This Excel training series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you’ve never used Excel, this is your starting point. No prior experience is necessary. If you’ve used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you’ve used previous versions of Excel (prior to Office 2007), then there are a lot of features and changes you need to be aware of to fully utilize this software.

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 Comfortable with Excel
  • Module 02: The Basics of Data
  • Module 03: Managing Workbook Structure
  • Module 04: Creating Formulas
  • Module 05: The Basics of Functions
  • Module 06: What’s in a Name?
  • Module 07: Making Data look Good
  • Module 08: A Picture is Worth a Thousand words
  • Module 09: The Simplicity of Tables
  • Module 10: Managing the Excel Environment
  • Module 11: Preparing Files for Distribution

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 2010: 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:

You will not need any previous experience to start this course on MS Excel. Make this course your starting point and learn all the basics needed to grasp the fundamentals of this tool in an effective manner. This level of training will ensure that your knowledge gaps are cleared and you understand the manner of using this effectively. A career with bright prospects await you with the completion of this course. According to www.payscale.uk, some of the key job positions along with the average UK salary per annum you can go for after completing this course will be as follows.

  • Administrator – £17,477 per annum
  • Receptionist – £16,297 per annum
  • Bookkeeper – £20,786 per annum
  • Small Business Owner – £24,297 per annum
  • Administrative Assistant – £16,876 per annum
  • Personal Assistant – £25,144 per annum
  • Accounts Administrator – £18,669 per annum
  • Accountant – £28,571 per annum
  • Accounts Assistant – £18,876 per annum
  • Junior Accountant – £17,750 per annum

Presenter Information:

Erin A. Olsen has been spreading her enthusiasm and vision for the power of desktop technology since 1994 to more than 37,000 people in seven countries. Since founding PCKeys Technology Solutions, she has authored more than 36 CBT titles, developed hundreds of courses and effectively presented to thousands. When Erin started her technology career, the PC was fairly new. Windows 3.1 was just coming out so she had to find ways to explain this new technical environment in terms non-technical people could understand. Her illustrations and explanations did and continue to do so today in fundamental to advanced topics. Erin combines her formal education in information technology and education with an emphasis in instructional design and technology (B.I.T., M.Ed.), with her technical expertise, real-world experience and understanding of adult learning to present these technical topics in an easy-to-understand, easy-to-apply and fun manner using relatable examples and analogies. Erin’s unique combination of personality and skills allow her to provide an enhanced learning experience for all that is effective, engaging and memorable.

Course Curriculum

FREE INTRODUCTION
Excel 2010: Essentials FREE 00:00:00
1: GETTING COMFORTABLE WITH EXCEL
1. Introducing Excel 00:00:00
2. Recognizing Interface Features Unique to Excel 00:00:00
3. Understanding Workbook Structure 00:00:00
4. Navigating through Workbooks 00:00:00
5. Making Workbook Selections 00:00:00
2: THE BASICS OF DATA
1. Entering Text 00:00:00
2. Entering Dates & Numbers 00:00:00
3. Editing Cell Entries 00:00:00
4. Copying & Moving Data 00:00:00
5. Filling a Series 00:00:00
3: MANAGING WORKBOOK STRUCTURE
1. Modifying Workbook & Worksheet Structure 00:00:00
2. Resizing Worksheet Elements 00:00:00
3. Hiding Workbook Components 00:00:00
4: CREATING FORMULAS
1. Excel Calculations 101 00:00:00
2. Entering Formulas 00:00:00
3. Enforcing Absolute Referencing 00:00:00
4. Controlling Calculation Options 00:00:00
5: THE BASICS OF FUNCTIONS
1. The Foundation of Functions 00:00:00
2. Using AutoSum & the Formulas Tab 00:00:00
3. Using Function AutoComplete 00:00:00
6: WHAT’S IN A NAME?
1. Creating Named Cells 00:00:00
2. Defining Names 00:00:00
3. Creating Names from Selections 00:00:00
4. Creating Named Formulas 00:00:00
5. Using Names as References 00:00:00
6. Managing & Displaying Names 00:00:00
7: MAKING DATA LOOK GOOD
1. Applying Basic Formatting 00:00:00
2. Formatting Numbers 00:00:00
3. Exploring the Format Cells Dialog Box 00:00:00
4. Dening Custom Formats 00:00:00
5. Creating & Applying Cell Styles 00:00:00
6. Conditional Formatting 00:00:00
7. Applying & Editing Conditional Formatting Rules 00:00:00
8: A PICTURE IS WORTH A THOUSAND WORDS
1. Getting In-Cell Summaries with Sparklines 00:00:00
2. Creating Charts 00:00:00
3. Modifying Chart Design 00:00:00
4. Working with Chart Layout & Format 00:00:00
5. Saving & Using a Chart Template 00:00:00
9: THE SIMPLICITY OF TABLES
1. Converting Data Ranges to Tables 00:00:00
2. Modifying Table Formatting 00:00:00
3. Working with Table Records 00:00:00
4. Using Table Calculations 00:00:00
5. Sorting Data 00:00:00
6. Creating Custom Lists 00:00:00
7. Filtering Data 00:00:00
10: MANAGING THE EXCEL ENVIRONMENT
1. Configuring Excel Options 00:00:00
2. Adjusting the View 00:00:00
3. Controlling Excel Windows 00:00:00
11: PREPARING FILES FOR DISTRIBUTION
1. Print Area, Print Titles & Sheet Options 00:00:00
2. Renaming Sheets & Adding Headers/Footers 00:00:00
3. Printing Worksheets 00:00:00
4. 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.

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

TOTUM Card

Totum Card




Address: Study365, 406 White Horse Lane, London E1 3FY

Certificate Code

Secure Payment
top