Home/Microsoft Excel/Microsoft Excel Intermediate
Microsoft Excel Intermediate

Microsoft Excel Intermediate 2010 Online Training for 1 Year

  • 24*7 online learning with web-based anytime, anywhere access
  • Simulation learning replicates the Excel workbook, providing an immersive learning experience
  • Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions with real life examples
  • Reinforce your knowledge at the end of each section by completing the interactive self-test
  • Our Learning Management System enables you to stop and start your learning in any way that suits you including 30 minute bite size learning
  • Course navigation features allow you to jump directly to specific topics of interest quickly and easily or continue where you previously stopped
  • See?full course details here?or scroll to the bottom of the page to see course features
  • Special launch offer, 10% discount on all course purchases for a limited period only. ?Use?Discount Code MOSAICA10?for 10% off the Normal Price
  • Buy
 

Course Name 24 / 7 Expert Support Anytime, Anywhere Access Interactive Self Tests Duration Of
Course Access
Price Purchase
Excel Intermediate 1 year £ 19.95
EXCEL all in ONE 1 year £ 45.00
 

5 Reasons to Choose Mosaica Learning for your Professional Advancement

  • Mosaica?s online Professional and IT Training enables you to learn anytime and anywhere at your convenience with 24/7 Support
  • Our online courses save? you time and money as opposed to classroom based training which is heavily time intensive and much more expensive
  • Online learning allows people with busy work schedules, limited money or those unable to travel to still be able to develop professionally and personally; we believe learning should not be constrained by time, cost or location
  • Keeping up to date with relevant industry certifications is essential to stay ahead in today?s competitive world, keeping up to date by learning online is a practical solution
  • All our online Courses are Industry Approved or Accredited, giving you the confidence and assurance that the courses you will be studying are fit for purpose and 100% industry relevant

Microsoft Excel 2010 - Intermediate Package

Course Content and Further Information

Calculating Data with Advanced Formulas

Organizing Worksheet and Table Data

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data

Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts

Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Customizing and Enhancing the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates