ANU School of Professional Development

 

Microsoft Excel Intermediate

COURSE DESCRIPTION
Building on the skills and concepts taught in Excel Basic, this course will introduce you to a more advanced level of Excel usage. You will learn how to use multiple workbooks efficiently, become familiar with more advanced formatting options, and work with advanced charting techniques, such as tread-lines and spark-lines. You will delve further into the capabilities of Excel by practicing with tables, creating and applying cell names, worksheet auditing and protection, and sharing workbooks via email. PivotTables and PivotCharts are also covered in this comprehensive course. By the end of this course you will be prepared for the Microsoft Office Specialist core-level exam for Excel (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel (exam 77-888).

DURATION: 6 hours

PREREQUISITES

  • Microsoft Excel Basic

COURSE OBJECTIVES

  • Expand your knowledge of Excel past the basic stages
  • Become familiar with the more advanced capabilities of Excel
  • Learn to safeguard your Excel workbooks
  • Seamlessly incorporate Excel into your daily workflow

WHO SHOULD ATTEND THIS COURSE?

  • Anyone who has completed Excel Basic
  • Anyone looking to integrate and utilize Excel at a higher than basic level

Related Courses:

Microsoft Excel 2013 Basic
Microsoft Excel Advanced


 

 

Training when you need it, where you need it.

ANU School of Professional Development, a division of American National University, offers training and certification programs in Cybersecurity, Information Technology, Project Management, process improvement, and leadership development.

Unlike other professional development programs, we deliver training when you need it, where you need it. ANU provides tailored or customized training curriculum based on your unique situation.

Schedule Training

 


 

Continuing Education
Information Technology Skills Program (ITSP)

The Information Technology Skills Program (ITSP) is designed to take a student with limited Information Technology (IT) exposure and teach the computer knowledge, IT proficiency, and provide industry certifications essential to begin a career in the IT field.

+ Read more / Register

 

GSA Schedule training
GSA SCHEDULE

ANU School of Professional Development is committed to partner with Government Agencies to Strengthen their capabilities. We provide innovative training solutions, resulting in significant performance improvement and compliance with regulatory guidance.

Contact us for upcoming course dates, times, and locations.

+ Learn more

 

Project Management training
PROJECT MANAGEMENT

Choose practical, comprehensive training in a wide array of professional business skill topics ranging from the practical skills and theoretical concepts needed to lead and manage complex projects to the leadership skills required to lead improvement initiatives that will result in positive bottom line results for your company.

+ Learn more