We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details


BECOME AN EXCEL GURU
In this online course you will learn everything from EXCEL 2013. Read the course Outline for topics of this excelent training. 

EXCEL 2013 Complete E-learning Course 
Publisher: Microsoft Gold Certified Partner*
Pay online and start today!

Microsoft Gold Certified Office Course E-learning online:

  1. Delivery time: Within a business day
  2. Supported browsers: Chrome, Internet Explorer, Edge and Safari
  3. Operating Systems: Microsoft Windows and Chromebook
  4. Services included: Technical support, course management, progress reports24x7 online access
  5. Additional Options: Pre-test - Your current knowledge will be visible in the training
  6. Certificate of participation when at least 70% of the course is successfully completed.
  7. Standard 365 days access to E-learning platform to train at your own pace and order. 
  8. A unique E-learning method in a virtual Microsoft Office environment
  9. Interactive multimedia lessons. (video’s with spoken explanations and subtitles)
  10. Practical Assignments with real- time analysis of the actions and results.
  11. 24/7 accessible in an online environment. You can use any computer connected to the Internet
  12. Results and progress reports.
  13. Can be integrated in LMS or ELO platform. (AICC, SCORM)
  14. Exam Preparation : Microsoft Office Specialist. ( MOS )
  15. Exam Preparation : European Computer Driving Licence. ( ECDL )
 


Course Delivery

Outline

Excel 2013 Beginner
Allocated time : 04:15:00

You need to know: About your spreadsheet application
Opening a workbook
Overview of the environment
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
Entering a calculation formula
Calculating a sum and other basic functions
Calculating a percentage
Reproducing data in adjacent cells
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
Page layout
Print preview and printing
Page breaks
Print areas
You need to know: Headers and footers
Headers and footers
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
Cell styles
Sorting data
Sheet name, tab colour
Inserting and deleting sheets, sheet background
Moving, copying, hiding sheets
Splitting the window, freezing a column/row
Repeating rows/columns on printed pages
Hiding elements of a sheet
Summarising data with an outline

Excel 2013 Advanced
Allocated time : 04:50:00 

Displaying several lines of data in one cell
Absolute reference in a formula
Copying values, copying with a link, transposing
You need to know: Calculating with functions
Control date, date formats
Simple conditions
Custom formats
Applying a conditional format
Managing conditional formats
Naming a range of cells
Validation rules
Multiple cell ranges and calculations in functions
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
Printing and page layout of a chart
Modifying data labels
Data series and chart axes
Managing series
Chart type options
Managing chart templates
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
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
You need to know: Flash Fill
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

Excel 2013 Expert
Allocated time : 04:00:00 

Converting data
Creating a data series
Custom views
Attaching a comment to a cell
Detecting errors
Evaluating formulas
The Watch Window
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
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
Protecting workbooks
Protecting specific cells
Sharing a workbook
Tracking changes in a workbook
Merging workbooks
Finalising a workbook
Digital signatures
Creating a form
Protecting and using a form
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

Speaker/s

Developed by a Microsoft Certified Gold Partner.
Elearning course developed by Microsft Office Specialist (MOS Master) professional teachers with over 27 years of experience.
Reviews
Be the first to write a review about this course.
Write a Review
Work Smarter, more efficient and productive

We are an international Microsoft training Partner, Microsoft Office Specialist (MOS) and authorised exam centre, with over 10 years experience in supporting organisations and individuals with their Microsoft Office training needs.

OEM Office Elearning Menu is an international Microsoft training centre and Microsoft Partner. With over 10 years experience in supporting organisations and individuals with their Microsoft Office training needs. In the Netherlands we have over 3500 satisfied customers and this number is growing daily.

Our speciality is providing the exact solution to your needs.


Do you use Microsoft Office for your daily work? Our learning programme not only saves time but can also save money and motivate you, by following our online courses and training programmes, tailored specifically to all levels.
Would you like to become a specialist in Microsoft Office, learning skills that will enable you to be able to improve your efficiency but also your knowledge?

OEM provides online training/courses for individuals and companies working with Microsoft Office. These courses are developed by certified Microsoft Office teachers. They enable you to go at your own pace and fully supported by OEM. ...

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.