Course curriculum

  • 1

    Introduction

    • Course Details

    • 01a-Excel_Intro_Toolbox
  • 2

    Download Tool-Box File to Practice

    • Tool Box File - Macros need to be enabled
  • 3

    Demo Videos

    • Amputate Text & Flash

    • AND OR

    • Audit

    • Average

    • Camera

    • Charts Interpolate

    • Code Matching

    • Concatenate & Wrap

    • Consolidate

    • Conditional Formats

    • Data Entry Skills

    • Data Fix Cleanse

    • Data Pivot Tables

    • Date Calculations

    • Dropdowns

    • Error Supression

    • Fill Blanks - Flash

    • Find Unique

    • Fix Dates

    • Frequency

    • Hide Blanks

    • Holiday Fetch

    • IFs

    • Indirect

    • Indirect Row builder

    • Leading Zeros

    • Linking Data

    • Loan Calculator

    • Lookup

    • Macros Intro

    • Multiple rows

    • Macro_Range Select

    • Macro Transpose

    • Macro_Uppercase

    • Name Sheets Auto

    • Number Formats

    • Random

    • remove accents

    • Repair Text

    • Replace Table

    • Rounding

    • Search or Find

    • Series

    • Text to Collumns

    • Unique values

    • Validation

    • Week Calc

    • Weighted Avg

    • Words to Numbers
  • 4

    Summary

    • Well, that's it for now.... I hope you enjoyed the demos and learned a few new tricks in Excel.

    • Excel Overview Ending Video
  • 5

    Resources

    • Files