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”
For millions, Excel is the ultimate tool to understand data and frame insights. It makes analysis easy as pie and intuitive for all. Those who are well acquainted with Excel might know about Insights – it is the newest artificial intelligence-backed capability that rolled out in preview to Office Insiders last month.
A quick note on Insights
Insights is a brand new service used to highlight patterns it identifies from your data, aiding you discover and inspect new insights, like outliers, trends and several other relevant visualizations and analyses. It will take special care to find out intriguing trends in your data and offer concise summaries with charts and PivotTables. As it’s powered by machine learning, the capability to churn out advanced analysis tends to increase as usage grows.
Continue reading “How Much Excel Excels in Deriving Rich ‘Insights’ from Your Data”
Getting all work done from inside a browser through an internet-enable computer is no mean feat. Just after Google cracked the idea, Microsoft and Apple soon followed the bandwagon and developed online office suites of their own.
So, do you think Google deserves the tag of top dog or should you give accolades to Microsoft for developing a feature-rich office suite?
Continue reading “Microsoft Excel or Google Sheets: Which is better for Business?”
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!”