e-magination InfoSolutions
Business Intelligence software companies have been working, since the 90s, to convince businesses that Microsoft Excel is flawed and wanting; that using an ‘old’ system that ‘comes with your computer’ is a huge faux pas if you want to be part of modern finance. This perception is so widely entrenched that using Excel, especially if […]
Microsoft Excel is a powerful analytical tool Too few people actually know this about Excel; they think ‘Excel’ and they picture 1980’s Excel and go no further, which means that they do not ever get to experience what it can do for their business. We host workshops monthly, ranging from training the fundamentals to the […]
Will you return to work a hero? Yes, because you will have mastered a super power. Our introductory course into the more advanced features of Excel and the Power BI suite will enable you to save countless hours every month. Through your new skills you will be able to automate the repeatable processes that you’ve […]
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Power Query’s MERGE feature: a VLOOKUP on steroids Is VLOOKUP one of your favourite functions in Excel? No doubt it is quite useful, but when your data is constantly changing, it is a drag (no pun intended) to keep updating your VLOOKUP calculations to take […]
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Many businesses purchase established business tools to help their operations and processes run smoothly, often at a high price tag. Only to find that very soon their information demands become more and more complex and quickly surpass what their current system can offer them. In […]
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text”] It is a common trend that Financial Managers or CFO’s tend to choose software or solutions based on what other businesses are using, often leaning towards the ‘off-the-shelf’ solutions that are expensive but rich with features and functionality. However, those features and functionalities, which are often the ‘cause’ of the […]
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] We are living in a world of solutions, where entrepreneurs and startups are looking to solve any problem in the hope of hitting a niche and making a stronghold for their business. However, many of them do not actually solve some of the everyday problems […]
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] In almost every industry we have seen the enthusiastic adoption of mobile technology, and in each industry mobile has helped businesses to operate faster and even more efficiently than before. Mobile technology has enabled the businessman; fitting in seamlessly with their busy lifestyles where they […]
The days of the old, grey and visually unappealing reports are thankfully over. CFOs finally have the tools to present stunning and creative dashboards with Microsoft Power BI that helps them not only create more engaging reports but also reveal pivotal insights from their data that much easier. CFOs can create personalised dashboards to […]
The more we look into it, the more we find that there are many businesses that have been coasting along working around their issues with Excel and large amounts of data rather than fully utilising it. Finance individuals and teams manually build intricate networks made up of workbook upon workbook that are so fragile that […]