Using Excel as a Data Analysis Tool – Common Tips and Tricks

£40.00

Price is per online user of this course.

This course explains powerful tools that have become engrained in business processes worldwide. Businesses will continue to use Excel as a primary tool for diverse functions and applications ranging from IT projects to company anniversaries and party times.

Becoming skilled at Excel has become a license to grow in the business. So while there are a lot of basic tricks that you have to know, there are also a few tricks that will set you head and shoulders above the competition.

This course provides knowledge and skills that contribute to the Microsoft Office Specialist exam in Excel.

See below for further information.

Sold By: Grey Campus

Description

Course Components:

1. 1 Year e-learning access with 3 to 5 hours of learning;
2. Audio/video lecturers, exercises, data sets and additional material
3. Mock exam;
4. End of module test.

Course Objectives:

After the completion of the course, participants will be able to:

  • Understand Excel’s backstage view
  • Appreciate some of the frequently used functions in Excel
  • Explore the protection features of Excel
  • Work with Business data and prepare relevant Charts

Curriculum

  • Understanding Cell References
  • The Backstage view – Analysis Perspective
  • Excel protection features (password Protecting sheets, and hiding Formula)
  • Exporting Excel data to other formats – CSV, PDF, and others
  • Tabs, Toolbars and Ribbons
  • Entering Formulas – Thumb Rules
  • Best Practices for Spreadsheet Models
  • Frequently used Functions in Excel
  • Creating and formatting Charts containing business data
  • Formatting data as Tables

Entry Requirements

Familiarity with the Microsoft Office work environment and spreadsheets.

Certification

When the course is completed learners will be given a project to complete within 15 days, which covers all the key aspects of the course. The completed project is assessed by Big Data panel members and if it meets the requirements the certificate is issued.

Support

Online learners have access to technical and non-technical support through email with replies within 1 working day.

Discounts

For multiple discounts, site licences, e-learning credits or to find out if discounts are available on mixed course purchases please phone a customer advisor on 0844 854 9218.

Payment Options

The most straight forward method of payment is to select the number of users you require and add the product to your shopping cart by selecting Add to Cart. You will then be able to make payment using most credit and debit cards or a Paypal account. If you would like to pay by BACs transfer or by invoice please contact a customer advisor on 0844 854 9218 or email [email protected]

Additional information

Subject

guided-learning-hours

level

resource-type

mobile-compatible

online-access-duration

Reviews

There are no reviews yet.

Be the first to review “Using Excel as a Data Analysis Tool – Common Tips and Tricks”

Your email address will not be published. Required fields are marked *

You may also like…

  • Excel 2013 – Online Course Bundle (7 courses)

    £40.00
    Sold By: Core Learning Services (009)Add to cart
  • Microsoft Excel 2010

    £60.00
    Sold By: FilteredAdd to cart
  • Microsoft Excel 2010 Advanced

    £60.00
    Sold By: FilteredAdd to cart

Keep up to date with what’s happening in the world of education, training and skills. Receive details of offers and newly launched courses, and tips on effective online and blended learning practise by signing up to our monthly newsletter. We guarantee not to sell or pass on your details and you can unsubscribe at any time.

Marketing permissions

eLearning Marketplace Ltd only use the information you provide on this form to send you a monthly e-newsletter.

You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at [email protected] We will treat your information with respect. For more information about our privacy practices please see our Privacy Policy. By clicking below, you agree that we may process your information in accordance with these terms.

We use MailChimp as our marketing automation platform. By clicking below to submit this form, you acknowledge that the information you provide will be transferred to MailChimp for processing in accordance with their Privacy Policy and Terms.