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 DATE | END DATE | REGISTRATION DEADLINE | COURSE COST (Classroom) | Click to Apply. |
|---|---|---|---|---|
| Mar 25, 2024 | Mar 29, 2024 | Mar 22, 2024 | USD 1000 | Register |
| Apr 29, 2024 | May 03, 2024 | Apr 25, 2024 | USD 1000 | Register |
| Jun 03, 2024 | Jun 07, 2024 | Mar 31, 2024 | USD 1000 | Register |
| Jul 08, 2024 | Jul 12, 2024 | Jul 04, 2024 | USD 1000 | Register |
Online Training Calendar 2024
| START DATE | END DATE | REGISTRATION DEADLINE | COURSE COST (Online) | Click to Apply. |
|---|---|---|---|---|
| Apr 29, 2024 | May 3, 2024 | Apr 27, 2024 | USD 400 | Register |
| Jun 03, 2024 | Jun 07, 2024 | Jun 1, 2024 | USD 400 | Register |
| Jul 08, 2024 | Jul 12, 2024 | Jul 6, 2024 | USD 400 | Register |
| Aug 12 , 2024 | Aug 16, 2024 | Aug 10, 2024 | USD 400 | Register |
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.
