Home / Course catalog / Microsoft Excel Intermediate (0003)

Internal → Microsoft Office 365 → Microsoft Excel

Microsoft Excel Intermediate (0003)


Description
MS Excel is an electronic spreadsheet program that is used for storing, organizing, and manipulating data.
Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.

Remember: when in Excel, if you are doing it manually then you are doing it wrong. Excel provides formulas for pretty much everything.

--------------------------------------------------------

INTERMEDIATE level - for those that already know a lot of the Excel features and are looking for a refresher or to learn new functions and tricks.
Content
  • Create and manage dropdown lists (1:31)
  • CountIf, SumIf, AverageIf (1:59)
  • What-if Analysis (3:27)
  • TODAY Function (2:33)
  • Intro to Pivot Table (4:34)
  • Trim Function (2:54)
  • Trim and Clean (1:36)
  • CONCAT Formula (2:53)
  • Simple VLookUp Formula (2:00)
  • Was this training helpful? Tips for improvement? Let us know.
Completion rules
  • You must complete 70.00% of the content