Excel For Beginners (Level 1) Course Outline With Examples

Microsoft Office Excel Level 1

*GETTING STARTED WITH EXCEL

*EXCEL SELECTION TECHNIQUES

  • Why Are Selection Techniques Important?
  • Selecting A Cell
  • Selecting A Range Of Connecting Cells
  • Selecting A Range Of Non-Connecting Cells
  • Selecting The Entire Worksheet
  • Selecting A Row
  • Selecting A Range Of Connecting Rows
  • Selecting A Range Of Non-Connected Rows
  • Selecting A Column
  • Selecting A Range Of Connecting Columns
  • Selecting A Range Of Non-Connecting Columns
  • Recommended Techniques When Creating Or Editing Lists


Find, Select, Replace and Go To Special in Excel

*MANIPULATING ROWS AND COLUMNS WITHIN EXCEL

*MANIPULATING CELLS AND CELL CONTENT WITHIN EXCEL

  • Copying A Cell Or Range Contents Within A Workbook
  • Deleting Cell Contents
  • Moving The Contents Of A Cell Or Range Within A Workbook
  • Editing Cell Content
  • Undo And Redo
  • Copying Data Between Worksheets (Within The Same Workbook)
  • Moving Data Between Worksheets (Within The Same Workbook)
  • Moving Data Worksheets (Between Different Workbooks)
  • Copying Data Between Worksheets (In Different Workbooks)
  • Autofill
  • Copying A Data Range Using Autofill
  • Sorting A Cell Range
  • Searching And Replacing Data

*EXCEL WORKSHEETS

  • Switching Between Worksheets
  • Renaming A Worksheet
  • Recommended Techniques With Naming Worksheets
  • Inserting A New Worksheet
  • Deleting A Worksheet
  • Copying A Worksheet Within A Workbook
  • Moving A Worksheet Within A Workbook
  • Copying Or Moving Worksheets Between Workbooks

*FONT FORMATTING WITHIN EXCEL

  • Font Formatting Options
  • Font Type
  • Font Size
  • Bold, Italic, Underline Formatting
  • Cell Border Formatting
  • Formatting The Background Colour
  • Formatting The Font Colour

*ALIGNMENT FORMATTING WITHIN EXCEL

*NUMBER FORMATTING WITHIN EXCEL

*EXCEL FUNCTIONS

*EXCEL CHARTS

Miscellaneous

*CHART TITLE OR LABELS

  • Changing The Column, Bar, Line Or Pie Slice Colours In A Chart
  • Modifying The Legend Fill Colour
  • Changing The Chart Type
  • Modifying Charts Using The Design Tab
  • Modifying The Chart Title
  • Modifying The Chart Axis
  • Modifying The Chart Legend
  • Modifying Chart Data Labels
  • Displaying Chart Data Tables
  • Modifying Chart Gridlines
  • Copying And Moving Charts Within A Worksheet
  • Copying And Moving Charts Between Worksheets
  • Copying And Moving Charts Between Workbooks

*CUSTOMISING EXCEL

Modifying Basic Excel Options