Certificate In Excel 2010 Expert Online Course - RRP £399, Now Only £149 For a Limited Time
Courses for Success
Summary
Overview
Gain Skills to Become an Expert with Excel 2010
You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users 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 usable information, and better information leads to better decision making!
By the end of this Excel 2010 Expert Online Short Course, you will be able to:
- Mark Workbook as Final
- Encrypt with a Password and Restrict Permissions
- Protect the Current Sheet or the Workbook Structure
- Add a Digital Signature
- Set Excel Options
- Manage Versions
- Save a Workbook as an Excel Template
- Inspect Documents
- Share Workbooks
- Edit a Shared Workbook
- Track Changes
- Merge Copies of a Shared Workbook
- Use the Watch Window
- Set Calculation Options
- Enable or Disable Automatic Workbook Calculations
- Use the IFERROR Function to Evaluate Formulas
- Use Array Formulas
- Understand a Variety of different Functions
- Assign Macros to a Command Button on the Ribbon
- Run a Macro by Clicking an Area of a Graphic Object
- Configure a Macro to Run Automatically Upon Opening the Workbook
- Change a Macro
- Insert Form Controls
- Use a data form
- Use Trend Lines
- Add a Secondary Axis
- Use Chart Templates
- Work with PivotTable Tools
- Work with PivotChart Tools
- Use the Slicer
- Choose External Data Sets with the Slicer
- Understand the Analysis ToolPak
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: Working with Permissions and Options
- Marking Workbook as Final
- Encrypting with a Password and Restricting Permissions
- Protecting the Current Sheet or the Workbook Structure
- Adding a Digital Signature
- Setting Excel Options
- Managing Versions
- Saving a Workbook as an Excel Template
Module Three: Sharing Workbooks
- Inspecting Document
- Sharing a Workbook
- Editing a Shared Workbook
- Tracking Changes
- Merging Copies of a Shared Workbook
Module Four: Performing Advanced Formula and Function Tasks
- Using the Watch Window
- About the Excel Calculation Process
- Setting Calculation Options
- Enabling or Disabling Automatic Workbook Calculations
- Using the IFERROR Function to Evaluate Formulas
Module Five: Working with Array Formulas
- About Array Formulas
- Creating One-Dimensional and Two-Dimensional Constants
- Creating a Simple Array
- Creating an Advanced Array
Module Six: Working with Functions
- Working with Math and Trigonometry Functions
- Using a SUMIF Function
- Working with Date and Time Functions
- Working with Financial Functions
- Working with Text Functions
- Working with Cube Functions
- Working with Statistical Functions
Module Seven: Working with Macros
- Assigning a Macro to a Command Button
- Running a Macro by Clicking an Area of a Graphic Object
- Configuring a Macro to Run Automatically Upon Opening the Workbook
- Changing a Macro
Module Eight: Working with Forms
- About Excel Forms, Form Controls, and Active X Controls
- Using a Data Form
- Using a List Box Control
- Using a Combo Box Control
- Using a Spin Button Control
- Using a Scroll Bar Control
Module Nine: Applying Advanced Chart Features
- About Trend Lines
- Add a Trend Line
- Using Secondary Axes
- Using Chart Templates
Module Ten: Working with PivotTables and PivotCharts
- Working with PivotTable Tools
- Working with PivotChart Tools
- About Slicers
- Creating a Slicer in an Existing PivotTable
- Creating a Standalone Slicer
- Formatting a Slicer
- Sharing Slicers with Another PivotTable
- Disconnect or Delete a Slicer
Module Eleven: Using the Automated Analysis Tools Add-In
- Loading the Analysis ToolPak
- About the Analysis ToolPak Options (I)
- About the Analysis ToolPak Options (II)
- About the Analysis ToolPak Options (II)
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.