MICROSOFT EXCEL COURSE: INTRODUCTION, 1-TO-1.
EXCEL COURSE SUMMARY
During this intensive one-day Excel course you will master the main features of Microsoft Office Excel. It is entirely ‘hands on’ and you will practice creating and modifying actual spreadsheets.
This course runs online via your internet connection and Gotomeeting.com
COURSE OUTCOME
Create a professional budget, personal budget or financial model with formulae.
EXCEL COURSE OUTLINE
Excel Beginners Course:
Excel Basics: The home ribbonFormatting:
- 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.
Protecting:
Protecting cells and sheets, with and without passwords.
Protecting files with passwords.
Formulae and functions:
Formula basics. Popular functions, sum avg, count, minimu and maximum.
Function wizard basics.
Copying and cut cells and formulae, absolute and releative dell references, copying absolute cell references.
Creating a spreadsheet with 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.
