Microsoft Excel 2013 Intermediate
Microsoft Excel 2013 Intermediate
 
Course Price: £29.99 Exc VAT
Course Length: 35 Hours
Email Call us on (01455) 550622 or email admin@focus4training.com
Buy, Register and Start Learning Now >>>

 
Buy Today start Learning Today. Study Microsoft Excel Intermediate course with the help of a virtual tutor, with voice and/or written instruction. Sophisticated help is on hand throughout the course with Prompt me and Show me buttons to assist you. Exercises and quizzes will test you skills along the way.  Support is also available from Focus4 Training online support team and qualified trainers.  The course is valid for 1 year as a single user licence.  The approximate time needed to study is 35 hours. Studying Excel Intermediate will increase efficiency in the workplace, improve your prospects and take your skills to the next level. On completion of the course you will be awarded a certificate of completion.
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