Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. This private 8-hour program (4 sessions x 2 hours) will provide an introduction to Excel with the basic tools and functions.

Learning Outcomes for Beginner:

• Provides basics of Excel functionalities
• Use the tools available in the software
• Prepare for advanced concepts

Course Topics

• Basic Functionalities
• Understanding Functions
• Charts & Graphs
• 2 Projects

FULL COURSE OUTLINE: BEGINNERS

• Basic Functionalities
  • Understanding the Workbooks.
  • Navigating in a File.
  • Entering text and numbers into a worksheet.
  • Typing simple formulas in a worksheet.
  • Filling a Series
  • Inserting and Deleting Worksheets.
  • Copying a Worksheet.
  • Renaming a worksheet.
  • Moving or copying a sheet to another workbook
  • Changing worksheet name, tab colour.
  • Grouping worksheets
  • Selecting rows, columns and ranges.
  • Freezing rows and columns.
  • Understanding formatting.
  • Applying general formatting.
  • Changing font and font size.
  • Understanding Borders.
  • Applying border to a range.
  • Wrapping and merging text.
  • Adding comments to cell.
  • Hiding, showing, editing and deleting comments.
  • Formatting data and Conditional Formatting.
  • Protecting a file.
  • Protecting a sheet.
  • Protecting a cell / range within a worksheet.
  • Protecting a worksheet except a cell / range.
  • Filtering and searching
  • Filtering with multiple criterions.
• Understanding Functions
  • Function to sum, average, power, ceiling, floor, max, min etc similar functions.
  • Working with dates.
  • Understanding relative referencing and absolute referencing.
  • Conditional Statements with “If” functions.
  • Nested functions.
  • Character related functions as left, right, mid etc related functions.
  • Lookup functions with vlookup, hlookup, xlookup
  • Working with Mathematical operators in formulas
  • Working with Subtotals
• Charts & Graphs
  • The Charting processes.
  • Creating sparklines.
  • Choosing the right chart.
  • Using a recommended chart.
  • Creating a new chart from the scratch.
  • Working with different types of charts and their applications.
  • Changing chart type.
  • Chart designing options
• Project 1
  • Project related to data analysis based on the subjects studied above
• Project 2
  • Project related to charting based on the subjects studied above