knowledgebase search
Read & Learn
E-Learning - Excel
Learn Beginning and Advanced Techniques for getting the most out of Excel.
Beginning Excel
Advanced Excel
Part 1
Excel 101
- The Basics
Inserting Columns & Rows
Deleting Columns & Rows
Dragging and Dropping Data
Part 2
Making Your Report Beautiful
Colors, Fonts & Shading
Creating & Deleting Borders
Creating Headers & Footers
Merging & Centering Cells
Printing Grid Lines
Resizing Columns
Rotating Text
Wrapping Text
Part 3
Saving Money & Working Smart
Accessing GPAs from Mark Reporting
Using the Formula Function to Find Cumulative GPAs
Math Functions
Multiplication
Function
Sum
Function
Printing the Top Row
Reducing a Sheet for Printing
Part 4
Zangle Data & Pivot Tables
Sorting Data Fields
Concatenation
Exporting Data From Zangle
Dragging Pivot Tables
Pivot Table Charts
Pivot Table Filters
Proper Case Names
Saving Text Files as Excel Files