Follow Us:

Advanced Microsoft Excel Training

Home Data Analysis Courses Advanced Microsoft Excel Training

About the Course

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. Microsoft Excel is the most commonly used analytics, reporting and strategy software. Becoming an expert data analyst requires you to have mastery of advanced Excel skills. This course is aimed at taking your excel skills to the next level. You will be able to apply complex functions within Excel to manage, manipulate, analyze and visualize data.

What You Will Learn

• The difference between relative, absolute and mixed reference?
• How to use relative, absolute and mixed references?
• How to create the multiplication table by using mixed reference?
• How to add the zeros in Microsoft excel?
• How to generate automatic serial numbers in Microsoft excel?
• How to use the convert function?
• How To Use WORKDAY AND WORKDAYINTL Functions?
• How To Use RAND Function?
• How To Use RANDBETWEEN Function?
• How To Use AUTOSUM Function?
• How To Use VLOOKUP Function?
• How To Use HLOOKUP Function?
• How To Manage Stocks & Stores By Using Hlookup Function?
• How To Use CHOOSE Function?
• How To Use TRANSPOSE Function?
• How To Use RANK Function?
• How To Use COUNTBLANK Function?
• How To Use INDEX AND MATCH Functions?
• How To Convert Numbers To Words?
• How To Create Data Entry Form In Excel?

Important Dates
Classroom Training Calendar 2024

START DATEEND DATEREGISTRATION
DEADLINE		COURSE COSTClick to Apply.
Jan 27, 2025Jan 31, 2025Jan 23, 2025USD 1000Register
Feb 17, 2025Feb 21, 2025Feb 13, 2025USD 1000Register
Mar 10, 2025Mar 14, 2025Mar 7, 2025USD 1000Register
Apr 21, 2025Apr 25, 2025Apr 17, 2025USD 1000Register
May 5, 2025May 9, 2025May 2, 2025USD 1000Register
June 16, 2025June 20, 2025June 13, 2025USD 1000Register
July 14, 2025July 18, 2025July 10, 2025USD 1000Register
Aug 18, 2025Aug 22, 2025Aug 14, 2025USD 1000Register
Sept 8, 2025Sept 12, 2025Sept 4, 2025USD 1000Register
Oct 13, 2025Oct 17, 2025Oct 10, 2025USD 1000Register
Nov 10, 2025Nov 14, 2025Nov 7, 2025USD 1000Register
Dec 8, 2025Dec 12, 2025Dec 4, 2025USD 1000Register

Online Training Calendar 2024

START DATEEND DATEREGISTRATION
DEADLINE		COURSE COST
(Online)		Click to Apply.
Jan 13, 2025Jan 17, 2025Jan 10, 2025USD 500Register
Feb 10, 2025Feb 10, 2025Feb 7, 2025USD 500Register
Mar 24, 2025Mar 28, 2025Mar 20, 2025USD 500Register
Apr 14, 2025Apr 18, 2025Apr 10, 2025USD 500Register
May 19, 2025May 23, 2025May 14, 2025USD 500Register
June 9, 2025June 13, 2025June 6, 2025USD 500Register
July 7, 2025July 11, 2025July 3, 2025USD 500Register
Aug 4, 2025Aug 8, 2025Aug 1, 2025USD 500Register
Sept 22, 2025Sept 26, 2025Sept 18, 2025USD 500Register
Oct 27, 2025Oct 31, 2025Oct 24, 2025USD 500Register
Nov 17, 2025Nov 21, 2025Nov 13, 2025USD 500Register
Dec 15, 2025Dec 19, 2025Dec 11, 2025USD 500Register
REGISTER HERE

Course Outline

  • Data Validation
  • Referencing in Excel
  • Working with Structured tables
  • Formulas and Functions
  • What If Analysis
  • Pivot Tables and Pivot Charts
  • Excel Macros
  • Charts and Visualizations
  • Working External Data

Target Participants

This course is aimed at professionals who have basic to intermediate Excel skills and want to advance those skills.

Software

Microsoft Excel

Certification

Upon successful completion of the course, all participants will be issued a certificate of completion at no extra cost.

Tailor-Made Course
We can also do this as a tailor-made course to meet organizational-specific needs. Contact us to find out more: training@wise-gis.com

Group Discount

WE OFFER 10% – 20% DISCOUNT TO GROUPS OF MORE THAN 5 PARTICIPANTS.

×

Hello,

Click one of our representative below to chat on WhatsApp.

× How can I help you?