Good News: Your favorite Microsoft Excel is about to get a lot smarter, and tech-savvy.
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”
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:
Do the following steps to turn the developer tab on:
- First right click anywhere on the ribbon, and then click on Customize the Ribbon.
Continue reading “How to Create a Macro With MS Excel”
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.
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”
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!”