Skip to content

Ankashram

  • Sample Page
Ankashram
  • Think with data
    Data Analytics

    How To Design An HR Dashboard In Excel

    ByAdmin-Ankashram November 20, 2026November 17, 2026

      Most HR teams will have this problem. You’ve got some data, but it’s all in different files. Perhaps one file contains all your headcount, another contains all your leavers. Perhaps your vacancies are lurking in an email thread. When a manager is asking you a question about attrition, suddenly you spend the entire afternoon…

    Read More How To Design An HR Dashboard In ExcelContinue

  • Think with Data
    Data Analytics | Thinking With Data

    How to Remove Duplicates in Excel

    ByAdmin-Ankashram November 19, 2026November 17, 2026

    Duplicate entries are a very common occurrence in spreadsheets. They are there while combining files, importing data, or simply when you are just using your “Ctrl + C and Ctrl + V”. If you find duplicates remaining in the sheet, they will give you the wrong readings for totals, averages, and ultimately wrong conclusions. If…

    Read More How to Remove Duplicates in ExcelContinue

  • Think With Data
    Data Analytics

    How to Calculate Month-on-Month Growth in Excel

    ByAdmin-Ankashram November 18, 2026November 16, 2026

    Month-on-Month Growth shows how much something has grown or decreased from one month to the next. It is one of the simplest and most useful ways to track progress in sales, revenue, website traffic, sign ups, or any metric that changes over time. The formula for this is simple. Take the value for this month,…

    Read More How to Calculate Month-on-Month Growth in ExcelContinue

  • Think with data
    Data Analytics

    10 KPIs Every Business Owner Should Know

    ByAdmin-Ankashram November 17, 2026November 17, 2026

    Every business owner makes daily decisions based on their gut, but the best decisions will be informed by a few simple metrics. Whilst you don’t want a long list of metrics, having a few key performance indicators will help you to know if your business is performing well, and where you need to focus your…

    Read More 10 KPIs Every Business Owner Should KnowContinue

  • Data Analytics
    Data Analytics

    10 Data Analytics Projects For Beginners

    ByAdmin-Ankashram November 16, 2026November 16, 2026

    Data analytics can seem quite abstract when you are only learning through tutorials, however a great way to get a more hands-on experience is through doing some small projects with clear questions to answer. Below are some ideas for projects that can be completed in Excel, Google Sheets or free Power BI. These will help…

    Read More 10 Data Analytics Projects For BeginnersContinue

  • Think With Data
    Data Analytics

    AI versus Data Analysts – What’s the difference?

    ByAdmin-Ankashram November 13, 2026November 12, 2026

    With spreadsheets, answering questions in plain English and creating charts in seconds, many people are asking – are we really still going to need data analysts? Yes, however there are some interesting reasons why. By knowing the differences between an AI and a data analyst it will help you utilise both tools effectively. What AI…

    Read More AI versus Data Analysts – What’s the difference?Continue

  • think with data
    Data Analytics

    15 Excel Formula’s Business Analysts Need To Know

    ByAdmin-Ankashram November 12, 2026November 5, 2026

    Most business analysts will know that a large amount of their time is spent in spreadsheets. Often you will be given some data, tidying it up and trying to find any patterns to help answer any questions you have prior to meetings. Often knowing a handful of formulas can help you flow through the process…

    Read More 15 Excel Formula’s Business Analysts Need To KnowContinue

  • Think With Data
    Data Analytics

    What’s new in Data Analytics

    ByAdmin-Ankashram November 11, 2026November 5, 2026

    Every couple of years someone proclaims that data analytics has been revolutionised. Mostly it’s just rebranded, adding a chatbox to dashboards. However 2026 feels like it is a little different. Some of these changes have been implemented at the same time and mean that even if no one on your team is technically minded, the…

    Read More What’s new in Data AnalyticsContinue

  • Think with data
    Corporate training

    From 500 Rows to Smart Decisions: Think With Data

    ByAdmin-Ankashram November 10, 2026November 4, 2026

    anded a 500-row spreadsheet and wondered what to do with it? You’re not alone. Most professionals get that file and freeze. They know their domain inside out. They understand the business, the clients, the market. But the numbers sit there like a foreign language. Successful people don’t just rely on domain knowledge. They know how…

    Read More From 500 Rows to Smart Decisions: Think With DataContinue

  • think with data
    Corporate training

    20 Advanced Excel Questions Asked In Interviews

    ByAdmin-Ankashram November 9, 2026November 4, 2026

    You may not remember that they asked you to recite the arguments of INDEX, but you will remember that you were asked to explain what happens if you insert a column while the interviewer leant back. This is a real test. Interviewers want to see that you have had experience with a particular method and…

    Read More 20 Advanced Excel Questions Asked In InterviewsContinue

Page navigation

1 2 3 … 8 Next PageNext
  • Sample Page