Microsoft Excel Introduction

Microsoft Excel Introduction

• The Excel Environment
• Copying, Moving and Deleting Information
• Copying, Moving, Resizing and Deleting Rows and Columns
• Using the Format Painter
• Formatting in Excel (Border and Shading, Cell Formatting)
• Wrap Text feature
• Merge and Centre feature
• Text Alignment and Text Formatting
• Creating basic formulas using mathematical operators (+,-,/ and *)
• Using BODMAS rules to create formulas
• Creating Percentage formulas
• Absolute Cell Referencing (using Dollar ($ signs) in formulas)
• Managing Worksheets (Insert, Delete, Rename, Move, Copy worksheets and colouring worksheet tabs)
• Using and Managing the Autosum feature (Sum and Average feature)
• Using Excel Functions:
  • Sum Function and Average Function
  • Max Function and Min Function
  • Count Function

Microsoft Excel Introduction

• The Excel Environment
• Copying, Moving and Deleting Information
• Copying, Moving, Resizing and Deleting Rows and Columns
• Using the Format Painter
• Formatting in Excel (Border and Shading, Cell Formatting)
• Wrap Text feature
• Merge and Centre feature
• Text Alignment and Text Formatting
• Creating basic formulas using mathematical operators (+,-,/ and *)
• Using BODMAS rules to create formulas
• Creating Percentage formulas
• Absolute Cell Referencing (using Dollar ($ signs) in formulas)
• Managing Worksheets (Insert, Delete, Rename, Move, Copy worksheets and colouring worksheet tabs)
• Using and Managing the Autosum feature (Sum and Average feature)
• Using Excel Functions:
  • Sum Function and Average Function
  • Max Function and Min Function
  • Count Function

Microsoft Excel Introduction

There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session. For accredited Microsoft Office training options please view our ICDL courses or contact us for further options.

Microsoft Excel Introduction

There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session. For accredited Microsoft Office training options please view our ICDL courses or contact us for further options.

• 1-day training from NILC’s Microsoft certified trainers
• Practice files that will be used throughout the course
• PDF course manual with full step-by-step guide and images of each skill covered
• Recording from each training day (virtual-live courses only)
• Course completion certificate

• 1-day training from NILC’s Microsoft certified trainers
• Practice files that will be used throughout the course
• PDF course manual with full step-by-step guide and images of each skill covered
• Recording from each training day (virtual-live courses only)
• Course completion certificate