Home/Microsoft Excel/Microsoft Excel Expert
Microsoft Excel Expert

Microsoft Excel Advanced 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
  • View Course Content below and see how you can quickly use features suc as Creating and Editing Web Queries, Analyzing Pivot Table Data , creating sparklines and much more
  • 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 Advanced 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 - Advance Package

Course Content and Further Information

Streamlining Workflow

  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Collaborating with Other Users

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access

Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Analyzing Data

  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Importing and Exporting Data

  • Export Excel Data
  • Import a Delimited Text File
  • Integrating Excel Data with the Web
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

Structuring Workbooks with XML

  • Develop XML Maps
  • Import and Export XML Data