fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Day

July 26, 2017

Excel VBA Tutorial | What is VBA Macros in Microsoft Excel ?

Excel VBA Tutorial provides an integrated toolset that is appealing to a huge number of application areas. To make this tool, even more powerful, came to the rescue Excel VBA Macros, VBA Course or VBA Excel Functions Examples. VBA stands for Visual Basic for Applications, and it is a fully fledged programming language developed by...
Read More

Improve Office Productivity with Online Courses

One of the most favourite games in corporate drawing rooms is the Blame Game- “My employees are less productive!”, “She has got enough time to learn, I am too busy with this and that” and so on. Stop playing the blame game and accept the fact that your employees are what you have. If you...
Read More

Add APA Page number in MS Word with 3 Easy Steps

How to add APA Page numbers in MS Word? While writing documents or preparing a project report, it becomes mandatory to serialize all pages. MS Word has the option to give a serial number to the pages. The page numbers can be in the header or footer of the page with alignment options and style....
Read More

4 Super Productive Google Calendar Hacks

If you are using a Calendar app to simply check out dates, set holiday reminders or add events to it, you are probably using your Smartphone simply to make and receive calls. In other words, you are missing out on a huge potential that these Calendar apps have to offer. Here we offer you some...
Read More

Create Financial Models For Business

Create Financial Models in Excel I recently met a couple of professionals who are fresh graduates and working in the financial services sector. Since I was part of an investment team with a private equity fund where I have experience in creating investment memos and building the financial model from scratch. These guys asked me...
Read More

Microsoft Excel Go To Data Cleaning Trick

Data Cleaning Trick It is so easy to work on your own spreadsheet rather than working with Excel files made by someone else. Significant time is wasted in (1) cleaning or “sanitising” the data, and (2) establishing inter-sheet and intra-sheet formula connections. This process of Data Cleaning becomes super important if you are working in...
Read More

Working with Excel Sumif Formula

When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif. You know what MY answer is – Excel SUMIFS()! And I will tell you why. Excel Sumif...
Read More

Realign your data by sorting in Excel

Realigning 100s of columns without manually Cut/insert columns. Thereby, reducing the task time by minimum 90%. Thus sorting in excel is an important weapon in your hand. Realign your data by sorting in Excel Watch this video for a hassle-free column realignment and sorting in excel: I hope you have liked our tip on Realign your...
Read More
Comparison between Alteryx vs KNIME
Alteryx vs KNIME Comparison | Data Analytics tools
October 18, 2019
Financial Analyst Interview Questions and Answers
Financial Analyst Interview Questions & Answers [Q&A]
October 16, 2019
Alteryx Data Types
Alteryx Data Types | Alteryx Data Analytics
October 15, 2019
Alteryx Download and Installation Guide for Windows and Mac
Alteryx Download and Install for Windows and Mac | Alteryx Designer
October 14, 2019
Data Science Interview Questions with Answers
Data Science Interview Questions and Answers [Q&A]
September 26, 2019
Power bi vs SSRS
Power BI vs. SSRS | Difference between Power BI and SSRS
September 20, 2019
Tableau Interview Questions
Tableau Interview Questions and Answers [Q&A]
September 18, 2019
Power BI Data Sources
Power BI Data Sources and Power BI Services
September 16, 2019
What is Power BI_ _ Introduction to Microsoft Power BI
What is Power BI? | Introduction to Microsoft Power BI
September 13, 2019
POWER BI COMPONENTS
Power BI Components and Building Blocks of Power BI
September 13, 2019
Basics of Power BI DAX Function
Basics of Power BI DAX | List of Power BI DAX Function with Example
September 9, 2019
Power BI vs. Tableau
Power BI vs Tableau – Comparing Functionality, Pricing and Support
September 3, 2019
Business Analyst Interview Questions
Business Analyst Interview Questions & Answer (Q&A)
July 25, 2019
Data Analyst Interview Questions and Answers
Data Analyst Interview Questions and Answers [Q&A]
July 25, 2019
Power BI Dashboard vs. Power BI Reports
Power BI Dashboard vs. Power BI Report | BI Dashboard
July 24, 2019
Create Power BI Layouts step-by-step
Create Power BI Layouts – Power BI Tips and Tricks
July 24, 2019
Create Power BI Dashboard
5 Steps to Create your first Power BI Dashboard | Power BI Dashboard
July 24, 2019
Power BI Templates
Power BI Templates | Download Power BI Template
July 24, 2019
Complete Guide of Power BI Download and Power BI Installation Steps
July 24, 2019
Advanced Power BI Tips and Tricks
Complete Power BI Tips and Tricks – Power BI Dashboard Tutorials
July 24, 2019
HTML Snippets Powered By : XYZScripts.com