Microsoft Excel 2010 Course E-learning Basics & Intermediate

Product type

Microsoft Excel 2010 Course E-learning Basics & Intermediate

OEM Office Elearning Menu EN
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)

Ready to work on your personal development? Book now!

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.

Excel 2010. In Microsoft 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):

• Certificat…

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.

Excel 2010. In Microsoft 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 1: Beginner Learning basic skills for Excel 2010

Estimated time: 04:05
6 modules - 49 topics

Get started in Excel
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
Creating a new workbook Using Microsoft Excel Help Zoom
Total number of topics in the module:16

Look good with easy formatting
Get the presentation of your tables right: apply colour, borders, etc…
Applying a theme
You need to know: Formatting characters
Formatting characters Character font and size Aligning cell content Cell colour
Cell borders
Total number of topics in the module:7

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 Total number of topics in the module:4
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. Simple numerical formats
Checking spelling
Find and replace
Inserting/deleting rows, columns and cells
Moving cells
Copying to non-adjacent cells
Merging cells
Orientation of cell content
Cell styles
Total number of topics in the module:9

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.
Page layout
Print preview and printing
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
Total number of topics in the module:8

Move on to more complex tables
Among other things, learn how to sort data, customise the presentation, copy formatting, and work with automatic dates.
Copying cell format quickly
You need to know: Calculating with functions
Control date, date formats
Sorting data
Splitting the window, freezing a column/row
Total number of topics in the module:5

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

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.