Excel Basics Technical Training

Zoom

This workshop will consist of working with data and text in excel –making the spreadsheet presentable by changing font size and type,adding borders and color to cells, changing column width and row height, merging cells, applying number formats,freezing and unfreezing rows and columns,hiding and un-hiding columns.We will create some basic formulas such as entering a [...]

Excel Pivot Tables Technical Training

Zoom

Basic knowledge of Excel is required for this training. 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. [...]