IT & End User Training

Ready to Advance Your Excel Skills? 

OfficePro is a certified Microsoft Learning Partner

​​What :     Instructor-Led Advanced MS Excel 2013 Course

When:    Friday, August 18, 2017

                 9am - 4pm (12-1 lunch, not included)

Where:  OfficePro, Inc computer lab

                 8 Granite Place, #26

                 Gaithersburg, MD 20878

                 301-468-3312

Cost:      $229



Spots will fill up quickly! Reserve your spot now.

This course is on our PC with our Excel software. Enjoy a small group environment with plenty of one-to-one assistance from a friendly, knowledgable trainer who not only knows the software, but knows how to teach it to others. You should already have experience with Excel before taking this course.
Learn more about our successful training process here.
 


After this course, you'll be able to:

  • Automate worksheet functionality
    • update workbook properties
    • create and edit a macro
    • apply conditional formatting
    • add data validation criteria
  • Audit worksheets
    • trace cells
    • troubleshoot invalid data and formula errors
    • watch and evaluate formulas
    • create a data list outline
  • Analyze and present data
    • create sparklines
    • create scenarios
    • perform a what-if analysis
    • perform a statistical analysis with the analysis toolpak
    • create interactive data with power view
  • Work with multiple workbooks
    • consolidate data
    • link cells in different workbooks
    • merge workbooks
  • Export Excel data
    • ​export data
    • import a delimited text file
    • integrate Excel data with the Web
    • create a Web query