browse important topics
CONCAT Function in Excel
The CONCAT function was introduced in Excel 2019 and is an upgrade to the CONCATENATE function that allows you to combine text, numbers or even both into a single output. It also allows you to…
CONCATENATE Function in Excel
The CONCATENATE function allows you to combine multiple values into a single value. It can take up to 30 values of text, numbers or cell references to merge and return as a single output text…
AutoFill and Flash Fill
AutoFill and Flash Fill are the most useful features in Excel which can save you a lot of time and reduce repetitive tasks such as creating a sequence of dates, weekdays, numbers etc. AutoFill in…
Worksheet Operations in Excel
Sheets usually called Worksheets are the tabs or pages in your Excel workbook. Sheets are not used just to enter data such as text, numbers, dates or formulas but also to organize the data in…
Excel Formulas Overview
In Excel, a formula is a tool that helps you calculate results by using the data you provide or the values stored in different cells. It’s a simple way to perform math and get answers…
Master Excel Ribbons
What are Ribbons in Excel? In Excel, Ribbons or menus are your starting point to access powerful features and functions. These are designed to make the tools in Excel more easier to use and accessible which helps you accomplish tasks…
Home Tab
The Home Tab is the starting point for you in Excel which has tools for formatting your text, aligning text in cells, applying styles to the cells, manage the rows and columns. It consists of groups such as: Clipboard Offers…
Insert Tab
The Insert Tab provides various elements to add to your worksheet such as charts, tables, pictures, shapes and much more. It helps you present your data in charts which makes it more informative and visually appealing. Tables Allows you to…
Services
Custom Designed Excel Templates
Get Excel templates crafted just for you! From budgeting to project tracking, I create user-friendly solutions that simplify your data management and boost efficiency.
Windows Software Development
Windows Software Development
I specialise in developing custom Windows applications tailored to meet your specific needs. Let’s turn your ideas into functional software that enhances your productivity.
Testimonials
Excel Resources Accordion
Unlock the Power of Excel
Explore our comprehensive Excel resources designed to help you master spreadsheets, streamline your workflows, and enhance your productivity.