Objectives
This course will enable participants to gain a good general understanding of the main features of Excel, giving them the ability to produce standard spreadsheets, creating simple formula, formatting and printing spreadsheets
Target Audience
Anyone who is required to manage high volumes of email and communicate electronically. The content is applicable for people from all levels.
Learning Outcomes
This course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an intermediate level.
● Create advanced formulas
● Analyse Data with Logical and Lookup Functions
● Create and Modify Tables
● Sort and Filter Data
● Use Subtotal and Database Functions to Calculate Data
● Visualize Data with Charts
● Create Advanced Charts
● Create a PivotTable
● Filter Data by Using Slicers
● Analyse Data with Pivot Charts
● Insert and Modify Graphic Objects
● Layer and Group Graphic Objects
● Customize Workbooks
● Manage Themes
● Create and Use Templates
● Protect Files
● Preparing a Workbook for Multiple Audiences
Course Outline
Topic 1 : Introduction to Excel 2016 Interface
● Starting Excel
● The Excel Interface
● Changing Excel’s View
● Working with Existing Workbook
Topic 2 : Working with Microsoft Excel 2016
● Creating Workbooks
● Saving Workbooks
● Input Basic Data
● Using Data Types
● Cutting, Copying and Pasting Data
● Editing Workbook’s Properties
Topic 3 : Using Basic Formulas
● Building Basic Formulas
● Using Cell References
● Using Cell Ranges
Topic 4 : Formatting Cells and Ranges
● Inserting and Deleting Cells
● Manually Formatting Cell Contents
● Using Format Painter
● Paste Special Options
● Formatting Cells with Styles
● Hyperlink Data
Topic 5 : Formatting Worksheets
● Working with Rows and Columns
● Using Themes
● Modifying Worksheet’s Appearance
● Inserting Headers and Footers
Topic 6 : Adding Pictures and Shapes to a Worksheet
● Inserting Pictures
● Adding Shapes and WordArt
● Deleting, Copying and Moving Graphics
● Formatting Graphics
● Using SmartArt Graphics
Topic 7 : Printing Worksheets
● Preparing a Document for Printing
● Printing with Backstage
