Microsoft Excel 2010 Course E-learning Basics, Intermediate & Expert

In Excel 2010, you will learn everything that Excel 2010 has to offer. You will learn how to make simple calculations and formulas, create charts, add and edit elements and it gives you insight into cells and their formatting. You also learn how to work with tables, sorting and conditions, the use of objects and filters, export files/convert and hide items. 
You get more specific with formulas, calculations and conditions and working with pivot tables and functions. Furthermore, you will learn about the use of templates, macro commands and how you make sharing files with others through SharePoint.

Microsoft certified online Excel 2010 courses (Elearning):

• Certificate of participation when at least 70% of the course is successfully completed.
• 365 days access to Elearning platform to train at your own pace and order. 
• A unique Elearning method in a virtual Microsoft Excel environment
• Interactive multimedia lessons. (video’s with spoken explanations and subtitles)
• Practical Assignments with real- time analysis of the actions and results.
• 24/7 accessible in an online environment .You can use any computer connected to the Internet. 
• Results and progress reports
• Can be integrated in LMS or ELO platform (AICC, SCORM)
• Exam Preparation : Microsoft Office Specialist ( MOS )
• Exam Preparation : European Computer Driving Licence ( ECDL )
• Elearning course developed by professional teachers with over 27 years of experience
• Published by a Microsoft Certified Gold Partner

Excel 2010 En
Full training in 17 steps with exercises
Work through the 17 steps proposed for gradual and comprehensive training in Excel 2010
Estimated time: 20:45
18 modules - 173 topics

1.Discover Excel, work with a simple table
Discover Excel and carry out simple tasks: opening a workbook saving it, entering and modifying data etc…
You need to know: About your spreadsheet application

Overview of the environment
Opening a workbook 
Moving around a workbook
You need to know: Text made easy 
Entering data
You need to know: Selecting, copying, moving 
Selecting and deleting cells
Undoing and redoing an action 
Column width/row height
You need to know: Saving files Saving a workbook
Modifying the contents of a cell

2.Set out your first Excel calculations
A spreadsheet application is designed to calculate. Learn how to enter simple formulas.

Entering a calculation formula
Calculating a sum and other basic functions 
Calculating a percentage
Reproducing data in adjacent cells

3 Look good with easy formatting
Get the presentation of your tables right: apply colour, borders, currency symbols etc…

Simple numerical formats 
Applying a theme
You need to know: Formatting characters 
Formatting characters
Character font and size 
Aligning cell content 
Cell colour
Cell borders

Create a workbook and print your work
Some basic skills: how to print your work, or create a new workbook.

Page layout
Print preview and printing 
Creating a new workbook

1.Increase your efficiency
You will find yourself getting more done in less time once you have mastered these simple skills with cells, text and formulas, and learned how to make the most of Excel’s help. 

Using Microsoft Excel Help
Checking spelling 
Find and replace Zoom
Inserting/deleting rows, columns and cells 
Moving cells
Copying to non-adjacent cells 
Copying cell format quickly 
Merging cells
Orientation of cell content
Displaying several lines of data in one cell Cell styles
Absolute reference in a formula
Copying values, copying with a link, transposing

2.Customise your worksheets
An Excel workbook contains several sheets so that you can manage your data efficiently.
Learn to name them, move them, insert new ones…

Sheet name, tab colour
Inserting and deleting sheets, sheet background 
Moving, copying, hiding sheets

3.Move on to more complex tables
You are ready for more complex calculations or a more sophisticated presentation of your tables? Among other things, learn how to sort data, set conditions, work with automatic dates.

You need to know: Calculating with functions 
Control date, date formats
Simple conditions 
Custom formats
Applying a conditional format 
Managing conditional formats 
Sorting data
Naming a range of cells Validation criteria
Splitting the window, freezing a column/row

4.Print an attractive document
Make sure that your table looks as good on paper as it does on the screen: find out all about printing in Excel.

Repeating row/column headings on printed pages 
Hiding elements of a sheet
Page breaks Print area
You need to know: Headers and footers 
Headers and footers

5.Let charts explain your data
Present your data visually: learn about creating and customising charts.

You need to know: Charts Creating and positioning a chart 
Managing a chart
Selecting items in a chart 
Adding and removing items 
Formatting chart items 
Modifying a chart's text items 
Legend and plot area
Data series and chart axes 
Managing series
Chart type options 
Managing chart templates
Printing and page layout of a chart

10 Illustrate your data
Use simple techniques with charts, shapes, text boxes and pictures to brighten up your data.

Creating a sparkline 
Managing sparklines 
Creating a drawing object
Selecting and deleting objects 
Copying and moving objects 
Resizing a drawing object 
Modifying a text box 
Modifying a drawing 
Formatting drawing objects 
Inserting a picture
Managing pictures
Rotating and aligning objects 
Stacking and grouping objects

11.Move up a gear
Now that you are at ease with the basic commands, see how Excel can help you to work better, faster.

Converting data 
Creating a data series
Using cell ranges in functions 
Summarising data with an outline 
Custom views
Attaching a comment to a cell 
Detecting errors
Evaluating formulas 
The Watch Window Subtotal rows

12.Do more with your Excel tables
By declaring your data as a table, you have access to easy sorting and filtering and other time-saving options. If your needs are not too specific, these functionalities can even replace a database management system.

Creating and managing a table 
Presenting and sorting data in a table 
Automatic calculations in a table 
Automatic filtering
Custom filters
Blank cells and duplicates
You need to know: Advanced filtering with a criteria range 
Criteria ranges
Copying rows filtered using a criteria range 
Statistics with a criteria range

13.Pivot your data
They constitute one of the main advantages of a spreadsheet like Excel, so make full use of pivot tables.

You need to know: Pivot tables and pivot charts 
Creating a pivot table
Modifying a pivot table
Selecting, copying, moving or deleting in a pivot table 
Defining the layout and the presentation of a pivot table 
Filtering and searching for data in a pivot table
Pivot charts

14.Find the right formula
How to calculate with text, dates, times, arrays, conditions… and also how to use tools like Solver.

Lookup functions Text functions 
Time calculations 
Date calculations
Condition with AND, OR, NOT 
Nested conditions
Conditional functions 
Array formulas
Calculating with copied values 
Consolidation
Financial functions Double entry data table 
Goal seek
The Solver Managing scenarios

15.Find out what's new and exciting
Discover some new functionality, most of it easy to grasp, for presenting and processing data, managing workbooks etc…

Hyperlinks
Creating and customising a theme
You need to know: Styles and templates 
Creating and working with templates 
Modifying and deleting templates
You need to know: Exporting data
Diffusing Excel data: PDF, XPS, e-mail and Web page Converting Excel files
Importing data
Updating and managing imported data Workbook properties

16.Share and collaborate effectively
Excel proposes different solutions for a safe exchange of data: sharing, merging, various degrees of protection, signing the data etc…

Protecting workbooks 
Protecting specific cells Sharing a workbook
Tracking changes in a workbook 
Merging workbooks
Finalising a workbook 
Digital signatures

17.Find out more…
Tips on methodology, approaches to teamwork… skills that will help you optimise your use of Excel.

Macros
Versions and recovery of files
You need to know: Customising the ribbon 
You need to know: The SharePoint site
You need to know: Sharing a document over the internet
You need to know: Best practice with a spreadsheet application

Exercises
Try out your new skills on some authentic professional projects.
Exercise: Event budget Exercise: Event budget analysis
Exercise: Analysis of time worked on a project Exercise: Loan calculation
Exercise: Simple staff roster Exercise: Timesheet
Exercise: Table of this month's sales Exercise: Example of a lookup table Exercise: Address list
Exercise: Filtering to create personalised lists Exercise: Custom views of a workbook Exercise: Income statement
Exercise: Order form Exercise: January statistics
Exercise: Bookings for a training facility Exercise: Analysis of data from a database Exercise: Organisation of data on a sheet Exercise: Trade fair schedule
Exercise: Who's who in the company Exercise: Representing statistics visually