Microsoft Office Excel 2010 – Advanced

Microsoft Office Excel 2010 is the latest version of Microsoft’s spreadsheet program. Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This new version of Excel incorporates robust error checking, numerous file validation/verification tools, image editing, and Sparklines (charts within individual cells). This Advanced level is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn about advanced analysis tools like the Scenario Manager, goal seek, Solver, PowerPivot, advanced functions, macros, and Visual Basic. Highlights of the course include a solid introduction to creating PivotTables with PowerPivot, coverage of advanced financial functions, hands-on practice with VLOOKUP, extensive coverage of PivotTables and PivotCharts, and an introduction to macros and Visual Basic.

Frequently Asked Questions

• When will I receive my certificate?
  Once you have completed your course you can immediately log in to your account and download/print your certificate.
• How long is my certificate valid for?
  Your certificate has lifetime validity. It does not expire.
• How can I pay?
  Our subscriptions are processed by PayPal, Stripe or you can use any Visa, Mastercard or American Express for payments. We do not collect or store your credit/debit card details.
• Is my payment secure?
  Your payment is totally secure. All payments are processed through a secure HTTPS web page using SSL. Learnlibrary never collects or stores your credit/debit card or bank details.
• How do I use Learnlibrary once I have paid?
  Once you have created your account and paid, you will receive a welcome email with a link to your learning platform so you can immediately start learning.