ExecuTrain of Dubai

ExecuTrain of Dubai We innovate. We create our own curriculum. Since 1997, ExecuTrain of Dubai has focused on practical

Since 1997, ExecuTrain of Dubai has focused on practical, hands-on training. Eg, apps like MS Excel should work for you, rather than you working for them.

Do you want to Dodge the Data Nightmare and Win Back your Time! Stop wasting hours of your time creating individual form...
28/03/2021

Do you want to Dodge the Data Nightmare and Win Back your Time! Stop wasting hours of your time creating individual formulas, when you can use Pivot Tables in minutes!

Pivot Tables is Swiss Army Knife of Excel. Using Pivot Tables, you can generate reports incredibly fast and Analyze your DATA. Pivot Tables help you Analyze your data the following four ways,

It’s a great start in this new year 2021. A great news for Excel Users. Microsoft Excel 2016/ 2019, Office 365 now boast...
09/01/2021

It’s a great start in this new year 2021. A great news for Excel Users. Microsoft Excel 2016/ 2019, Office 365 now boasts a powerful successor to the VLOOKUP function – XLOOKUP formula. Think of XLOOKUP as VLOOKUP 2.0 – A Sequel of VLOOKUP!
What is XLOOKUP?
XLOOKUP is the newest member of Excel lookup function family.

You may already know its siblings,

VLOOKUP, HLOOKUP, INDEX+MATCH, LOOKUP, etc.

XLOOKUP allows us to search for an item in a range (or table) and return matching result. In a way, it is similar to VLOOKUP, but offers so much more. When using XLOOKUP, you just provide 3 basic parameters (and 3 more optional parameters) & Excel does the rest.
• The value you are looking for
• The list where this value should be found
• The list from which you want the result
• [optional] value if not found

XLOOKUP Syntax
=XLOOKUP (what you want to look, lookup list, result list)

How is XLOOKUP better?
• XLOOKUP formula is less error prone.
• Looks up exact match by default:
• 4th parameter to support value not found scenario
• XLOOKUP offers optional parameters to search for special situations.
• It returns reference as output, not the value.
• It is so much cooler to type; you just type =XL.

A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to new career opportunities, promotions and much more.

ExecuTrain a synonym for “Excel Trainings” since the inception in 1997, has created a lasting legacy for Face-2-Face tra...
28/12/2020

ExecuTrain a synonym for “Excel Trainings” since the inception in 1997, has created a lasting legacy for Face-2-Face trainings.

The Pandemic left us with NO choice to leave the legacy of Face-2-Face trainings. The Learning did NOT STOP!

Our entire training business was transformed to an Online Learning model. We had apprehensions of how effective will be to deliver a Hard Skill training such as EXCEL?

I’m glad to share with you, some inspiring metrics of ONLINE Learning,

Do you have – Love: Hate relationship with Excel?Users always Ping-Pong between Love and Hate while working with Excel. ...
24/10/2020

Do you have – Love: Hate relationship with Excel?

Users always Ping-Pong between Love and Hate while working with Excel. How to overcome this Hate and start loving Excel?

The Primary reason of hate is, we love doing “Manual Labor work” which is repetitive, time consuming and error prone.

Excel is an Indispensable Business Tool ! No DoubtExcel is not going anywhere, and businesses will continue to use Excel...
27/09/2020

Excel is an Indispensable Business Tool ! No Doubt

Excel is not going anywhere, and businesses will continue to use Excel as a primary tool for diverse functions and applications ranging from IT projects to company picnics.

Excel is a powerful tool but cannot function alone. It takes a savvy computer user to take advantage of everything Excel has to offer to provide the best results for your company.

A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to new career opportunities, promotions and much more.

Report Making in Excel is an art. It is Robust and Powerful.
28/06/2020

Report Making in Excel is an art. It is Robust and Powerful.

Excel Skills Matrix - A Requirement by Organizations
18/06/2020

Excel Skills Matrix - A Requirement by Organizations

18/06/2020

What Excel Skills are required to Land a Great Job?

Microsoft Excel – No Doubt, is widely used by organizations to automate their daily processes such as maintaining data, data analysis and much more. Excel is used in departments from HR to Sales, Marketing, Operations, Data analytics departments and so on. The level of expertise may vary from basic to advance.

Do you have any idea of what skills the corporate's are looking for?

Do you have these skills?

If NOT, get in touch with us. You can reach us on +971 4 337 4888 or send mail to [email protected] . We train Practical, Solution Based Excel skills, as required by organizations.

15/06/2020

Create a PowerFul Impact on your Excel Data using Conditional Formatting !

Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and identify variances of cells' values with a quick glance.

At the same time, Conditional Formatting is often deemed as one of the most intricate and obscure Excel functions, especially by beginners. In fact, conditional formatting in Excel is very straightforward and easy to use.

Experience a comprehensive video on Conditional Formatting,

3 Reasons to have Impactful Animations in your PowerPoint!The world of PowerPoint presentations has grown into a robust ...
08/06/2020

3 Reasons to have Impactful Animations in your PowerPoint!

The world of PowerPoint presentations has grown into a robust field of expertise. The days of stationary boring text on the screen are long gone. You now have the ability to create vibrant, dynamic presentations that are sure to bring a new perspective to your audience no matter your choice of topic. What does this mean for you? If you do not have animation in your PowerPoint projects, you can expect people to ignore you.

Here are three of the main benefits of using animations in your PowerPoint presentations.

If you are keen to enhance your knowledge on superior PowerPoint presentation, below are the details of an online training,

07/06/2020

The daily grind of data warriors - Lookup Functions

If you have been using Excel for a while, you would have used VLOOKUP function. You will agree with me that =VLOOKUP () is the KING function: unquestioned number ONE.
VLOOKUP is the most-widely used function.
Data warriors as well as fresher’s rely upon VLOOKUP to fetch data from other sheets.
You can find a concept knowledge Nugget on VLOOKUP. If interested in practical uses of VLOOKUP, do write on [email protected]

Address

306, Office Court Building, Oud Metha Road, Bur
Dubai

Opening Hours

Monday 08:30 - 18:30
Tuesday 08:30 - 18:30
Wednesday 08:30 - 18:30
Thursday 08:30 - 18:30
Saturday 08:30 - 18:30
Sunday 08:30 - 18:30

Telephone

+97143374888

Website

Alerts

Be the first to know and let us send you an email when ExecuTrain of Dubai posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share