online ms excel training courses Archives - DexLab Analytics | Big Data Hadoop SAS R Analytics Predictive Modeling & Excel VBA

Microsoft Excel is Revamping Itself and We Can’t be Happier

Good News: Your favorite Microsoft Excel is about to get a lot smarter, and tech-savvy.

 
Microsoft Excel is Revamping Itself and We Can’t be Happier
 

How? Thanks to machine learning and improved connection with the outside world.

 

Recently, Microsoft’s general manager for Office, Jared Spataro and company’s director of Office 365 ecosystem marketing, Rob Howard talked about how Excel is soon going to understand more about the inputs given and drag out additional information from the internet, as and when deemed necessary.

Continue reading “Microsoft Excel is Revamping Itself and We Can’t be Happier”

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.

 

Continue reading “How to Create a Macro With MS Excel”

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.

Continue reading “Learn To Use The AND Function in Excel WS”

We Have an Announcement: Uncover Your Dormant Excellence With Excel!

Join our free demo session on Advanced MS Excel:

Join our free demo session on Advanced MS Excel:


Team DexLab Analytics remains dedicated at offering data knowledge to keen learners. It is with great pleasure that we announce yet another free demo session to be held this Sunday, on the 27th of November, 2016. This time we will be discussing some concepts of Advanced MS Excel. It is a classroom demo session to be held at our Gurgaon branch.
Continue reading “We Have an Announcement: Uncover Your Dormant Excellence With Excel!”

Call us to know more