Microsoft Excel Excel 2013 Basic Advanced & Expert E-Learning

E-Learning Course Excel 2013 Basic Advanced & Expert Online

Order this unique E-Learning course Excel 2013 Basic Advanced & Expert, 1 year 24/7 access to a virtual Office Cloud environment with rich interactive videos, speech, subtitles, practical assignments with real-time analysis of your answers, progress monitoring through reports. This E-Learning also prepares you for the Microsoft Office Specialist MOS exam thanks to its high quality. Developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal LMS including reports and after 70% of the course a certificate of participation. SCORM capability.

Course content

Excel 2013 Basic, Advanced & Expert Online

Basic:

What you need to know about: Spreadsheets
Open workbooks
General work environment
Move in workbook
What you need to know about: Input help
Enter data
What you need to know about: Select, copy and move
Select and clear cells
Cancel operation and restore
Column width / row height
What you should know about: Saving files
Save workbooks
Customize cell contents
Create new workbook
Enter formulas
Sum and other simple calculations
Calculate percentage
Copy to adjacent cells
Simple number formats
Apply theme
What you need to know about: Format characters
Character formatting
Font and font size
Align cell contents
Cell color
Cell edges
Page layout
Print preview and print
Page break
Print range
What you need to know about: Header and footer
Header and footer
Using Excel Help
Spell check
Find and replace
Zoom in and out
Insert or delete rows, columns and cells
Move cells
Copy to non-adjacent cells
Quickly copy cell formatting
Merge cells
Cell contents orientation
Cell Styles
Sort a table
Worksheet name, tab color
Insert, delete worksheets and set background
Move, copy and hide worksheets
Block columns / rows, split screen
Print titles columns and rows repeatedly
Hide items on worksheet
Organize data in an overview  

Advanced:

Display multiple lines in cell
An absolute reference in formula
Copy, transpose calculation results and links
What you need to know about: Entering functions
System date and date format
Simple condition
Custom format
Apply a conditional formatting
Control conditional formatting
Range of cells name
Validation criterion
Range of cells in functions
What you need to know about: Charts
Create and move a chart
Managing a chart
Select chart elements
Add or remove elements
Format chart elements
Change graph text elements
Legend and plot area
Print a chart and page layout
Change data labels
Data series and chart axes
Manage sequences
Chart type options
Manage chart templates
Create a sparkline chart
Managing sparklines
Create a graphic object
Select and delete objects
Copy and move objects
Determine the size of a graphic object
Edit a text box
Edit a drawing
Format drawing objects
Insert a picture
Manage images
Rotate and align objects
Overlap and group objects
Calculate subtotals
Create and manage a table
View and sort table data
Automatic calculations in table
Automatic filtering
Custom filters
Empty and duplicate values
What you need to know about: Criteria ranges
Filter with criteria range
Filter and copy rows with criteria range
Criteria range calculations
What you need to know about: Autofill
What you need to know about: Pivot Tables and Charts
Create pivot table
Modify a pivot table
Select, copy, move, and delete a pivot table
Organize and format a pivot table
Filter and search in a pivot table
PivotChart

Expert:

Convert data
Create data series
Custom Views
Note to cell
Error checking
Evaluate formulas
Window Control
Search table and functions
Text functions
Calculate time
Calculate dates
Conditions with AND, OR, NOT
Nested conditions
Conditional functions
Matrix formula
Calculations with copies
To merge
Financial functions
Double entry table
Goal Seeking
Solver
Scenario management
Hyperlink
Create and modify a theme
What you need to know about: Styles and templates
Create and use a template
Edit and delete a template
What you need to know about: Data export
Excel data transfer: PDF, XPS, email and web page
Convert excel files
Import data
Update and manage imported data
Workbook properties
Workbook security
Protect cells
Share a workbook
Track changes to workbook
Merge workbooks
Finalize a document
Digital signature
Create a form
Secure and use a form
Macro command
Restore versions and files
Know Before You Go: Personalize the ribbon
What you need to know about: SharePoint site
What you need to know about: Microsoft account
What you need to know about: Good spreadsheet habits