Information

Services






  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
Have a question? Call us on (01455) 550622 or email info@focus4training.com
Study Method: Online Learning

Product Code: EXCEL2013INTERMEDIATE
Buy, Register and Start Learning Now >>>

Description
 
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


Share your knowledge of this product. Be the first to write a review »