About Us

So What's Exprep?

ExPrep is an interactive, self-paced and hands-on Microsoft Excel® training application. Conveniently available in your Excel® after downloading, the application provides preset problems that adhere to different Excel® topics. As users work through preset problems, the application tracks the user in Excel®. The program then provides interactive feedback to help correct user mistakes and also suggests more efficient and effective methods to solve problems such as using shortcut keys.

Customized Solutions

ExPrep creates customized training solutions to cater to specific company needs. Employees can learn from interactive training worksheets that reflect the spreadsheets and functions that they may be using everyday. For example, new employees could learn from a Financial model through ExPrep that reflects what they will be doing in the workplace frequently.

Technical Requirements

Requirements

  • Windows operating system
  • Microsoft Excel 2010-2016

ExPrep's Microsoft Excel Training Courses

Click the package to show its lessons.

The first ExPrep package consists of 50 Excel proficiency topics including format- ting and navigation options. The package is designed for novice Excel® users starting from the basics.

  • Lesson 1: Create Worksheets & Workbooks

  • Section 1: Create Worksheets & Workbooks

  • 1) Create new Workbook
  • 2) New Workbook with Template
  • 3) Add Worksheet
  • 4) Copy & Move Worksheet

  • Section 2: Navigate Through Workbooks

  • 5) Insert Hyperlinks
  • 6) Go To
  • 7) Go To Special

  • Section 3: Format Worksheets & Workbooks

  • 8) Change Worksheet Tab Button
  • 9) Modify Page Setup
  • 10) Delete Columns/Rows
  • 11) Insert Columns/Rows
  • 12) Adjust Row Height & Column Width
  • 13) Insert Headers & Footers

  • Section 4: Customize Options & Views for Workbooks

  • 14) Hide Worksheets
  • 15) Hide Columns/Rows
  • 16) Change Workbook Views
  • 17) Zoom in/out
  • 18) Display Formulas
  • 19) Freeze Panes
  • 20) Split Window

  • Section 5: Configure Workbooks to Print & Save

  • 21) Set Print Area
  • 22) Save Workbook in Alternate File Format
  • 23) Print Individual Worksheet
  • 24) Set Print Scaling
  • 25) Repeat Headers & Footers
  • 26) Save Files to Remote Locations

  • Lesson 2: Create Cells & Ranges

  • Section 1: Format Cells & Ranges

  • 27) Find and Replace Data
  • 28) Copy & Paste Data
  • 29) Use Autofill tool
  • 30) Delete Cells
  • 31) Insert Cells
  • 32) Merge Cells
  • 33) Modify Cell Alignment & Indents
  • 34) Change Font & Font Styles
  • 35) Use Format Painter
  • 36) Wrap Text
  • 37) Apply Number Format
  • 38) Apply Highlighting

  • Section 2: Order & Group Cells & Ranges
  • 39) Transposing Column/Row
  • 40) Create Name Ranges
  • 41) Create Outline
  • 42) Insert Subtotal

  • Lesson 3: Apply Functions & Formulas

  • Section 1: Utilizing Cell Ranges & References

  • 43) Relative Referencing
  • 44) Absolute Referencing

  • Section 2: Summarize Data with Functions

  • 45) Sum Function
  • 46) Min Function
  • 47) Max Function
  • 48) Count Function
  • 49) Average Function
  • 50) IF Statement

    This package is designed to help users become Excel proficient and become familiar with charts/graphs and more advanced functions.

  • Lesson 1: Create Worksheets & Workbooks

  • Section 1: Create Worksheets & Workbooks

  • 1) Set Data Validation
    Lesson 2: Order & Group Cells & Ranges

  • Section 1: Order & Group Cells & Ranges

  • 2) Apply Conditional Format
  • 3) Insert Sparklines

  • Lesson 3: Create Tables

  • Section 1: Create Tables

  • 4) Move Between Tables
  • 5) Add/Remove Cells in Tables
  • 6) Define Titles

  • Section 2: Modify Tables

  • 7) Apply Styles to Tables
  • 8) Band Rows and Columns
  • 9) Insert a Row
  • 10) Remove Style to Table

  • Section 3: Filter and Sort Table

  • 11) Filter Records
  • 12) Sort Data in Multiple Columns
  • 13) Change Sort Order
  • 14) Remove Duplicates

  • Lesson 4: Order & Group Cells & Ranges

  • Section 1: Conditional Logic With Functions

  • 15) Sum If Function
  • 16) Average If Function
  • 17) Count If Function

  • Section 2: format & Modify Text with Functions

  • 18) Right Function
  • 19) Left Function
  • 20) Mid Function
  • 21) Trim Function
  • 22) Upper Function
  • 23) Lower Function
  • 24) Concatenate Function

  • Lesson 5: Create Charts & Objects

  • Section 1: Create a Chart

  • 25) Create Graphs & Charts
  • 26) Add More Data Series
  • 27) Switch Between Rows/Columns
  • in Source Data
  • 28) Use Quick Analysis

  • Section 2: Format Chart

  • 29) Add Legends
  • 30) Resize Charts & Graphs
  • 31) Modify Chart & Graph Parameters
  • 32) Apply Chart Layout & Style
  • 33) Position Chart & Graph

  • Additional Functions

  • 34) Round Formula
  • 35) Vlookup
  • 36) Hlookup
  • 37) Index + Match Functions
  • 38) AND Function
  • 39) OR Function
  • 40) Protect Worksheets

In The News