Microsoft Office

Excel - Level 1 Course

by Certstaffix® Training

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

Microsoft Excel Training

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

This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly. Learn how to: Quickly set up workbooks, enter data, and format it for easier viewing, Perform calculations and find and correct errors, Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps and Print worksheets and charts

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

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 Register ➥   May 12, 2022     
 Register ➥   May 23, 2022     
 Register ➥   June 7, 2022     
 Register ➥   June 22, 2022     
 Register ➥   July 6, 2022     
 Register ➥   July 19, 2022     

Group Onsite Training
At Your Organization


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)

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

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

Suggested Follow-Ons

Course Topics

Chapter 1: Set up a workbook 3
Explore the editions of Excel 2016 4
Excel 2016 4
Excel Online 4
Excel Mobile Apps 5
Become familiar with new features in Excel 2016 6
Create workbooks 7
Modify workbooks 13
Modify worksheets 18
Merge and unmerge cells 23
Customize the Excel 2016 app window 26
Zoom in on a worksheet 26
Arrange multiple workbook windows 28
Add buttons to the Quick Access Toolbar 30
Customize the ribbon 33
Skills review 39
Practice tasks 40

Chapter 2: Work with data and Excel tables 43
Enter and revise data 44
Manage data by using Flash Fill 48
Move data within a workbook 51
Find and replace data 56
Correct and expand upon data 60
Define Excel tables 65
Skills review 69
Practice tasks 70

Chapter 3: Perform calculations on data 73
Name groups of data 74
Create formulas to calculate values 77
Sidebar: Operators and Precedence 88

Chapter 4: Change workbook appearance 111
Format cells 112
Define styles 118
Apply workbook themes and Excel table styles 121
Make numbers easier to read 127
Change the appearance of data based on its value 130
Add images to worksheets 138
Skills review 142
Practice tasks 143

Chapter 9: Create charts and graphics 237
Create charts 238
Create new types of charts 248
Customize chart appearance 252
Find trends in your data 260
Create dual-axis charts 263
Summarize your data by using sparklines 264
Create diagrams by using SmartArt 266
Create shapes and mathematical equations 271
Skills review 277
Practice tasks 278

Chapter 11: Print worksheets and charts 323
Add headers and footers to printed pages 324
Prepare worksheets for printing 330
Fit your worksheet contents to the printed page 331
Change page breaks in a worksheet 334
Change the page printing order for worksheets 335
Print worksheets 337
Print parts of worksheets 339
Print charts 343
Skills review 345
Course Description: Print It | Download PDF | Email It

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

Microsoft Excel Courses By City:

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