Excel-2010-Essentials

Excel 2010 Essentials

Improve your understanding in the essentials 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!

Course delivery method: – online tutorial or 1-day corporate workshop
This Course is just 1 of the 43 in our ‘Skills, Strategies and Solutions Series’ of:

  • Online Tutorials
  • Corporate Training Programs – Soft Skills Collection

So, Register NOW, gain instant access and start straight away…

How to register get started straight away:
Click ‘register’ and follow the prompts on the screen

 

Excel 2010 Essentials Course Outline:

Module One: Getting Started

  • Icebreaker
  • Housekeeping items
  • PreAssignment Review
  • Workshop objectives
  • Action plans and evaluation forms

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Working with the Backstage View
  • Understanding Worksheets
  • Understanding Workbooks
  • Closing Excel

Module Three: Your First Worksheet

  • Entering Data
  • Using the Wrap Command
  • Editing Data
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via EMail
  • 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
  • Understanding the New Function Names
  • Understanding the Formulas Tab
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Using the Status Bar to Perform Calculations

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 Shading
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

  • Words from the Wise
  • Review of Parking Lot
  • Lessons Learned
  • Completion of Action Plans and Evaluations

Enrolment Process

You can enrol and start on your course today!

1. Click the ‘Enrol Now’ tab to begin the buying process.

2. Your cart will show that you can buy more than one copy of this course. You can add other courses by going to back to the courses page and selecting another course of your choice. Click add to cart to add a new course to your purchase. Click ‘proceed to checkout’ on the right hand side of the page, when you have finished shopping.

3. The next page will display your order information. Click next to continue.

4. If you are a new customer you need to register an account under the registration column. NB. Make sure you remember your username and password as this information grants you access to your online tutorial (course). If you are an existing member (customer) of Global Training Institute, you can login on the left side of the page. Click next to go to the payment page.

5. On this page you can choose your payment method, either bank transfer or PayPal (Accepts credit card or your PayPal account). Read the terms and conditions and check the box. You will receive an order invoice in your email inbox. Click next to continue.

6. You will be redirected to PayPal, where you can complete the payment process.

7. Your course will be approved within our next office day and an email will be sent to confirm your course is online and available for you to commence.

8. Enjoy your online training experience and we trust that you will gain new skills and knowledge through doing your tutorial.

Start today!

Click the Button Below to enrol in a Short Course and start today!

Enrol Now

 

 

How long does the course take?

1 week with (24 months access) depending how much time you can allocate to completing your Short Course

Online Prerequisites

  • Computer Pc or Mac
  • Google Chrome or Firefox 10+
  • Internet Connection
Payment Options

 

 

$37