Excel LOOKUPs are powerful and versatile functions that save time and effort when working with large datasets. They are some of Excel's most valuable and least understood functions. They search for specific values within a data range and return related information from another location. In this workshop, we will explore ways to return data using advanced techniques […]

This class should be a prerequisite for all classes as students will learn how to organize files and folders, search for items on their computers, and use and personalize Windows. Students will also learn how to browse the Web and gain an understanding of viruses and malware.

This course will teach students how to work with large worksheets in Microsoft Excel and use multiple worksheets and workbooks efficiently. It will show how to link information from different worksheets and workbooks and introduce more advanced formatting techniques, such as creating custom number formats. In addition, students will learn how to create outlines subtotals […]

Excel Tips & Tricks can significantly increase productivity and efficiency by allowing you to work smarter and faster. Learning Excel tips is highly beneficial for anyone working with data or spreadsheets regularly. Understanding keyboard shortcuts, formula shortcuts, data manipulation techniques, and data analysis features can save time and reduce errors. Given its myriad features, we […]

Is your HR Department wasting time manipulating canned reports from HCM and payroll systems? Do you need help accessing and analyzing data quickly? Are data errors causing you concerns? Whether auditing, reconciling bills, calculating bonuses and PTO, or analyzing turnover data, Excel offers tools to help. Based on guidance from HR experts and our interaction […]