Home / Course catalog / Microsoft Excel Novice (0002)

Internal → Microsoft Office 365 → Microsoft Excel

Microsoft Excel Novice (0002)


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.

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

NOVICE level - for those familiar with Excel basics but want to learn new features that can help and improve your work.
Content
  • How to create charts (3:40)
  • Tables (3:19)
  • Freeze Panes and View Options (4:21)
  • Find & Replace (1:54)
  • Transpose Columns and Rows (2:00)
  • Conditional Formatting (3:45)
  • Date & Time Formulas (1:05)
  • How to calculate the Average in Excel (1:53)
  • Min and Max formula (1:53)
  • How to export or save a .csv file (2:30)
  • How to Print an Excel Spreadsheet on One Page (2:27)
  • Was this training helpful? Tips for improvement? Let us know.
Completion rules
  • You must complete 70.00% of the content