Microsoft^® Excel 2013 Basic & Intermediate

Basic

This course covers the very basics of the Excel spreadsheet. It is suitable for complete beginners without prior knowledge of Excel. At the end of this course you will have good understanding of the basic Excel features and you will be able to create a simple, presentable spreadsheet.

Intermediate

This course covers the intermediate level understanding of the spreadsheet. It is suitable for beginners wanting more knowledge on formulas and creating simple charts. At the end of this course you will have better understanding of the Excel features and you will be able to create formulas and charts.

At the end of the course, participants will be able to:

• Understand basic spreadsheet concepts
• Create basic formulas
• Format worksheets
• Use multiple worksheets
• Create bar, lines and pie charts
• Create drawings & picture objects
• Print worksheets and graphs

Knowledge of Microsoft Windows.

Module B1: Walking Through Excel 2013

• The New Excel 2013
• 2013 Landing Page
• Signing In Office 2013
• Cloud Computing
• Charts
• Quick Analysis
• Power View
• Flash Fill

Module B2: Managing Workbooks & Navigating with Excel

• The User Interface
  • Tabs & Ribbons
  • Customising The User Interface
• Using Shortcuts
  • Keyboard short cuts
  • Keyboard & mouse combinations
• Getting More Menu Options
• Creating A New Workbook
• Saving A Workbook
• Opening A Workbook
• What's Compatibility Mode?
  • Problems With Compatibility Mode
  • How to Convert a file in Compatibility Mode
• Working With Templates
• Handling Multiple Workbooks
• Selecting A Range
  • With Mouse
  • With Keyboard
  • With Short Cut Keys
  • When to use the SHIFT key
  • When to use the CTRL key

Module B3: Data Entry in Excel

• Entering and Editing Data
  • Text
  • Values
  • Formulas
• Copying & Pasting Data
  • Short cuts
  • The Various Types of Paste
• Filling Trends, Formulas & Text
  • Short cuts
  • Fill Tricks
  • Flash Fill

Module B4: Introduction to Functions and Formulas

• Basic Formulas
  • Operators
  • Using cell references
• Functions
  • AutoSum
  • Summing Tricks
  • AVERAGE / AVERAGEA
  • MAX / MIN
  • COUNT / COUNTA

Module B5: Modifying A Worksheet

• Handling Columns & Rows
  • Changing Column Width
  • Fitting Contents to a Column
  • Adding & Removing Columns
  • Hiding Columns
  • Adding & Removing Rows
  • Hiding Rows
  • Fitting Font Size to a Row
• Formatting Text
  • Changing the Font Properties
  • Using Cell Styles
• Formatting Numbers
  • Changing Number Formats
  • Customising Number formats
• Changing Alignment
  • Changing Text Alignment
  • Merging Cells
  • Controlling Text Appearance in a cell
• Borders and Shading
• Format Painter

Module B6: Printing Your Work

• Printing Your Worksheet
  • Choosing What To Print
  • How To Insert / Remove Page Breaks
  • Changing Page Orientation
  • Creating Custom Headers
  • Inserting Dates & Page Numbers
• How to Print Repeated Headings in Excel
• How to Print The Entire Workbook

Module i1: Worksheets and Workbooks

• Managing The View of Your Worksheet
  • Changing the Zoom settings
  • Freezing Rows & Columns for large worksheets
  • Splitting windows to views different parts of the worksheet
  • Customising and Saving Custom Views with hidden rows / columns together with print settings
• Handling Multiple Windows
  • Viewing Multiple Workbooks Simultaneously
  • Viewing Multiple Sheets Within the same Workbook Simultaneously
• Managing Worksheets
  • Hiding and Unhiding Worksheets
  • Changing Tab Colors
  • Renaming Worksheet
  • Adding / Removing Worksheets
  • Moving Worksheets
  • Copying Worksheets
  • Deleting Worksheets
• Manipulating WorkSheets Simulataneously

Module i2: Basic Functions & Formulas

• Understanding Cell References
  • When to use the double $ sign ($A$1)
  • When to use the single $ sign ($A1 or A$1)
• Inserting Date and Time
  • Shortcuts
  • TODAY Function
  • NOW Function
• Conditional Count & Sum Function
  • COUNTIF
  • SUMIF

Module i3: Analysing Data

• Quick Analysis
  • Conditional Formatting
  • Recommended Charts
  • Automatic Totals
  • Tables
  • Recommended Pivot Tables
  • Sparklines

Module i4: Performing Visual Analysis

• With Formatting
• Applying Cell Formatting
• Using Built In Pre-sets
• Using Data Bars and Icon Sets
• Using Custom Rules
• Managing Rules
• Prioritizing Rules

Module i5: Adding Illustrations

• Customizing your Workbook
• Adding Shapes
  • Formatting
  • Adding Effects
• Precision Text Placement with Text Boxes
  • Adding a Text Box
  • Formatting a Text Box
  • Creating Dynamic Text Box
• SmartArt
  • Inserting SmartArt
  • Adding Text
  • Formating With Colours & 3D Effects
• Inserting Image Files
  • Insert a Photo
  • Performing Colour Corrections
  • Adding Effects
  • Removing Background
  • Layering Images
  • Grouping objects

Module i6: Performing Visual Analysis

• With Charts
• Introduction To Charting
• Excel 2013's Recommended Chart
• Inserting A Chart
  • Column
  • Bar
  • Line
  • Pie
  • Dual Axis Charts
  • Combination Charts
• Adding Chart Elements
  • Title
  • Legend
  • Data Labels
  • Data Table
• Chart Styles (Formatting a Chart)
  • Change the Chart Type
  • Changing the Chart Location
  • Adding Dynamic Text Boxes
  • Adding An Image in the Plot Area
• Adding Chart Data
• Filtering Chart Data
• Charting Tips.

Appendix A

• Excel 2013 Short Cuts
• CTRL combination shortcut keys
• Function shortcut keys
• Other useful shortcut keys

• Microsoft® Excel for Beginners
• Microsoft® Excel for Intermediate/Advance User
• Microsoft® Excel 2007/2010 - Intermediate Level
• Microsoft® Excel 2007/2010 - Advanced Level
• Microsoft® Excel 2013 Advanced Level
• More other Information Technology related courses