Mid-Year Savings Flat 10% OFF, Use Code: MID10

Excel Novice - Exploring and Creating Formulas

person icon Bizfacility


Excel Novice - Exploring and Creating Formulas


updated on icon Updated on Jul, 2024

language icon Language - English

person icon Bizfacility

English [CC]

category icon Office Productivity,Microsoft Excel

Lectures -5

Resources -1

Duration -1.5 hours



30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description


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.


  • Building formulas

  • Reviewing formulas

  • Flash fill (Excel 2013 and later only)

  • Financial formulas i.e. SUM, SUBTOTAL, MAX, MIN, PMT, IPMT, NPV, IRR, FV and PV


  • No prior experience needed. Student will learn everything during the course.
Excel Novice - Exploring and Creating Formulas


Check out the detailed breakdown of what’s inside the course

Excel Novice - Exploring and Creating Formulas Course
5 Lectures
  • play icon Excel Novice - Exploring And Creating Formulas - Introduction 14:04 14:04
  • play icon Excel Novice - Exploring and Creating Formulas - Part 1.1 26:06 26:06
  • play icon Excel Novice - Exploring and Creating Formulas - Part 1.2 27:05 27:05
  • play icon Excel Novice - Exploring and Creating Formulas - Part 2.1 24:56 24:56
  • play icon Excel Novice - Exploring and Creating Formulas - Part 2.2 26:33 26:33

Instructor Details



Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us