Certificate In Excel 2010 Essentials Online Course - RRP £399, Now Only £149 For a Limited Time
Courses for Success
Summary
Overview
Learn the Basic Features of Excel 2010
Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!
By the end of this Excel 2010 Essentials Online Short Course, you will be able to:
- Open and close Excel
- Differentiate between worksheets, workbooks, rows, columns, and cells
- Understand the new Interface and the new Backstage View
- Enter labels and values
- Edit data
- Add rows and columns
- Check spelling
- Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
- Switch between Excel views and create custom views
- Use Zoom
- Set up, Preview and print your workbook
- Build, copy and edit formulas
- Use absolute referencing appropriately
- Understand the difference between Formulas and Functions
- Understand the new Function Names
- Use the Formulas Tab
- Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
- Use the status bar to perform calculations
- Use AutoFill and AutoComplete
- Sort and filter data
- Use sparklines
- Format text and numbers
- Use alignment options
- Merge cells
- Apply borders
- Use cell styles
- Use conditional formatting
- Change the workbook theme
Course Fast Facts:
- Easy to follow and understand
- Only 6 to 8 hours of study is required
- 12 months access to course
- Delivered 100% on-line and accessible 24/7 from any computer or smartphone
- You can study from home or at work, at your own pace, in your own time
- Download printer friendly course content
- Certificate (IAOTS Accredited)
Course Delivery
Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.
Recognition & Accreditation
This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.
_______________________________________________________________________________________
Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining! (Value £300)
The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
The Personal Success Training Program consists of 3 Comprehensive Courses:
- Course 1: Create Personal Success Online Certificate Course
- Course 2 - Certificate in Organizational Skills Online Course
- Course 3 - Certificate in Goal Setting & Getting Things Done Online Course
Benefits:
- How to layout a Success Plan.
- Get where you want to be in life.
- How to unclutter your mind to succeed.
- Achieve your dreams using your imagination.
- How to have faith in yourself.
Features:
- 12 month online access, 24/7 anywhere.
- Complement your individual course purchase.
- Internationally recognized by the IAOTS.
- Thousands of positive reviews.
- Limited Time Offer - Ends Soon.
Description
Module One: Getting Started
- Course Objectives
Module Two: Opening and Closing Excel
- Opening Excel
- Understanding the Interface
- Using Backstage View
- Understanding Worksheets
- Understanding Workbooks
Module Three: Your First Worksheet
- Entering Data
- Editing Data
- Using the Wrap Command
- Adding Rows and Columns
- Checking Your Spelling
Module Four: Working with Excel Files
- Saving Files
- Publishing Files to PDF
- Sending Files via E-Mail
- Closing Files
- Opening Files
Module Five: Viewing Excel Data
- An Overview of Excel’s Views
- Switching Views
- Creating Custom Views
- Using Zoom
- Switching Between Open Files
Module Six: Printing Excel Data
- An Overview of the Page Layout Tab
- Setting Up Your Page
- Using Print Preview
- Printing Data
Module Seven: Building Formulas
- The Math Basics of Excel
- Building a Formula
- Editing a Formula
- Copying a Formula
- Relative vs. Absolute References
Module Eight: Using Excel Functions
- Formulas vs. Functions
- Using the SUM Function
- Using Other Basic Excel Functions
- Understanding the Formulas Tab
- Using the Status Bar to Perform Calculations
- Understanding the New Function Names
Module Nine: Using Time Saving Tools
- Using AutoFill
- Using AutoComplete
- Sorting Data
- Filtering Data
- Adding Sparklines
Module Ten: Formatting Your Data
- Changing the Appearance of Text
- Changing the Appearance of Numbers
- Setting Alignment Options
- Using Merge
- Removing Formatting
Module Eleven: Advanced Formatting Tools
- Adding Borders
- Adding Fill Color
- Using Cell Styles
- Using Conditional Formatting
- Changing the Theme
Module Twelve: Wrapping Up
Who is this course for?
Upon course completion, students will receive a certificate that will serve as proof of their study in this field
Requirements
Entry requirements
Students must have basic literacy and numeracy skills.
Minimum education
Open entry. Previous schooling and academic achievements are not required for entry into this course.
Computer requirements
Students will need access to a computer and the internet.
Students will also need access the following applications:
Adobe Acrobat Reader
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.