Author: Lyndon Johnson

[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”] How To fill down values into blank cells Are you sourcing data from reports that have line items grouped with totals, but no column that you can use to group or filter these line items? With Power Query’s Fill Down feature, you can add a column […]

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 […]

[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”] 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 […]

On the 11th of January 2016, I started working at e-magination InfoSolutions. I was ready to make use of the opportunity, both eager and enthusiastic, but my knowledge of the product and ethos of the business was still vague and limited. I was given the title Sales Administrator and had all the ambition but no […]

[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”] e-magination is an advocate of the Microsoft stack, supplying clients with click-of-a-button monthly financial reports that save them countless hours using software the clients already know and use such as Excel, PowerPivot, Power BI, SQL Server, SharePoint, and other products. Microsoft products have always been […]