Excel - Level 2 Course Outline | Certstaffix® Training

Microsoft Office


Excel - Level 2 Course


Attend Our Classes From Home - No Software Needed - Learn More...

Excel - Level 2

by Certstaffix® Training

Microsoft Excel Training

Length: 1 day(s)      Public Class Price: $335/person (USD)      Group Class Price: Request Quote      Course Category: Microsoft Excel


Microsoft Excel Training
This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to: Perform Calculations on Data, Manage Worksheet Data, Reorder and Summarize Data, Combine Data from Multiple Sources, Analyze Alternative Data Sets and Collaboration.

Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)
Course Taught With: Excel version 2016 (Microsoft Windows PC) Software and Courseware
Not Appropriate For: Macintosh versions of Excel
Course Description: Print It | Download PDF | Email It

Certstaffix® Training public classes are instructor-led, live online training you attend from your location or our training labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor
  • Attend from your location or our training labs

Group Onsite Training
At Your Organization

OR

Private Online Training
Live Online Instruction

Have a group of several students needing the same training? Then onsite or private online group training is a perfect option for you. We'll either come onsite to your office or deliver a private live online class so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.


  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)

Microsoft Excel Training Reviews by Certstaffix® Training

Certstaffix® Training collects detailed class reviews via a formal post-class evaluation in all our instructor-led courses. Below are a sample of abbreviated reviews from real students from our past classes. If you would like more reviews or ones with even further detail, please contact us and we would be happy to show you the high quality of our training services.


Certstaffix® Class Reviews

Student Average:
4.77 out of 5 from 779 students

4.58 out of 5

Would highly recommend Certstaffix! Classes are VERY thorough and user friendly. :)Bobbye Garrity was awesome. :)


- attended our Excel 2016 Level 2 class

4.35 out of 5

We have a conference room secluded from the public so one can concentrate.


- attended our Excel 2013/2016 - Data Analysis with PivotTables class

5.00 out of 5

very informative


- attended our Excel - Level 1 class

4.55 out of 5

Very clear instructions, do wish the time for trial was a bit more


- attended our Excel - Level 3 class

4.94 out of 5

Today was wonderful! I learned so much! My instructor yesterday not only hasn't marked my course as complete for yesterday and took half the course speaking on micros and creating "buttons" instead of basic coursework needed to make today easier.


- attended our Excel - Level 2 class

4.78 out of 5

This was my third class and by far JoLynn was the best instructor. She was well organized, extremely knowledgeable and professional with her presentation. I would take another class if I know she was teaching.


- attended our Excel - Level 3 class

5.00 out of 5

This was a very interesting and useful class that I will put to work all that I learned today!


- attended our Excel - Level 2 class

4.91 out of 5

This class was amazing! I only signed up for the first one but will definitely see if my company will fund more I learned so many helpful things. It was never overwhelming like I expected from Excel, everything was explained easy and completely.


- attended our Excel 2016 Level 1 class

4.41 out of 5

The resources given after the class were very helpful.


- attended our Excel 2013/2010: Intermediate class

4.50 out of 5

the only problem I had were my own and my computer set up.


- attended our Excel - Level 1 class



Q: How Can I Learn Microsoft Excel Quickly?


A: Learning Microsoft Excel quickly will depend on your ability to identify which features and functions of the program you will need to use regularly to perform your job and focus on learning each while using good time-management skills. To further speed up the process of learning, you can take advantage of the software’s built-in shortcuts and workflow streamlining features. If you sign up for a reputable, instructor-led class, you can learn Excel skills in as little as one day.


More Information on How to Learn Microsoft Excel Quickly


Q: What is Microsoft Excel and Why is it Important to Learn?


A: Excel is a digital spreadsheet program created by Microsoft that can be used to enter, edit, and compute numerical data for professional business use. It increases productivity and the accuracy of important data. Those involved in finance management, accounting, and other positions that use spreadsheets to organize data may benefit most from professional training in Excel. Excel can be used to develop budgets, track sales, create reports, graph data, and streamline accounting tasks. Enrolling employees in an Excel training course is a great way to ensure they have the skills needed to succeed in their role at your company.


More Information on What is Microsoft Excel and Why is it Important to Learn.



Q: What's the Best Way to Learn Microsoft Excel for Beginners?


A: Learning the fundamentals of Excel can give employees the capability that they need to enter data into digital spreadsheets and process it quickly. Courses that teach the basics of Excel can define what workbooks are and train employees on how to correctly use formulas and program features. Investing in a live instructor who can guide students through tutorials is almost always the best way to teach Excel. At the end of a basics course, students should be able to track numbers, input data and formulas, sort through data, and create charts.


More Information on the Best Way to Learn Basic Microsoft Excel



Q: Is Excel Training and Certification Worth the Cost?


A: Business owners and employees who work with data and spreadsheets may find that Excel training can sharpen skills, ensure data accuracy, and increase productivity in the workplace. Formal training can pay dividends, especially if a certification test, such as the Microsoft Office Specialist (MOS) exam, is taken. Investing in training can help employees prepare for the test as well as reduce or eliminate the need for exam retakes. Moreover, employees may consider training and certification a worthwhile investment in their careers, as the skill can be applicable to future jobs and even different industries.


More Information on Microsoft Excel Certification Cost and Benefits



Q: What Are Advanced Excel Skills, and How Can I Learn Them Online?


A: When hiring managers talk about “advanced Excel,” they’re usually referring to Excel’s most complex features and functions and the higher-level skills that are required to use them. Employees with advanced Excel skills often occupy positions that require expert data analysis and organization, such as accountants and bookkeepers. To learn advanced Excel skills, you can enroll in online courses that offer training on how to work with common complex Excel features like VBA programming or PivotTables. Obtaining advanced Excel skills can often put you on the path to a promotion or help you stand out from a crowd of job applicants, and companies benefit from the greater efficiency that comes with having highly skilled workers.


More Information on Advanced Excel Skills and How to Learn Them Online



Q: Are Intermediate and Advanced Excel Skills in Demand?


A: While a basic knowledge of Microsoft Excel can improve employees’ productivity and help them contribute to the overall health of a business, intermediate and advanced Excel skills can transform employees into indispensable assets to employers. Higher-level Excel skills are applicable across several different industries, and hiring managers are increasingly seeking applicants with in-depth knowledge of the software. Employees with even basic Excel proficiency enjoy significant pay bumps and rosier long-term career prospects. Business owners who hire employees with great Excel skills can find themselves relying on their quick analysis of business-related data to make important decisions.


More Information on the Benefits of Advanced Excel Training



Q: Why Is Microsoft Excel Important, and What’s the Best Way to Learn It?


A: Learning Microsoft Excel is one of the best ways to increase your value as an employee. Aside from helping you to learn the skills necessary to successfully manage data, taking an Excel certification course and earning this credential can result in a pay raise or a promotion. While many employees choose to learn Excel in an on-site classroom, others are increasingly turning to online courses for instruction. The best courses are structured, specialized, and built upon preexisting knowledge. High-quality training courses can cost hundreds of dollars, regardless of whether the classes are taken in person or online.


More Information on Why Microsoft Excel Is Important and How to Learn It


Q: What Excel Skills Do Employers Value, and How Can I Improve on Mine?


A: While many employers value advanced Excel skills, basic Excel knowledge can also be in demand, as long as those skills are relevant to the job that you’re performing. At a minimum, employers expect that employees understand the fundamentals of the software, including basic navigation, formulas, find and replace, and sorting and filtering. To improve your Excel skills and stand out as a candidate, brush up on the fundamentals by reviewing basic features and functions and practicing them within the program. For top-notch, quick instruction, enroll in professional Excel courses designed to improve your skills within only a few days.


More Information on the Excel Skills Employers Value and How to Improve Them


Q: What Are the Benefits of Learning Excel, and How Can I Learn it Fast?


A: Professionals who rely on Excel to manage data may find that sharpening their Excel skills helps them to be more productive and efficient at organizing and analyzing data, performing complex calculations, and creating graphs and charts. Job-seekers with demonstrable Excel skills increase their attractiveness to employers, find it easier to make career transitions, and may even enjoy significant pay increases. To simplify and speed up learning Excel, determine which particular skills you need to effectively perform your job and sign up for Excel courses that build upon your knowledge and cover these concepts.


More Information on the Benefits of Learning Excel and How to Learn it Fast


Microsoft Excel Blogs

Microsoft Excel User Groups

Microsoft Excel Online Forums

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

MOS: Microsoft Excel Expert Certification
MOS: Microsoft Excel Associate Certification


Knowledge Pre-Requisites


Suggested Follow-Ons


Course Topics

Chapter 3: Perform calculations on data 73
Summarize data that meets specific conditions 90
Set iterative calculation options and enable or disable automatic calculation 96
Use array formulas 98
Find and correct errors in calculations 100
Skills review 106
Practice tasks 107

Chapter 5: Manage worksheet data 147
Limit data that appears on your screen 148
Manipulate worksheet data 153
Sidebar: Select list rows at random 154
Summarize data in worksheets that have hidden and filtered rows 155
Find unique values within a data set 161
Define valid sets of values for ranges of cells 163
Skills review 165
Practice tasks 166

Chapter 6: Reorder and summarize data 169
Sort worksheet data 170
Sort data by using custom lists 176
Organize data into levels 179
Look up information in a worksheet 184
Skills review 187
Practice tasks 188

Chapter 7: Combine data from multiple sources 191
Use workbooks as templates for other workbooks 192
Link to data in other worksheets and workbooks 197
Consolidate multiple sets of data into a single workbook 202
Skills review 205
Practice tasks 206

Chapter 8: Analyze alternative data sets 209
Examine data by using the Quick Analysis Lens 210
Define an alternative data set 212
Define multiple alternative data sets 216
Analyze data by using data tables 218

Chapter 14: Collaborate with colleagues 389
Share workbooks 390
Save workbooks for electronic distribution 394
Manage comments 395
Track and manage colleagues’ changes 398
Add protection to workbooks and worksheets 401
Finalize workbooks 408
Authenticate workbooks 410
Save workbooks for the web 412
Import and export XML data 414
Work with OneDrive and Excel Online 418
Skills review 424
Practice tasks 425
Course Description: Print It | Download PDF | Email It

Microsoft Excel Courses By City:

       FL - Winter Park       NC - Asheville       PA - York      
- - your home       GA - Atlanta       NC - Charlotte       PR - Puerto Rico      
AL - Birmingham       GA - Augusta       NC - Greensboro       QC - Montreal      
AL - Huntsville       GA - Columbus       NC - Raleigh       RI - Providence      
AL - Mobile       GA - Savannah       NC - Winston-Salem       SC - Greenville      
AR - Bentonville       HI - Honolulu       ND - Bismarck       SC - Myrtle Beach      
BC - Vancouver       IA - Des Moines       ND - Fargo       SC - North Charleston      
CA - Bakersfield       IA - Iowa City       NE - Lincoln       SK - Regina      
CA - Fresno       ID - Boise       NE - Omaha       SK - Saskatoon      
CA - Los Angeles       IL - Chicago       NH - Bedford       TN - Chattanooga      
CA - Merced       IL - Rockford       NJ - Bridgewater       TN - Knoxville      
CA - Modesto       IN - Bloomington       NM - Albuquerque       TN - Memphis      
CA - Napa       IN - Evansville       NM - Las Cruces       TN - Nashville      
CA - Oakland       IN - Fort Wayne       NM - Santa Fe       TX - Amarillo      
CA - Oxnard       IN - Indianapolis       NS - Halifax       TX - Austin      
CA - Rancho Cucamonga       IN - South Bend       NV - Henderson       TX - Beaumont      
CA - Sacramento       KS - Overland Park       NV - Reno       TX - Corpus Christi      
CA - Salinas       KS - Topeka       NY - Albany       TX - Dallas      
CA - San Diego       KY - Lexington       NY - Buffalo       TX - El Paso      
CA - San Jose       KY - Louisville       NY - New York City       TX - Fort Worth      
CA - Santa Maria       LA - Baton Rouge       NY - Rochester       TX - Houston      
CA - Santa Rosa       LA - Lafayette       NY - Syracuse       TX - Killeen      
CA - Stockton       LA - New Orleans       OH - Beavercreek       TX - Laredo      
CB - Caribbean       LA - Shreveport       OH - Cincinnati       TX - Longview      
CB - Kingston       MA - Burlington       OH - Columbus       TX - Lubbock      
CB - Nassau       MA - Springfield       OH - Highland Heights       TX - McAllen      
CO - Boulder       MA - Westborough       OH - Toledo       TX - Midland      
CO - Colorado Springs       MB - Winnipeg       OH - Youngstown       TX - San Antonio      
CO - Denver       MD - Largo       OK - Oklahoma City       TX - Tyler      
CT - Cheshire       MD - Laurel       OK - Tulsa       TX - Waco      
CT - New Haven       ME - Portland       ON - Ottawa       UT - Ogden      
CT - Stamford       MI - Ann Arbor       ON - Toronto       UT - Salt Lake City      
DE - Wilmington       MI - Flint       OR - Beaverton       VA - Charlottesville      
FL - Daytona Beach       MI - Grand Rapids       OR - Bend       VA - Glen Allen      
FL - Fort Lauderdale       MI - Lansing       OR - Eugene       VA - Harrisonburg      
FL - Fort Myers       MI - Livonia       OR - Medford       VA - Roanoke      
FL - Gainesville       MN - Minnetonka       OR - Salem       VA - Virginia Beach      
FL - Jacksonville       MO - Columbia       PA - Allentown       VT - Burlington      
FL - Lakeland       MO - St. Louis       PA - Erie       WA - Seattle      
FL - Miami       MS - Biloxi       PA - Harrisburg       WA - Spokane      
FL - Naples       MS - Jackson       PA - Malvern       WI - Eau Claire      
FL - Pensacola       MT - Billings       PA - Philadelphia       WI - Green Bay      
FL - Sarasota       MT - Montana       PA - Pittsburgh       WI - Madison      
FL - Tallahassee       NB - Moncton       PA - Reading       WI - Milwaukee      
FL - Tampa       NB - Saint John       PA - Scranton-Wilkes Barre