Category Archive: MS Excel Online training

Analyze Data Using These Easy but Effective MS Excel Tricks

Analyze-Data-Using-These-Easy-but-Effective-MS-Excel-Tricks


Everyone adores MS Excel. The powerful Excel software not only excels in doing basic computations but is also used for various formidable purposes, like financial modeling and business strategies. For novices, employing the skills of MS Excel can open new vistas in the world of data analytics. It is even being said – prior to R or Python, better grab the knowledge about Excel. Excel, with its wide array of functions, visualizations and skills empowers the users to quickly generate insights about data from the data, which would take a great toll otherwise.

Dexlab

Interesting Things to Do With Microsoft Excel

Microsoft Excel, whenever you hear this term, you visualise calculations, graphs, tables, formulas and what not – stuffs normally used to arrange and analyse data making pie charts, and countless related gimmicks.

Gaining proficiency in this specific software appears to be a common matter of concern for aspiring professionals from whatever field, they belongs to – and not just the ones who hail from a finance, accounts or IT background.

 
MS Excel Online training in Delhi
 

But do you know that MS Excel can be used for other interesting stuffs, apart from regular work-related things, like gaming and art? I guess not.

Leaf through a set of amazing projects completed with Microsoft Excel, which will surely knock you off your feet. So, are you ready?

Dexlab

How to Create a Macro With MS Excel

Did you know that with Excel you can now automate tasks by writing so called programs macros. In this tutorial, we will learn how do so, by learning to create a simple macro, which will executable after clicking a command button. To begin you must first turn on the developer tab:

 
How to Create a Macro With MS Excel
 

Developer tab:

Do the following steps to turn the developer tab on:

 

  1. First right click anywhere on the ribbon, and then click on Customize the Ribbon.

 

Dexlab

We are Proud to Host Corporate Training for WHO Reps!

We are happy to announce our month-long corporate training session for the representatives of WHO, who will be joining us to discuss data analytics all the way from Bhutan. The team of delegates who have come to seek training from our expert in-house trainers are for the Central of Disease Control, Ministry of Health Royal Government of Bhutan.

 
We are Proud to Host Corporate Training for WHO Reps!
 

The training is on the concepts of R Programming, Data Science using R and Statistical Modelling using R, and will go on from the 8th of February 2017 to the 8th of March 2017. We are hosting this training session at our headquarters in Gurgaon, Delhi NCR. It is a matter of great pride and honour for the team of seasoned industry expert trainers at DexLab Analytics to be hosting the representatives from WHO.

Dexlab

Learn To Use The AND Function in Excel WS

In this Excel tutorial, we at DexLab Analytics will dig a little deeper with our Excel knowledge and explain how to use the Excel AND function with proper examples, and syntax use.

 
Learn To Use The AND Function in Excel WS

What is the AND function?

The MS Excel AND function works to return TRUE if all the conditions are true. And it returns FALSE if any of the conditions are false. The AND function is an internal function in Excel that is categorized as a Logical Function. It can be utilised as a Work Sheet (WS) function in Excel. Moreover, as a worksheet function, the AND function may as well be included as a part of a formula in a normal excel cell of a worksheet.

Dexlab