Online ms excel certification course Archives - DexLab Analytics | Big Data Hadoop SAS R Analytics Predictive Modeling & Excel VBA

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

Posted on February 6, 2018May 23, 2020 by Dexlab

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”

How Much Excel Excels in Deriving Rich ‘Insights’ from Your Data

Posted on January 11, 2018May 23, 2020 by Dexlab

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”

Microsoft Excel or Google Sheets: Which is better for Business?

Posted on October 4, 2017October 4, 2017 by Dexlab

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?”

How to Create a Macro With MS Excel

Posted on March 3, 2017November 7, 2019 by Dexlab

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:

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”

Learn To Use The AND Function in Excel WS

Posted on February 15, 2017November 7, 2019 by Dexlab

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”

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

Posted on November 22, 2016November 22, 2016 by Dexlab

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 27^th 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!”

Tag: Online ms excel certification course

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

How Much Excel Excels in Deriving Rich ‘Insights’ from Your Data

A quick note on Insights

Microsoft Excel or Google Sheets: Which is better for Business?

How to Create a Macro With MS Excel

Developer tab:

Learn To Use The AND Function in Excel WS

What is the AND function?

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

Join our free demo session on Advanced MS Excel:

Call us to know more

Gurgaon

Kolkata

Quick Links

Our Courses

Important dates