| COURSE | DESCRIPTION |
| MICROSOFT EXCEL | |
| Excel Intro | The Excel screen, selecting, moving, copying, auto fill, resizing columns / rows, inserting / deleting sheets, Formatting cells, Formatting numbers, formatting dates, useful Excel Keyboard shortcuts, working with sheets |
| Intro to Excel Functions | Maths basics, Using dollar signs in functions (absolute and relative references), sum, average, maximum, minimum, percentages, Dates, getting help on formulas, calculating dates |
| Excel Charts | Creating a simple chart, formatting charts, creating a combination chart, pie charts and column charts, Error bars and trends |
| Excel Intro to Macros |
An introduction to creating macros in Excel.
Macros record your keystrokes and actions so that you can play
them back at a later time. This saves a lot of time when
automated. Macros are the beginning of VBA programming,
because Excel records the action by writing a line of VBA code
for each action you perform. VBA stands for Visual Basic
for Applications. Record a macro, Relative vs absolute recording, macro storage, creating a toolbar and assigning a button to your macro, Exploring VBA code |
| Excel Pivot Tables | A pivot table is a data summary tool that can automatically sort, count, and total the data stored in a spreadsheet, crossing the values against each other to create a cross tab type of result |
| Excel Financial Functions | FV, IRR, NPV, NPER, PMT, PV, RATE |
| Excel Large Spreadsheets | Freeze Headings when viewing and when printing, automatic hiding and showing of columns (outlining), Sorting and filtering, dsum, dcount, Automatic Subtotalling, Custom Views and Report Manager |
| Excel Useful Functions | If, Vlookup & Hlookup, using and / or, Nesting Functions, Sumif & Countif, Add / subtract dates, Now & today, Datevalue & Timevalue, Day & Month & Year, Payment, Text, Left & Right, Clean and Trim, Mid, Len, Search & Find, Lower & Proper & Upper |
| Excel What If | Goal Seek, Solver, Scenario Manager, Data Tables |
| Creating a Purchase Invoice | Drop down lists, lookups, controlling what can be entered, Preventing cell changes, IsEmpty() |
| Excel Text Functions | find, search, text, mid, left, right, trim, proper, upper, lower, Is Functions |
| MICROSOFT WORD | |
| Mail Merge | Creating a mail out to multiple addresses using Word. Linking to your Outlook Contacts, or an Excel address list. |
| Tables | Creating a table, formatting it, drawing a table, merging cells, inserting / deleting cells, nested tables |
| Creating Manuals | Working with a large document, standardising heading formats, creating automatic Table of Contents, using the Outline view, creating an automatic Index, Subdocuments |
Home | Contact | Terms and Conditions