Basics

  • Vlookup, Count, Max, Min
  • Round, Ceiling, Floor ...
  • Variation- MAX, MAXA
  • Printing

Linear equation

  • Slope using graph

Logical

  • If Else....

Financial

  • PV, FV, NPV, PMT, PPMT

Statistical

  • Probability (Normal Distribution)

Data Analysis

  • Pivot Table

A youtube playlist

  1. Create a new Bibliography entry
    • “References” > “Citations & Bibliography” > “Manage Sources” > “New”
  2. Insert Citation
    • Cursor in place > “References” > “Citations & Bibliography” > “Insert Citation”
  3. Insert Bibliography
    • Cursor in place > “References” > “Citations & Bibliography” > “Insert Bibliography”
  4. Managing
    • Master List & Current List- Sources in the Current List will be shown in the dropdown Insert Citation list. Make your selection
    • Make sure you have selected the appropriate style from the Style section of the Citations & Bibliography menu
  5. Footnotes
    • Cursor in place > “References” > “Footnotes” > “Insert Footnote”

You can find some videos/slides at the NSU Resource Drive
Z:\Faculty_Resources\BBA\Ayn\office tutorials

Here are some (relevant) youtube tutorials