Improve your training in five minutes by taking our training optimization quiz

We can improve your training in less than 5 minutes. TAKE OUR QUIZ

Course

Excel Basics: Formulas and Functions

This course will introduce formulas and functions, powerful tools in Excel that allow you to perform calculations, manipulate text, automate common tasks, and more.

This is an introductory course, intended for beginning Excel users. We will show you some simple formulas and functions, with examples of how you can use them, and we will preview some of the more powerful capabilities of functions. We will also take you on a tour of the hundreds of functions available in Excel.

Download a SCORM file, ready to upload to your LMS, or the editable Articulate Storyline file, allowing you to modify the course.

To view this course and other courses in our catalog, sign up for our free trial.

Desktop Monitor showing financial information in Excel Sheet.

Key Takeaways

✓   Understand how to enter a formula

✓   Understand the difference between relative and absolute cell references

✓   Understand how to enter a function

✓   Understand how arguments are used in functions, included nested arguments

✓   Be familiar with the various categories of functions in Excel

Key Chapters

  • What is a Formula?
  • Relative Cell References
  • Absolute Cell References
  • Introducing Functions
  • Entering Functions
  • Arguments
  • Excel Function Categories

Who Should Take This Course?

Beginning Excel users focused on Formulas and Functions intended for workers and managers. It is suitable for a non-technical audience.

Duration

30 minutes

Style

Self-paced e-Learning

Category

Technology

Accessibility Standard

Section 508

Skills

Excel – Formulas
Excel – Functions

Course Screenshots

Course Pricing

Get instant access to your files.

Courses are free for existing Knowledge Anywhere customers-contact us.*

$75

SCORM

Download a SCORM file, ready for upload to your LMS.

$250

Articulate Storyline

Download an editable Articulate Storyline file, allowing you to modify the course.

*Restriction may apply.

More Courses