bookmark_border
Category
What Will I Learn?
In this course you will be taught how to not only develop spreadsheets using formulas and formatting but will be shown how to create charts ensuring you leave with a comprehensive knowledge of how to make Excel work for you.
Delegates with Basic Excel knowledge would benefi t from attending the Discovering Excel Course.
Learning Objectives
- What is Microsoft Excel
- Working with Workbooks and Worksheets
- File Formats and Columns and Rows
- Working with Formulae
- Managing and Using Multiple Worksheets
- Creating Multiple Views
- Formatting and Editing Worksheets
- Printing and Page Setup
- Using Functions
- Charts
Course Overview - Day 1
1. Fundamentals lecture
- What is Microsoft Excel
- Starting Microsoft Excel
- Closing Microsoft Excel
- Components of the Microsoft Excel Screen
- The Ribbon
- Minimizing the Ribbon
- The Office Button
- The Quick Access Toolbar
- Default Options
- Font and Font Size
- Microsoft Excel Help
- Deactivate Online Help
- Using Help
- Using Shortcut Menus
2. Workbooks & Worksheets lecture
- What Does a Worksheet Consist of?
- Zoom Level
- Creating a New Workbook
- Using a Template
- Blank Template
- Closing a Workbook
- Using an Existing Workbook
- Opening a Workbook
- Opening a Recently used Workbook
- Switching between Open Workbooks
- Selection Techniques
- Selecting a Cell
- Selecting a Range of Cells
- Selecting Cells using the Mouse
- Selecting Cells using the Keyboard
- Selecting Non-Adjacent Cells
- Selecting Entire Worksheet
- Scrolling in Microsoft Excel
- Navigating in Microsoft Excel
- Changing Worksheets
- Entering Data
- Identifying Types of Data
- Typing Data into Microsoft Excel
- Auto-fit Column Width
- Auto-fill Data
- Saving the Workbook
- Using the Save Option
- Using Save As Option
- Spell Check
3. Working with Formulas & Functions lecture
- Formula Construction
- Use Parentheses
- Creating Formulas
- Copying Formulas
- Using Functions
- Sum Function
- AutoSum Button
4. Managing your Workbooks lecture
- Modifying the Worksheet Structure
- Inserting a Row
- Inserting a Column
- Deleting a Row
- Deleting a Column
- Moving and Copying Data
- Move Data
- Copy Data
- Copying Data with Auto-fill
- Freezing and Hiding Columns and Rows
- Freezing Panes
- Unfreeze Panes
- Hiding & Unhiding Rows and Columns
5. Formatting & Editing Worksheets lecture
- Changing the Appearance of Data
- Adjust Row Height
- Adjust Column Width
- Rename Worksheets
- Formatting Data
- Format Font
- Accounting Formatting
- Decimal Place
- Aligning
- Merge and Centre
- Wrap Text
- Text Orientation
- Borders and Shading
- Fill Colour
- Copying Formatting
- Format as Table
- Editing Data on the Worksheet
- Editing a Cell
- Clear All
- Undo and Redo
6. Pages Setup & Printing lecture
- Working with Pages
- Pages on the Worksheet
- Page Break Preview
- Move a Page Break Preview
- Exit Page Break Preview
- Print Preview and Printing Options
- Print Preview
- Printing
- Page Setup
- Changing Margins
- Portrait to Landscape
Course Overview - Day 2
1. New Feature lecture
- Create a Ribbon
2. Managing Worksheet lecture
- Work with Multiple Worksheet
- Quickly Navigate
- Insert a Worksheet
- Delete a Worksheet
- Rename a Worksheet
- Copy a Worksheet
- Move a Worksheet
- Group Worksheets
- Select Worksheets in a Range
- Select Non-Adjacent Worksheets
- Select all Worksheets
- Paste Special
- Paste Link
- Transpose
- Conditional Formatting
- Applying Conditional Formatting
- Applying Conditional Formatting across Rows
- Copy Conditional Formatting
- Change Conditional Formatting
- Remove Conditional Formatting
- Highlight Duplicates
- Worksheet Protection
- Unlock Cells
- Protect Worksheet
- Unprotect Worksheets
- Text to Columns
- Named Ranges
- Name a Cell
- Use Column Headings to Name Columns
- Insert Named Ranges in Formulae
- Edit a Name Range
- Navigate Named Ranges
- Hyperlinks
3. Formulas & Functions lecture
- Nesting Functions
- Insert a Function within a Function
- Lookup Functions
- VLOOKUP Function
- Text Functions
- TRIM Function
- LEFT Function
- FIND Function
- MID Function
- CONCATENATE Function
- Logical Functions
- IF Function
- OR Function
- AND Function
- IFERROR Function
- Statistical Functions
- COUNTIF Function
- Mathematical Functions
- SUMIF Function
Classroom delegates will receive a manual and 3 month’s email support, and online delegates will have 3 months access to the academy with e-mail support and an option to print the manual off the academy. On completion of each course you will need to complete the assessment and on achieving a pass mark of 70% or above, you will receive a printable certifi cate.