What are Pivot Tables and why would I use one? Pivot Tables allow you to quickly summarize and analyze large amounts of data in lists and tables--independent of the original data layout in your spreadsheet--by dragging and dropping columns to different rows, columns, or summary positions. Example: If you have a spreadsheet that tracks student [...]
On Saturday, May 4th it’s an 8:20pm start when the Jacksonville Sharks come to town for “Blue Collar Night.” Bring your construction, plumbing, electrician, mechanical or company ID to the DCU Box Office or use the promo code "Hustle" via Ticketmaster and receive 15% off your single game ticket. The Massachusetts Pirates are members of [...]
Many times people waste more hours in Microsoft Excel doing things manually. By using the Formulas and Functions features you can decrease the amount of time spent entering and editing data in your spreadsheets as well as increase accuracy of your data. Example: Using the PROPER function you can change all capital or lower case [...]