Menu
Use Code
Training95
For CPD & QLS
Use Code
Training90
For Opera PMS
Use Code
Training80
For BTEC, NCFE CACHE
Menu

  • No products in the basket.

MS Excel 2010 Essentials

4.5( 4 REVIEWS )
345 STUDENTS
ACCREDITED BY
Buy Now

Overview:

This excellent Excel 2010: Essentials course will get you up to speed with Excel 2010, whether you’re a beginner, or you just need to get to know the features of Excel 2010, there is something for you to learn. The course will teach you about entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts, and outputting your work. This course is taught by an expert instructor with years of experience, who has an abundance of insider knowledge to share with you.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • Break down Excel into its component parts to make it more manageable and less overwhelming
  • Use common, understandable names to replace confusing cell references
  • Apply traditional formatting, create custom formats and apply formatting that automatically changes based on conditions you designate
  • Truly understand how formulas and functions work, no matter how seemingly simple or complex
  • Learn the Commandments of Excel Usage™ to ensure your work is efficient and accurate
  • Embrace the power of tables to sort, filter and manage data more easily
  • Create charts with just one click

Meet the Instructor:

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

  • 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

What are the requirements?

You must be 16 or over

You should have a basic understanding of English, Maths and ICT

You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

  • You will have one assignment. Pass mark is 65%
  • You will only need to pay £19 for assessment.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days

What Certification am I going to receive?

Those who successfully pass this course will be awarded a Excel 2010: Essentials certificate. Anyone eligible for certification will receive a free e-certificate.

What careers can I get with this qualification?

With this course, you are able to fulfil various roles, such as:

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

Please note: We do not provide any software with this course.

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

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