Microsoft Excel

Get all the latest tips & trends...
Considerations for Dashboard Creation in Microsoft Excel

Considerations for Dashboard Creation in Microsoft Excel

If you are a financial analyst, then you know how important it is to sharpen your dashboard creation skills. Moreover, you may have read our previous articles covering Microsoft Power BI as a great tool for the creation of dashboards or seen our COVID19 Power BI Dashboard, so why dashboard creation in Excel? Microsoft Excel is one of the most widely known and used apps globally. Creating a user interface on Excel that summarises particular objectives or business processes makes work so much...

read more
Reasons why hosting on Microsoft Azure is better than Amazon Web Services

Reasons why hosting on Microsoft Azure is better than Amazon Web Services

Hosting on Microsoft Azure is a concept that was introduced by Microsoft with the release of Azure Web Sites and Azure Portal Preview.  Microsoft Azure provides a set of cloud services that help businesses meet their needs as well as mitigate challenges. It offers the freedom to build, manage, deploy applications on a large global network using the organization's favourite tools and frameworks. Early this year, Safaricom announced an agreement with Amazon Web Services (AWS) that would see the...

read more
How to reduce Customer Churn using Power BI

How to reduce Customer Churn using Power BI

Businesses rely on their ability to gain and retain customers in order to thrive and generate income; but what if a business is losing customers? This should sound an alarm because it will result to reduced profitability, the need for more marketing and re-acquisition costs among other unfortunate outcomes. You will lose customer if they lack confidence in quality of service, consistent disappointed in unmanaged expectations or violated core values. There is a high risk of losing customers if...

read more
Data Visualization: How to Get the Right Narrative from Your Data

Data Visualization: How to Get the Right Narrative from Your Data

Data in its raw form is difficult to understand. The fact that there are so many data points about customers of say a bank means that without excellent data visualization, it is difficult to comprehend the customer data. As Stephen Few said, “Numbers have an important story to tell. They rely on you to give them a clear and convincing voice”. The only way a target audience can get insight from raw data is to create a compelling story of the collected data. As defined in our article ‘Which Data...

read more
7 Essential Benefits of Moving Sage to the Cloud

7 Essential Benefits of Moving Sage to the Cloud

If you are an accountant or work in Human Resources or Finance, then you may be familiar with Sage. If you are not familiar with it, Sage is software that simplifies accounting tasks. It is so adaptable it can be used for both simple accounting and complex financial calculations. With Sage, you can easily: Prepare and print out invoices Calculate VAT returns Automatically calculate payroll Carry out bank reconciliations Stock management and valuation Monitor sales Make payments among others....

read more
11 Power BI Best User Practices that Will Make your Reports Stunning

11 Power BI Best User Practices that Will Make your Reports Stunning

Everyone wants to look good when making a presentation but when your Major was in Finance, your design skills are probably limited. This is where Power BI comes in to not only simplify large sets of data for you but also, help you to effortlessly present data in an aesthetically pleasing way. And just like any other platform, there are some Power BI best user practices that you can employ to make your reports unique and attractive. Power BI works by using charts and graphs to comprehensively...

read more
Which Data Analysis and Visualization Platform should you go for: Tableau or Microsoft Power BI?

Which Data Analysis and Visualization Platform should you go for: Tableau or Microsoft Power BI?

Technology is not static and tech companies work to outdo each other by creating different solutions for their target markets and this is the case with companies that work to create data analysis and visualization platforms. Due to this, it might get confusing when trying to choose between platforms like Microsoft Excel, Microsoft Power BI and Tableau. If you have no clue what data analysis and visualization is, well, it is the organization of unstructured data in a way that business can gain...

read more
Why You Should Consider Shifting Reporting From Excel to Microsoft Power BI

Why You Should Consider Shifting Reporting From Excel to Microsoft Power BI

Microsoft Excel has been the go to application for most business that need instant  reports but around 2015, Microsoft released Power BI -a more superior data modelling and visualization tool- that can be accessed under Office 365 applications. Power BI is a business intelligence service that offers robust analytics and reporting features. It’s an intuitive tool with great visuals making it an easy to use application especially for beginners. It makes complex data easy to interpret by applying...

read more
10 Key Advanced Microsoft Excel Functions and Formulas

10 Key Advanced Microsoft Excel Functions and Formulas

Any business in this age needs to use an array of software and tools to run efficiently. These tools help to save time and resources in the daily operations by giving on demand results from data analysis. Currently, businesses can choose from a wide range of tools, but the most popular and time proven tool is Microsoft Excel. It is a known fact that Microsoft Excel is helping small, medium, and large-scale businesses to store, manage and make sense of data through analysis. Excel has a unique...

read more
How to set up VPN for Virtual Machines in Microsoft Azure

How to set up VPN for Virtual Machines in Microsoft Azure

In our tutorial Migrating Sage Database from from local hosting to Azure Hosted Instance, we promised to share how to create a secure link using a Virtual Private Network (VPN). Below are step by step instructions on how to set up a VPN for Virtual Machines in Microsoft Azure. If you would like to know more about what Microsoft Azure is and how you can use it to improve operations for your organization read more here: How Microsoft Azure has Transformed Organizations - A case of Sunesis...

read more

Office Applications

Programming & Database

Get up to 20% off with our

Bundle Offers

Pin It on Pinterest