Certificate in Microsoft Excel Training Course

Description

Uses for and working with Microsoft Excel spreadsheets

• The Excel screen including toolbars, formula bar, name box
• Column and row headings
• Workbooks and Sheet tabs
• Uses for Excel (Worksheet, Database & Charting)
• Getting around a spreadsheet using keyboard & mouse
• moving between workbooks
• Selecting (or highlighting) cells, columns and rows & entire spreadsheets
• Entering information into workbooks
• Resizing columns.

Microsoft Excel Structure: Columns, Rows and Cells

• Selecting information: Understanding the mouse cursors used within Excel, how to select cells, columns and rows and multiple ranges of information, how to select cells using the keyboard.
• Copy and Paste: Drag and drop, cut, copy and paste in a worksheet and from one worksheet to another and even between different software programs.
• Editing cells: Typing and entering information, editing existing information and entering the changes, using the status bar information, escaping out of cells.
• Changing column width and row height for single and multiple columns as well as making all the columns the same width and using AutoFit.
• Database: Creating a simple database, understanding simple database structure (ideal knowledge for mail merge with Microsoft Word), inserting and deleting columns, using Undo and Redo options.
• Autofill: Automatically fill numbers, dates, number patterns, days, months and years and much more. The fast way to insert sequential numbers and words.
• Understanding date formatting (this forms the basis for future calculations based on date format).

Formulas, Functions and Formatting

• Formulas: Entering formulas using the keyboard, arrow keys and the mouse,
• Relative cells references, common formula errors, how to combine two formulas in one.
• AutoCalculate: Get quick additions and basic functions quickly without having to enter formulas.
• Functions: Introductions to functions and function syntax, Autosum, Autosum for several and selected ranges
• Common functions like Maximum, Minimum, Average and more…
• Functions: Sum function in more detail, using the formula bar and editing functions, keyboard shortcuts and Autofill to save time, copying (or filling) functions using relative cell references.
• Formatting: Lines, colours, shading, and formatting of text and numbers.
• Currency formatting, date and text formatting,
• Merging cells and centering,
• Alignment formatting and text control within single and merged cells,
• Fill colour, font colour and Borders.
• Advanced formatting that allow you to quickly make your spreadsheet look professional,
• Repeat common actions, and features that speed up repetitive commands and formatting,
• Format entire spreadsheets and apply multiple formatting in just a couple clicks.