News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
Brand New Connector! Connect Power BI & Google Sheets
Microsoft recently (16th November 2021) announced that they have beta released a Google sheets connector for Power BI and Power Query. This means that you can now connect to and import your business data from Google Sheets into Power BI…
Use AI To Become An Excel Pro Today!
AI is changing the way we interact with technology and the world around us. New tools are popping up every day that save hours of work – even for Excel! Excel Formula Bot, ChatGPT and Ajelix are here to…
Complete Guide To Percentages in Excel!
In this article, we will demonstrate how to calculate a percentage in Microsoft Excel, Word and PowerPoint. Additionally, we will go through some other important percentage related calculations. What is a Percentage? A percentage is defined, as a part or…
Linking Power BI & SQL Server [Ultimate Guide]
Power BI supports a variety of data sources such as Blank Queries, Flat Files, SQL Server Database, OData Feed, Azure Cloud Platform etc. The number of import features you have will depend on the version of Power BI that you…
A Detailed Comparison Of Power BI And SSRS
This article looks at the main differences between the Microsoft SSRS (SQL Server Reporting Services) and the Microsoft Power BI (Microsoft Power Business Intelligence). We compare the two Microsoft business intelligence tools against a number of criteria and then look…
Finding Outliers In Excel: A Detailed Guide
Microsoft Excel is an incredibly powerful data analysis tool that empowers users to store, analyse, and visualise data to derive valuable insights out of it. With so many basic and advanced level data analysis tools, Excel provides you with almost…
[Introduction] Power BI & DAX
By the end of this introduction to DAX article, you will have a good all-round understanding of Power BI’s Data Analysis Expressions (DAX) language. DAX is the language behind Power BI, meaning all the potential in Power BI comes from…
16 QUESTIONS You Will Get In A Power BI Interview!
Power BI is a data analysis and visualisation tool developed by Microsoft. Currently, it is one of the most sought-after skills for business intelligence analysts in particular and data scientists in general. This article covers some of the most common…
Learn To Make Bubble Charts [Power BI Visuals!]
Power BI is a powerful and versatile data visualisation tool, developed by Microsoft, that has revolutionised the way organisations make data-driven decisions. This intuitive and user-friendly platform enables users to connect to various data sources, transform raw data into insightful…
Mastering Excel’s LEN Function
The LEN function calculates the number of characters in a text string. For example, using “=LEN(‘Excel Magic’)” would yield the result “11”. This function is essential for data analysis and validation. LEN Function Details Available in: All versions of…
How To Win Friends & Influence People [8 Key Points]
In this series of blog posts, we’re going to look at some classic business books and discuss their main ideas. The big idea behind ‘How To Win Friends And Influence People ‘ is that how other people react to you…
Monitor Your Data With Freeze Panes In Excel!
Freeze Panes isolate a section of your worksheet, so that it is always in view. They are a great tool to help you keep important data in view while scrolling around. It’s an important way to keep your data…