Home > Online Microsoft Training Courses > MS Office 2013 Online Courses >

Microsoft Excel 2013 Intermediate | Online Course

 
Our Price: £29.99 Exc VAT
Course Length: 35 Hours
Laptops Call us on (01455) 550622 or email info@focus4training.com
Contact Us Online Learning
Buy, Register and Start Learning Now >>>

Training Details
 
In this Microsoft Excel 2013 Intermediate course you are led through your learning by a virtual tutor - with voice and/or written instruction. Help is available throughout the course and if at any stage you are unsure of what to do you can press a button to show you the next step. Support is also available from Focus4 Trainings online support team. As soon as you purchase your course you will be able to login and start your learning. You will then have access to the course for a year.
Course Content
Microsoft Excel 2013: Intermediate
Customisation of the Quick Access toolbar
Customising the ribbon
Manipulation with sheets of multiple workbooks
Advanced paste options
Copying multiple items
Pasting external data into Excel
Advanced number formats
Custom number formats
Worksheet protection
Advanced work with Excel worksheets
Using references in formula
Comparing and connecting values using operations
Cell and range references
Conditional formatting values
Conditional formatting based on a formula
Function library
Text functions
Advanced text functions
Math functions
Statistical functions
Date and Time functions
Logical functions and conditional calculations
Nested functions
Errors in cells and their checking
Naming cell ranges
Data validation
Using slicers to filter data
Finding and replacing specific values
Removing duplicate data
Spitting text into columns
Flash fill