PURPOSE

Unlock the full potential of Microsoft Excel with our Intermediate Excel Course! This comprehensive training program is designed to take your spreadsheet skills to the next level and equip you with valuable tools and techniques to excel in your personal and professional life. An Excel Spreadsheet is a powerful tool for data organization and analysis, offering a structured and efficient way to manage information. With its user-friendly interface and versatile features, Excel enables users to create dynamic and visually appealing spreadsheets.

COURSE CONTENT

Unit 1: Calculating data with advanced formulas

  • Applying cell and range names
  • Naming ranges automatically
  • Using specialised functions
  • Fixed referencing

 

Unit 2: Organising worksheets and table data

  • Sorting and filtering data
  • Creating and modifying tables

 

Unit 3: Presenting data using charts

  • Creating a chart
  • Modifying charts
  • Adding data to charts

 

Unit 4: Simplistic 

  • MIN, MAX and Average
  • COUNT, COUNTA and COUNTBLANK
  • Rounding

 

Unit 5: Inserting graphic objects

  • Inserting graphic objects
  • Drawing and modifying shapes
  • Illustrating workflow using SmartArt graphics
  • Adding a background

 

Unit 6: Custom formatting

  • Custom format numbers, date, etc.

 

Unit 7: Other functions

  • Watch window options
  • Text to columns
  • Subtotal function
  • Protection
  • Setting up calculations
  • Types of errors
  • Breaking links
  • Data validation
  • Hyperlink 

 

Unit 8: Dates

  • Working with dates and time
  • Dynamic dates and TODAY and NOW functions

 

Unit 9: Formatting functions

  • Conditional formatting
  • Format painter
  • Paste special

 

Unit 10: Reporting formula

  • Pivot tables
  • Counting using pivot tables and drilling down into detail
  • Updating a pivot table with new data and adding multiple values
  • Using calculated fields in pivot tables
  • Removing or hiding subtotals, grand totals and filling blanks

 

Unit 11: Google sheet

  • Google sheets

DELIVERY

Duration: 1 Day

Delivery: Classroom/Online

ACCREDITATION

5 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of all courses.

1 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of this course.

HOW TO USE EXCEL SPREADSHEET

Here is a step-by-step guide on how to use Excel

  • Opening Excel 
  • Creating a New Workbook
  • Entering Data
  • Formatiting Cells 
  • Working with Rows and Columns 
  • Formulas and Functions 
  • Charts and Graphs 
  • Sorting and Filtering 
  • Data Validation 
  • Conditional Formatting
  •  PivotTables 
  • Protecting Worksheets 
  • Saving and Printing 
HOW TO USE EXCEL SPREADSHEET

OUR MOST POPULAR CATEGORIES

SHORT COURSES
Scroll to Top