Microsoft Excel Training from New Horizons Minnesota

All Excel Courses

{{value[0].Version}}

MS Excel icon Get hands-on Excel training to complete your job faster or stand out among candidates.

Popular Excel Courses Scheduled Soon


Course Starts Location Price
Excel 2016 - Part 1 7/07/2020 Minnesota
Excel 2016 - Part 2 7/07/2020 Minnesota
Excel 2016 - Part 3 7/09/2020 Minnesota

How do I become certified in Microsoft Excel?

To demonstrate your proficiency in using Microsoft Excel you can become a Microsoft Office Specialist (MOS) by completing and passing Exam 77-727 for Excel 2016. There is also an MOS Expert level exam for Microsoft Excel, exam 77-728 for Excel 2016. These Excel certifications can be used to acquire the Microsoft Master Certification which proves proficiency across the entire Microsoft Office Suite.

Beyond bolstering your résumé, holding an MOS certification can earn an entry-level business employee as much as $16,000 more in annual salary than uncertified peers.*

* Anderson, Cushing, and John F. Gantz. Skills Requirements for Tomorrow’s Best Jobs: Helping Educators Provide Students with Skills and Tools They Need. IDC/Microsoft. October 2013

2

Take These Exams

77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

3

Earn This Certification

MOS: Microsoft Office Excel 2016

How do I become an Excel Expert?

Become an expert in Excel by first determining how you need to work with data, then finding the most applicable training path.

Advanced Excel user

How can Excel help me work with Financial data?

New Horizons Excel training will help you format financial spreadsheets, use advanced functions, organize spreadsheets and create effective visually appealing reports and graphs.

How can Excel help me work with large amounts of data?

New Horizons Excel training will help you import data effectively, filter and organize data, use pivot tables to slice data into readable portions.

Why should I learn Excel at new Horizons?

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life.

Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

Because most businesses use Excel, learning how to use the application efficiently opens up more opportunities for employment and career advancement. When employees know how to use Excel, it improves their efficiency in the workplace. Employees who know how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.

Comprehensive Minnesota Excel training from New Horizons includes basic to advanced courses. Whether you're brand-new to Excel or seeking advanced knowledge, we've got you covered.

What Basic and Advanced Excel Skills Should I Expect to Learn at New Horizons Minnesota?

  • Write a range of fundamental Excel commands
  • Perform worksheet calculations
  • Build custom formulas
  • Amend elements in a worksheet
  • Apply formatting changes to cells
  • Manage workbook properties
  • Perform calculations using functions and formulas
  • Sort, filter and query data
  • Create and format tables
  • Visualize data with charts
  • Create advanced formulas
  • Analyze data with PivotTables and PivotCharts
  • Refer to internal and external worksheets
  • Perform LOOKUPs and audit formulas
  • Share and protect workbooks
  • Automate workbook functionality using validation rules and macros
  • Create sparklines and map data
  • Forecast data