Search course
image
Cancel
Office Productivity >
Microsoft Office >
Personal Productivity
image

Excel for Novice: What You Need to Know about Formulas

Learn how to construct, explore, and efficiently apply Excel formulas to enhance productivity and effectiveness in a finance-oriented environment.

5.0
154 views
Created By : Biz Facility
1h 45m
Appropriate for all
English
Last updated : 3/2025

What you'll learn

  1. Building formulas
  2. Reviewing formulas
  3. Flash fill (Excel 2013 and later only)
  4. Financial formulas i.e. SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV

Overview

NOVICE - EXPLORING AND CREATING FORMULAS

Using Excel for business has almost no limits for applications. Here are some examples:

  • When planning a team outing to a baseball game, you can use Excel to track the RSVP list and costs.
  • Excel creates revenue growth models for new products based on new customer forecasts.
  • When planning an editorial calendar for a website, you can list out dates and topics in a spreadsheet.
  • When creating a budget for a small product, you can list expense categories in a spreadsheet, update it monthly and create a chart to show how close the product is to budget across each category.
  • You can calculate customer discounts based on monthly purchase volume by product.
  • Users can summarize customer revenue by product to find areas where to build a stronger customer relationships.
  • Use complex calculation methods, like Sharpe ratios.

Excel has powerful formula functionality. The goal of formulas is to automate processes that would require manual execution. Formulas are used to save you time and give you the edge when completing daily tasks. Join us as explore basic formulas and attempt to increase your efficiency with helpful formulas that you will need daily in an office space.

The objective of this session is to enable delegates to become comfortable with formulas that are typically used to increase efficiency in a finance environment. During this session we will look at:

  • Building formulas
    • Exploring available library of formulae within Excel
    • Cell referencing within formulas i.e. relative and absolute references
    • Mathematical operators within Excel
    • Duplicating (dragging) formulas without retyping
  • Reviewing formulas
  • Flash fill (Excel 2013 and later only)
  • Financial formulas i.e. SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV.

Who this course is for

Beginner level Excel users.

Requirements

There are no specific course requirements.

Show all

Course Content

1 Section 4 Lectures 1h 45m total length

0 Comments

Find Your Place in The World

Uplyrn-Logo

Learn from Industry Experts and Enhance Your Skills & Find jobs.

Company

Community

Lecturing

Mentoring 11

Terms Privacy Support
Terms Privacy Support