top of page

Business Modeling- Important Excel tricks with formulas and referencing

Excel- 3D Formulas
Excel- Array Formulas

Array formulas can perform multiple calculations on one or more of the items in an array.

Excel- Circular Referencing

If a formula in a cell refers to itself, then that's called circular referencing. You will find out why this is important.

If you are working with multiple worksheets, then 3D formulas come in very handy. Using these you refer the same cell or range of cells on multiple worksheets. You will find out more in the following video.

Salesforce- Introduction

Introduction to Salesforce Platform

Salesforce builds licenced software which is used by businesses to perform a variety of sales and analytics operations- for example companies use it to track and manage sales leads, perform marketing campaigns, analyse marketing and sales data, as a communications tool etc. The term used to describe what Salesforce is used for is CRM (Customer Relationship Management)- i.e managing a company’s relationship with current/potential customers. Nowadays Salesforce is so widely used in companies that BAs are required to be familiar with this tool. BAs play an important role in helping the sales team draw valuable business insights from messy data. BAs might need to create Salesforce reports/presentations which can be presented to higher management at the company. So tighten your seatbelts for the Salesforce journey! Salesforce is vast topic- we have tried to cover some important concepts to get you upto speed with the basics so that you can put this on your resume. Work experience will train you more.

Data in Action

bottom of page