SAMSON TRAINING

Where Experience Meets Excellence

Overview Suitable For:Key Course Features:Course Outcome:Testimonials

IT Courses

Excel Course for Intermediate

This intermediate Excel course is designed to build on basic Excel skills and enhance your proficiency in using spreadsheets for data analysis, reporting, and decision-making. Participants will learn advanced functions, data management techniques, and effective formatting to create professional-looking spreadsheets.

Suitable For:

Professionals and individuals who use Excel for data analysis, reporting, or project management and want to advance their skills to the next level.

Key Course Features:

"Introduction to Advanced Functions
• Review of basic functions (SUM, AVERAGE, COUNT, etc.)
• Using logical functions (IF, AND, OR)
• Advanced lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)

Data Analysis Techniques
• Sorting and filtering data
• Using conditional formatting for data visualization
• Grouping and outlining data

PivotTables and PivotCharts
• Creating PivotTables to analyze data
• Formatting and customizing PivotTables
• Creating PivotCharts for visual representation

Advanced Data Management
• Working with large datasets using Excel tables
• Data validation techniques
• Introduction to Power Query for data cleaning and transformation

Automation and Efficiency Tools
• Introduction to macros and VBA (Visual Basic for Applications)
• Creating and running simple macros
• Using Excel’s built-in tools for automation (Solver, Goal Seek)

Advanced Charting Techniques
• Creating advanced charts (combo charts, sparklines)
• Customizing charts and graphs
• Using chart templates for consistency

Course Outcome:

"Upon successful completion of the Excel Course for Intermediate participants will gain the skills and knowledge necessary to:
• Mastering advanced Excel functions such as VLOOKUP, IF statements, and PivotTables
• Analyzing data using filtering, sorting, and conditional formatting
• Enhancing data visualization with charts and graphs
• Managing large datasets with tables and data validation
• Streamlining workflow with macros and automation tools
• Improving spreadsheet efficiency and accuracy"

Key Info:

Duration: 1 Day

Structure: Online / On-Premises

Participants: Up to 12

ENQUIRE

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV.

Share it on social media and in your performance review.

Why people choose Samson

    
 
 
       Posted on Google  
   
   Marta Guinovart 
 
 
 
 Trustindex verifies that the original source of the review is Google. Very happ with the service and the flexibility of Samson Training. Melody was very accommodating with the organisation and Kean gave us very clear and detailed information on how to proceed with first aid.
  
 
      Posted on Google  
   
   Paul Tanner 
 
 
 
 Trustindex verifies that the original source of the review is Google. The training was excellently delivered and was well received and understood. The service was very flexible and the candidates enjoyed it
  
 
      Posted on Google  
   
   Liam Bannable 
 
 
 
 Trustindex verifies that the original source of the review is Google. Service was excellent form start to finish, arranging dates for training they were very flexible. Training itself was excellent. Trainer was very good. Would highly recommend Samsung Training.
  
 
      Posted on Google  
   
   Connor O'Flynn 
 
 
 
 Trustindex verifies that the original source of the review is Google. I have completed two courses with Samson Training, each with a different instructor. They have both been excellent courses with very good instructors, and the communication with the organisers are second to none. A special thanks to Melody who kept me up to date and informed on my upcoming training!
  
 
      Posted on Google  
   
   Caitriona Hurley 
 
 
 
 Trustindex verifies that the original source of the review is Google. Recently Booked an IOSH Health and Safety Course through Samson.  Samson did not directly provide the training but I found them easy and reliable to deal through they found a course provider to best suit my requirements. I really enjoyed the course and the course instructor through her own experience was able to provide real life examples of Health and Safety Issues. There was interaction with Q & A’s between different sections of the course which kept the course interesting.
  
 
      Posted on Google  
   
   Svetlana 
 
 
 
 Trustindex verifies that the original source of the review is Google. I had few  courses done  recently  with  SAMSON Training. I  can say  all the  instructors are very professionals pleasant. I really  enjoy the the  time . Highly recommend SAMSON .
  
 
      Posted on Google  
   
   james hanly 
 
 
 
 Trustindex verifies that the original source of the review is Google. We have used the services of Samson training on a number of occasions, and have always found them to be very proficient and professional at all times. I have no problem in highly recommending them for all aspects of training requirements.
  
 
      Posted on Google  
   
   Stephen Bryan 
 
 
 
 Trustindex verifies that the original source of the review is Google. Fantastic service, Trainer was highly killed in course delivery and knowledge content. All questions answered. No pressure as regards learning and would highly recommend Samson for training needs.

SAMSON TRAINING

Excel Course for Intermediate

Earn a career certificate

Why people choose Samson

Enquire About Courses