Learn to customize and format data efficiently in Excel 2016, including formatting, data manipulation techniques, and efficient formula usage. 

By completing this program, you will:

• Explore custom formatting and conditional formatting.
• Discover data manipulation techniques for finding, sorting, and filtering data.
• Understand effective formula usage for working with data. 

You can expect to enhance your job-based skills in the Computer Skills and Technology workforce development competency. 

Explore all of the courses you'll take in this program. You'll find the course name, a description, and the length of time it will take to complete each course below. We recommend you complete the courses in the order they appear below.

Excel 2016: Custom & Conditional Formatting (0.5 Hours)

To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.

Excel 2016: Finding, Sorting & Filtering Data (0.75 Hours)

Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.

Excel 2016: Referencing Data (0.75 Hours)

Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.

Excel 2016: Working with Formulas (0.75 Hours)

In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values.

Excel 2016: Creating Charts & Graphics (1.0 Hours)

Analyze and present your data in a visually attractive manner in Excel 2016. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.

Excel 2016: Using Conditional Formulas (0.75 Hours)

In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.

Excel 2016: Extracting Information with Formulas (0.75 Hours)

Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.

Want to learn more? Once you've completed all of the required courses, consider continuing your learning with the following optional activities. Unlike the required courses, you do not need to complete these to earn your certificate. 

Digital Books and Videos

Discover a world of resources with the Empire KnowledgeBank (EKB) and Skillsoft eBook and Video Portal. Search EKBSS_TMPL20150123135209420 in SLMS. You'll gain access to the following free digital books and online videos, as well as thousands more! Using the EKB and Skillsoft eBook and Video Portal.

Recommended Reading

• Excel 2016 for Dummies, by Greg Harvey
• Excel 2016 in Easy Steps, by Michael Price, Mike McGrath
• Essential Excel 2016: A Step-by-Step Guide by David Slager

Recommended Videos

• Microsoft Excel 2016: Basic Formulas, by Karen Henderson (9:00)
• Microsoft Excel 2016: Format Data in Microsoft Excel 2016, by Karen Henderson (4:00)
• Microsoft Excel 2016: Basic Sorting, by Karen Henderson (6:00)
• Microsoft Excel 2016: Using Tables, by Karen Henderson (5:00)
• Microsoft Excel 2016: Creating Charts, by Karen Henderson (6:00)
• Microsoft Excel 2016: The IF Function, by Karen Henderson (8:00)

Training 

These courses are offered by the Partnership and are open to all CSEA-represented NYS employees. Webinars can be taken from any computer with a connection to the Internet. You can also view recordings of webinars.

Recommended Courses

• Computer Basics
• Get More Done with Keyboard Shortcuts (webinar)
• Microsoft Excel Basics
• Microsoft Excel Intermediate
• Understanding Today's Computer (webinar)

Recommended YouTube Videos

• Excel 2016 Exam 77-727 – All of the Formulas and Functions on the Excel 2016 Certification Exam (19:58)

• Top 15 Advanced Excel 2016 Tips and Tricks (22.06)

All CSEA-represented NYS employees are eligible to participate.

Management/Confidential NYS employees with an Empire KnowledgeBank (EKB) license are also eligible to participate. Contact your agency training officer for information on obtaining an EKB license.  

Supervisory approval is not required for courses taken outside the normal workday. It may be possible for employees to take courses during working hours with supervisory approval.

• Register for the program anytime between January 16 and July 15, 2024. 
• Take all of the required courses online in SLMS anytime from January 16 through July 16, 2024.  
• To earn a certificate, you must complete all seven courses and achieve a passing grade of 70% or higher in each course by the program's end date of July 16, 2024.
• To print your certificate, login to SLMS, go to the My Learning page, locate the appropriate certificate program, and select the Print Certificate button. The Print Certificate button will only be available if the status is Completed.

To participate, you must follow our two-step registration process. The first step varies for CSEA-represented NYS employees and Management/Confidential NYS employees. 

CSEA-represented NYS employees: Apply for a Partnership Online Learning License in the Statewide Learning Management System. Search P_OL_Program in SLMS. Please allow up to five business days for license approval.  

NYS Management/Confidential Employees: Contact your agency training director to obtain an Empire KnowledgeBank license if you don't have one already.  

Once you have an active license, you can register for the program in SLMS. Search P_MEI24 in SLMS.   

registration details

Please be sure you're using Google Chrome to access SLMS. If you don't have the internet browser on your computer now, submit a ticket to ITS to have it installed. 

You will not be able to access any of the courses in the certificate program until you have followed the two-step registration process noted above. Please allow up to five business days for license approval. New state employees typically won’t get access to SLMS until after their first paycheck. 

Still need help or have questions? Contact us at (800) 253-4332 or email [email protected].