Excel Level 3 (2016/2013/2010)

Excel Level 3 (2016/2013/2010) Course Description

Duration: 1.00 days (8 hours)

This course is suited for those using Microsoft Excel Level 3 (2016/2013/2010). This course will be taught using Microsoft Excel. The Excel (2016/2013/2010) Level 1 and Level 2 courses cover diverse features of Excel, its formulas and functions, analysis and reporting of data, and tools for creating advanced workbooks and worksheets. The Microsoft Office Excel Level 3 (2016/2013/2010) course lets learners build upon their foundation and intermediate knowledge of working with spreadsheets.

Microsoft Office Excel Level 3 (2016/2013/2010) introduces participants to high-end features, like collaborating with others, and automating complex or repetitive tasks. The Microsoft Office Excel training classes also focus on developing the skill to use conditional logic to construct and apply elaborate functions and formulas.

Learn Office Excel Level 3 (2016/2013/2010) to become more productive and efficient in working with large amounts of data. The Excel online training and Instructor-Led Training (ILT) program prepares the individual to become competent in handling complex spreadsheets easily.

Next Class Dates

Dec 6, 2017
9:00 AM – 5:00 PM ET
Guaranteed to run class (GTR)
519 8th Avenue, 2nd Floor, New York, NY 10018
New York, NY 10018
Jan 17, 2018
9:00 AM – 5:00 PM ET
519 8th Avenue, 2nd Floor, New York, NY 10018
New York, NY 10018
Feb 14, 2018
9:00 AM – 5:00 PM ET
519 8th Avenue, 2nd Floor, New York, NY 10018
New York, NY 10018
Mar 14, 2018
9:00 AM – 5:00 PM ET
519 8th Avenue, 2nd Floor, New York, NY 10018
New York, NY 10018

View More Schedules »

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

Intended Audience for this Excel Level 3 (2016/2013/2010) Course

  • » This course is intended for students who wish to gain the understanding of Microsoft Office Excel 2010, 2013 or 2016.
  • » Experienced Excel users who want to learn more advanced Excel features to work with extensive data analysis and complex datasets, and learn about collaborating with others on workbooks

Back to Top

Course Prerequisites for Excel Level 3 (2016/2013/2010)

Back to Top

This Course is also part of:

Back to Top

Excel Level 3 (2016/2013/2010) Course Objectives

  • » Learn to work with multiple workbooks and worksheets
  • » Learn about advanced text and cell formatting
  • » Learn to share and link workbooks and worksheets and how to protect them
  • » Learn how to add custom controls and update changes
  • » Understand automating workbook functionality
  • » Learn to forecast data and create map data and sparklines
  • » Learn to locate errors in a spreadsheet

Back to Top

Excel Level 3 (2016/2013/2010) Course Outline

      1. Working with Multiple Worksheets and Workbooks
        1. Use Links and External References
        2. Use 3-D References
        3. Consolidate Data
      2. Using Lookup Functions and Formula Auditing
        1. Use Lookup Functions
        2. Trace Cells
        3. Watch and Evaluate Formulas
      3. Sharing and Protecting Workbooks
        1. Collaborate on a Workbook
        2. Protect Worksheets and Workbooks
      4. Automating Workbook Functionality
        1. Apply Data Validation
        2. Search for Invalid Data and Formulas with Errors
        3. Work with Macros
      5. Creating Sparklines and Mapping Data
        1. Create Sparklines
        2. Map Data
      6. Forecasting Data
        1. Determine Potential Outcomes Using Data Tables
        2. Determine Potential Outcomes Using Scenarios
        3. Use the Goal Seek Feature
        4. Forecasting Data Trends
      7. Appendix A: Microsoft Office Excel 2016 Exam 77-727
      8. Appendix B: Microsoft Office Excel 2016 Expert Exam 77-728
      9. Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts
      10. Appendix D: Cube Functions
      11. Appendix E: Importing and Export Data
      12. Appendix F: Internationalizing Workbooks
      13. Appendix G: Working with Power Pivot
      14. Appendix H: Advanced Customization Options
      15. Appendix I: Working with Forms and Controls

Back to Top

This training prepares students for the following exam(s):

  • » 77-727 : Microsoft Office Excel 2016 Exam
  • » 77-728 : Microsoft Excel 2016 Expert: Interpreting Data for Insights

Back to Top

Next Steps after taking this Excel Level 3 (2016/2013/2010) Course:

Back to Top

Do you have the right background for Excel Level 3 (2016/2013/2010)?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Award winning, world-class Instructors

Carmille A.
- Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis. Bio: Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS. Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.
Charles W.
- Expert in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access as well as Adobe Graphic and Web Designer (InDesign, Acrobat, Photoshop, Illustrator, Dreamweaver and Flash Catalyst)
- Holds an A.A.S in Graphic Design as well as various Awards and Affiliations, including MCT, MCP, MCAS, and Office 2007 Master.
- Senior Lead Trainer for over 10 years.

Bio:

Charles is a Technical Trainer & Instructional Designer for over 10 years. He is a Microsoft Certified Trainer and dedicates himself to Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access. He is also an Adobe specialist and holds a degree in Graphic Design.

Charles is well known for his high evaluation scores, achieving 8.75 out of 9 on a regular basis, teaching in one-on-one, instructor-led, and web-based environments; one of the reasons for his high evaluation is his expertise in increasing personnel performance by developing and implementing programs constructed from the job task analysis process. Charles currently teaches Adobe Graphic and Web Designer, and Microsoft Office Specialist courses at NetCom Learning.
Jayson F.
- Over 32 years of experience as well as 18 certifications, including Cisco, CompTIA, and Microsoft.
- Strong background, with web development & design of infrastructure for companies such as AT&T, Sports Illustrated, and Toys R Us.
- Specialist in applying process and finding solutions to solve them in addition to training people in the skills to manage the process and meet goals.

Bio:

Jayson is a talented and valued Microsoft Certified Trainer (MCT) with over 32 years of IT experience. Along with web development & design of infrastructure for companies such as AT&T, Sports Illustrated, and Toys R Us, he holds several IT certifications. He is a CCDA, CCNA, Security+ certified, MCDBA, and MCSE to name a few.

Jayson's focus is on finding solutions to problems and applying process to solve them. He instructs professionals in the skills to manage the process and meet goals, which makes him a respected trainer at NetCom Learning.
Paul B.
- Microsoft Office Specialist with over 14 years of training experience.
- Expert in the IT industry, working in the IT field since 1986.
- Highly rated instructor with an all-time average evaluation score of 8.7 out of 9.

Bio:

Paul is Subject Matter Expert specializing in the Microsoft Office Suite and SharePoint end-user technologies with more than 25 years of practical experience in the IT industry. He is also a Microsoft Certified Trainer (MCT) with over 14 years of training experience.

A sought-after instructor and eternal favorite among students, his instructor feedback scores are among the industry's highest at 8.7 out of 9.0. As a trainer, his knowledge and passion for the subject matter as well as his personable nature, excellent communications skills and sense of humor are implicit in every class. NetCom Learning is proud to have Paul on our roster of IT geniuses.
Richard O.
- IT specialist for over 30 years and Microsoft Certified Trainer (MCT) since 1995. - Microsoft SharePoint expert since 2001. - Microsoft Lync Server top instructor. Bio: Richard has been an IT professional for over 30 years and a Microsoft Certified Trainer (MCT) since 1995. He has been working with Microsoft SharePoint since the first version was released in 2001; an accomplished courseware designer he was recently selected by Microsoft to contribute to the official SharePoint 2010 courseware. Richard's boot camp students enjoy unprecedented pass-rates and scores on their certification exams. Richard's specialties include Microsoft SharePoint, Microsoft Exchange, Windows 7, SQL Server and Windows Server 2008. His latest passion is Microsoft Lync Server, where he is already distinguishing himself as a leading subject matter expert.
Sam P.
- Team leader for the first undergraduate team to win the Duke Startup Challenge.
- Over 15 years of experience in the IT industry.
- NetCom Learning Instructor of the Year 2011.

Bio:

Sam Polsky has spent his entire career in entrepreneurial pursuits, including such fields as biotechnology, software development, data management, and business process management. He began in entrepreneurship as team leader for the first undergraduate team to win the Duke Startup Challenge, a business development competition geared towards Duke Universitys various graduate schools.

Sam Polsky has since co-founded a consulting firm where he has been involved in software architecture, development and implementation. On top of that, Sam has been delivering acclaimed solutions in software architecture, development and implementation for over 15 years. He is a much-admired Subject Matter Expert and Trainer at NetCom Learning and was voted NetCom Learning Instructor of the Year 2011
Vijanti R.
- Specialist in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, FrontPage, and Access. Microsoft Office Specialist and Microsoft Office Master.
- Degree in Information and Business Technology from South Bank University - United Kingdom.
- Business professional since 1992 and Information Technology instructor since 2003.

Bio:

Vijayanti has been a business professional for over 20 years and an Information Technology instructor for over 10 years. She is a Microsoft Office Specialist and a Microsoft Office Master with a degree in Information and Business Technology from South Bank University in the UK.

Vijayanti also trained and qualified as an Information and Communications Technology Teacher. She has been working at Netcom Learning as a Software Instructor with an extensive know-how in Microsoft Office Suites.
Jose P.
Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University. He has a great skill set in analyzing data, specifically using Python and a variety of modules and libraries. He hopes to use his experience in teaching and data science to help other people learn the power of the Python programming language and its ability to analyze data, as well as present the data in clear and beautiful visualizations. He is the creator of some of most popular Python Udemy courses including "Learning Python for Data Analysis and Visualization" and "The Complete Python Bootcamp". With almost 30,000 enrollments Jose has been able to teach Python and its Data Science libraries to thousands of students. Jose is also a published author, having recently written "NumPy Succintly" for Syncfusion's series of e-books.
steven l.
- Steven has 20 years of experience in training areas in the pharmaceutical, financial, consumer products industries, and more.
- As a technologist with a specialty in data and project management, Steve has been responsible for leading development teams from the creation of a product through the entire project life cycle to the sales of the product.
- Steven has worked with both state and federal agencies in creating and deploying corporate solutions in a variety of areas.

Bio:
Over the years, Steven has developed and implemented professional development programs for several Fortune 100 companies. Steven is a consultant on SharePoint Project/Server deployments and is currently involved in providing PMO training in corporate settings.
Steven is an experienced trainer, holding Microsoft Trainer certifications in several areas.

See more...   See more instructors...

Back to Top

Recent Client Testimonials & Reviews

The instructor is very knowledgeable on the material. She was very fun and friendly. Kept me engaged.

- Jeanette S.

Course(s) Taken

» Excel 2016 Combo

The instructor was great and very knowledgeable. Great class!

- Amanda D.

Course(s) Taken

» Excel 2016 Combo

I really enjoyed the class. The instructor did a great job.

- Lisa M.

Course(s) Taken

» Excel 2016 Combo

  More testimonials »  

Back to Top