Excel Foundations: Get Started with Confidence

MICROSOFT EXCEL COURSE: INTRODUCTION, 1-TO-1.

Excel Course Summary

In this intensive, one-day Excel course, 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. The course runs online, so you can join live from anywhere via your internet connection and Gotomeeting.com.

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:

• Changing fonts style, size, bold, italics underlining, colour.
• Border styles and cell shading.
• Cell Styles with pre-defined styles.
• Cell alignment, left, right, center, top, middle, bottom, indent, outdent, merging cells, text direction, text wrapping within cells.
• Number formatting, currencies, formatting of dates.
• Clearing content and formats of cells.
• Copy formats.

Tables

• Using Format as a table and working with tables and column filters.
• Adding and removing filters.
• Sorting.
• Find and replace values.
• Freeze panes on large spreadsheets.
• Insert and delete rows, columns and cells.

Finding trends: Conditional formatting.

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.