microsoft excel certification online 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”

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

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.


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


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

Interesting Things to Do With Microsoft Excel

MS Excel Online training in Delhi

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.

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?

Digital Art

Digital Art with MS Excel? Are you kidding me? No, I’m not. A 73-year old Japanese Tatsuo Horiuchi will change your entire perception. He practised digital art using MS Excel spreadsheet, why, because he found other graphics software to be quite expensive. He used the ‘autoshape’ feature of Excel to create stunning works of art. Fascinating, right?



Did you finish solving the Sudoku puzzle in the newspaper? You want more? Fortunately, Microsoft is here to help you out! Download an Excel file and use it to create a never-ending stream of Sudoku puzzles and go on teasing your brain cells by solving the puzzle, till you get worn out.


Re-inventing legendary games

Work hard, party harder! Excel totally buys the thought. By using Microsoft Excel, you can recreate the stellar games, like Monopoly, Pacman, Tetris and lot more. Of late, latest games like Candy Crush and 2048 have their own versions in Excel format, and that definitely calls for celebration!


Stop-motion animation

Animations and music video are two sides of the same coin. For years, it has been a popular medium. While A-ha’s “Take on Me” revolutionised the digital world 30 years back, Joe Penna, also known as Mystery Guitar Man on YouTube has taken the world by storm today, thanks to its stop-motion animation music video created using Excel spreadsheets.

He filmed himself performing the song “Cuban Pete”, broke down the video into 730 separate frames and then used each frame to develop a spreadsheet mosaic. The rest simply fell into place!

Advanced excel training

A working flight simulator

Scroll your thoughts to 1997, flight simulators came in from there. With the simulators, you can manoeuvre your environment as your mouse converts into the airplane control – move it back and forth or sideways and keep rolling.

No doubt, it became a favourite pastime for thousands of employees across the globe, including yours truly.

Excel dashboards training

Transport columns into rows

Mistakenly did you put data in columns, instead of rows or vice versa? Relax Microsoft has got you covered. There is a shortcut to fix the mistake. Just copy the row or column you need to interchange, right click on the cell you want to put it on and select Paste Special. A popup window named Transpose will appear. Check the box and click OK. That’s all you have to do. Easy, isn’t it?

Seeking Microsoft excel certification training online, DexLab Analytics is here! Check out our comprehensive MS Excel Online training in Delhi courses and hone your excel skills.


Interested in a career in Data Analyst?

To learn more about Machine Learning Using Python and Spark – click here.
To learn more about Data Analyst with Advanced excel course – click here.
To learn more about Data Analyst with SAS Course – click here.
To learn more about Data Analyst with R Course – click here.
To learn more about Big Data Course – click here.

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

Let us Revise Regression Analysis

Let us revise regression analysis

By now every business owner and manager is aware of the latest megatrend related to data analysis and knows that they should make data-driven decisions only at work. Gut feeling and winging it are now practices outdates as they have proved time and again that they fail. But the problem still remains in the know-how of parsing through all the layers of data streaming into your systems. Do you have the requisite know how?

Luckily for you, you may not be the one to crunch all the numbers (phew!). You pay other robotic data analytics personnel to do that for you. But you must correctly understand the analysis report that is handed over to you for interpretation after your colleagues are done with all the heavy lifting. A common practice is the realm of data analysis is regression analysis. Continue reading “Let us Revise Regression Analysis”

Call us to know more