Microsoft Excel 2010 Course E-learning Intermediate & Expert

Product type
Logo OEM Office Elearning Menu EN
Provider rating: starstarstarstarstar 10 OEM Office Elearning Menu EN has an average rating of 10 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

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 whe…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft Excel, Internet Security, E-commerce, Microsoft Word, and Microsoft Powerpoint.

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

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
Level 2: Proficient user
Learning intermediate skills for Excel 2010
Estimated time: 04:40
7 modules - 56 topics

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 Printing and page layout of a chart Total number of topics in the module:3
Do more with your Excel table
By declaring your data as a table, you have access to easy sorting and filtering and other time-saving options.
Subtotal rows
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
Total number of topics in the module:11

Grasped the basics? Take the next step
Simple, common commands that you should be at ease with before you move on to more complex tables.
Displaying several lines of data in one cell
Absolute reference in a formula
Copying values, copying with a link, transposing
Sheet name, tab colour
Inserting and deleting sheets, sheet background
Moving, copying, hiding sheets
Total number of topics in the module:6

Illustrate your data
Use simple techniques with charts, shapes, text boxes and pictures to brighten up your data.
Creating a drawing object Selecting and deleting objects Copying and moving objects Inserting a picture
Total number of topics in the module:4

Create striking charts
Formatting commands for producing high-impact charts.
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
Creating a sparkline
Managing sparklines
Total number of topics in the module:12

Create graphics that get noticed
A little formatting to achieve maximum effect with shapes, text boxes, pictures etc…
Resizing a drawing object Modifying a text box Modifying a drawing Formatting drawing objects Managing pictures
Rotating and aligning objects
Stacking and grouping objects
Total number of topics in the module:7

Get clever (tips and tricks)
Choose the tips that fit what you do; not everyone will need all of these.
Simple conditions
Custom formats
Applying a conditional format Managing conditional formats Naming a range of cells Validation criteria
Converting data
Creating a data series
Using cell ranges in functions Summarising data with an outline Custom views
Attaching a comment to a cell
Calculating with copied values
Total number of topics in the module:13

Excel 2010 En
Level 3: Advanced user
Learning advanced skills for Excel 2010
Estimated time: 04:00
7 modules - 48 topics

Learn some new functionality
Find out about creating hyperlinks, converting workbooks, protecting workbooks and cells, managing and retrieving versions of your files,
Hyperlinks
Converting Excel files Protecting workbooks Protecting specific cells Versions and recovery of files
Total number of topics in the module:5

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
Total number of topics in the module:7

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 Consolidation
Total number of topics in the module:9

Customise, bring up to date
Adapt the ribbon or the themes to suit your preferences, create and use your own templates, customise the workbook properties.
Creating and customising a theme
You need to know: Styles and templates Creating and working with templates Modifying and deleting templates Workbook properties
You need to know: Customising the ribbon
Total number of topics in the module:6

Achieve expert status
Advanced commands for advanced users. You will also find here help with tools like the
Solver, designed for specific types of calculation.
Detecting errors Evaluating formulas The Watch Window Financial functions Double entry data table Goal seek
The Solver Managing scenarios Macros
Total number of topics in the module:9

Share and collaborate effectively
Excel proposes different solutions for a safe exchange of data: importing, exporting and
publishing, sharing, merging, signing the data etc…
You need to know: Exporting data
Diffusing Excel data: PDF, XPS, e-mail and Web page
Importing data
Updating and managing imported data
Sharing a workbook
Tracking changes in a workbook
Merging workbooks
Finalising a workbook
Digital signatures
Total number of topics in the module:9

Find out more…
Tips on methodology, approaches to teamwork… skills that will help you optimise your use of Excel.
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
Total number of topics in the module:3

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.