Excel 2016: Level 1

Excel 2016: Level 1 Course Description

Duration: 1.00 days (8 hours)

Microsoft Excel is the most widely used spreadsheet program available, embraced by home, school, and business users alike to manage data. This Microsoft Office Excel 2016: Level 1 course is a beginner program that introduces learners to the basic concepts and fundamentals of this powerful Office application.

Conducted by certified instructors at NetCom Learning, the Microsoft Office Excel training classes explain elementary details like how to open, save, and close files, how to format a spreadsheet, how to build basic charts, and how to enter formulae into a cell. Through comprehensive Excel 2016 online training and Instructor-Led Training (ILT), participants will learn to use the most important features of Excel with full proficiency.

Learn Office Excel 2016 to analyze, organize, calculate, revise, update, and present your data in the desired format easily and clearly. The Microsoft Office Excel 2016 training familiarizes students with the different features for creating spreadsheets, providing the fundamentals upon which they can build their knowledge and skills to become experts in data manipulation.

Next Class Dates

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 2016: Level 1 Course

  • » Students and professionals who want to learn basic Excel 2016 skills to create and work with electronic spreadsheets

Back to Top

Course Prerequisites for Excel 2016: Level 1

  • » Basic understanding of using Microsoft Windows 10 Operating System
  • » Microsoft Windows 10: Transition from Windows 7

Back to Top

This Course is also part of:

Back to Top

Excel 2016: Level 1 Course Objectives

  • » Get started with Excel and understand key terminologies
  • » Navigate a spreadsheet
  • » Modify and format a worksheet
  • » Learn to open, save, manage, print, and close workbooks
  • » Learn about different formulae and perform calculations
  • » Sort and organize data and import data from other applications

Back to Top

Excel 2016: Level 1 Course Outline

      1. Getting Started with Microsoft Office Excel 2016
        1. Navigate the Excel User Interface
        2. Use Excel Commands
        3. Create and Save a Basic Workbook
        4. Enter Cell Data
        5. Use Excel Help
      2. Performing Calculations
        1. Create Worksheet Formulas
        2. Insert Functions
        3. Reuse Formulas and Functions
      3. Modifying a Worksheet
        1. Insert, Delete, and Adjust Cells, Columns, and Rows
        2. Search for and Replace Data
        3. Use Proofing and Research Tools
      4. Formatting a Worksheet
        1. Apply Text Formats
        2. Apply Number Formats
        3. Align Cell Contents
        4. Apply Styles and Themes
        5. Apply Basic Conditional Formatting
        6. Create and Use Templates
      5. Printing Workbooks
        1. Preview and Print a Workbook
        2. Set Up the Page Layout
        3. Configure Headers and Footers
      6. Managing Workbooks
        1. Manage Worksheets
        2. Manage Workbook and Worksheet Views
        3. Manage Workbook Properties

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 2016: Level 1 Course:

Back to Top

Do you have the right background for Excel 2016: Level 1?

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