Exel4 

Microsoft Excel Courses

Description

Microsoft Excel Beginner, Intermediate & Advanced courses will provide participants

with a core understanding of how to effectively operate and use the Excel spreadsheet

software at an advanced level. Whether you need to learn the skills for work, fill the

gaps in your CV or simply fancy learning something new, these Excel courses are perfect for you.

Basic Level:

  • Introduction to Spreadsheets
  • Excel Workbook Windows
  • Basic Spreadsheet Skills
  • Understanding Workbook File Formats
  • Creating New Workbooks
  • Selecting Cells
  • Auto Sum and Auto Fill Function
  • Formatting Cells
  • Formatting Numbers
  • Placing Cell Alignment 
  • Cell, Rows and Columns
  • Understanding Worksheets
  • Editing, Copying and Moving Cells
  • Proofing Workbooks
  • Basic Options, Ribbons and Toolbar

Intermediate Level:

  • Introduction to Excel Spreadsheet Intermediate Level
  • Defining Names in Excel
  • Sorting Data
  • Using Excel Tables
  • Filtering Data in Excel
  • Understand Charts
  • Chart Design Options and Tools
  • Combo Charts
  • Functions within Excel
  • Understanding Date Function
  • Information Functions 

 Advanced Level:

  • Introduction to Excel Advanced
  • Using Text to Columns
  • The Paste Special Function
  • Data Validation
  • Subtotals and Grouping
  • Consolidating Data
  • Scenario Analysis
  • Data Tables in Scenario Analysis
  • What-if Analysis
  • Date & Time Functions
  • Text Functions in Excel
  • Using Lookup Functions
  • Vlookups
  • HLookups
  • If Functions ( Sum , Average , Count )
  • If's Functions ( Sum , Average , Count )
  • Linking Data
  • Understanding Pivot Tables
  • Using Pivot Charts
  • Protecting and Sharing Worksheets
  • Understanding to Macros
  • Custom Number Formats in Excel
  • Using Custom Lists
  • Working with Templates
  • Merging and Compare Excel Workbooks Final Assessment
 Exel3