Excel Made Powerful: Formulas & Functions 1-Hour Workshop

EXCEL: 1 Hour Functions and Formulas.

Excel Course Summary

In this intensive, one-hour Excel workshops, you’ll gain confidence and mastery over the key features of Microsoft Excel.

Fully hands-on, you’ll create, explore, and modify real spreadsheets, building skills you can apply immediately.

We will concentrate of powerful calculations from scratch to professional.

Course Outcome

By the end of the session, you’ll be able to build professional spreadsheets, including personal budgets, business budgets, and financial models — all powered with practical Excel formulae.

EXCEL COURSE OUTLINE

Excel Basics: The Home Ribbon

Formatting Basics for number, date and text styles

Adding Formulae and functions :

• Formula basics.
• Popular functions: sum, average, count, minimum and maximum.
• Function wizard basics.
• Copying and cutting cells and formulae.
• Absolute and relative cell references, copying absolute cell references.
• Creating a spreadsheet using formulae and functions.

Saving: Save, Print, pdf and share your spreadsheets.

WHAT IS INCLUDED:

• Excel Course Certificate on completion (assessment based)
• Excel Course notes
• Practical Class Excel Course exercises, Excel sample files.
• To assist after the course, 1 free session for questions online.