Learn the foundational features needed to work within this spreadsheet program, and the shortcuts that are available. Explore how to copy & move data, format cells, manipulate columns & rows, and how to manage multiple worksheets. You will also learn how to use the Print tools to control how your worksheets are printed, and how to create Headers & Footers.
Learn the foundation of how formulas work, how to build them, and how powerful they are. Explore the Function Library to discover the thousands of formula available to make it easier to build complex formula. We will examine the difference between Relative & Absolute formula and how to modify a formula. Creating a formula using the Insert Function will also be explored.
Now that you have learned the foundation skills of formulas, we will explore more complex functions. Discover how the IF function works and how to extract conditional results. Further explore how IF works within functions such as Sum & Count, and even how to create an Array formula to get multiple results. We'll also learn how to use the Concatenate and Lookup functions along with many more.
Use Charts to dramatically illustrate trends, compare sales and highlight changes. Learn how to create charts that give a pictorial representation of your data, and how to modify the objects in a chart. Customize your chart with special effects, drawing objects and graphics. Printing charts separately or with the spreadsheet will also be shown.
Excel can be a powerful tool for storing and manipulating data from contact information to schedules and more. This session focuses on how to effectively organize, filter and sort large amounts of data. Discover how to apply Conditional Formatting and Table Formats that create a more professional look to your data.
This workshop introduces the user to Macros and shows how to automate repetitive tasks. Participants will learn how to record and run macros, and modify macros through the Visual Basic Editor window. Students will also learn how to create and add macro buttons onto a customized toolbar.
Learn about the power of Pivot Tables to help you re-arrange large amounts of data into different views so you can make sense of the information you have. Using the Pivot Table Wizard, we will learn how to drag and drop current data to show comparisons, analyze data, and determine patterns/trends.
Participants should be proficient in using a keyboard and a mouse, and should possess familiarity with a Windows operating system (e.g. folders, files, opening and saving documents, etc.).