Excel power

29/02/2024

Vlookup and Match Combination are the most dynamic combination which helps us to fetch the data very easily as well as we can use this formulla on multiple criteria...

05/11/2021

26/05/2021

Excel 2021: A Step-By-Step Approach to Learning the Fundamentals of Excel Grasping Advanced Features like Business Modelling, Sampling Design and Numerous Data Analysis Techniques
Are you new to excel and have no idea when it comes to Excel?

Are you an Excel specialist looking for ways to further your skills?

Are you a business person or an individual who seeks to improve Excel from the beginning to the end?

Are you aiming for some “step-by-step” overview on how to use Excel’s essential functions & formulas?

Do you wish to learn how to use Excel’s tips, hacks, & shortcuts to increase your productivity?

This book is really for you whether you fall into either of those categories.
Excel is a versatile spreadsheet program that has become increasingly relevant in today’s world. This book is an excellent resource for learning about the application. It will walk one through the fundamentals of Excel. The guide is simple to follow and includes straightforward graphical diagrams. From essential Excel functions like creating & editing worksheets to updating and sharing worksheets then editing macros using Visual Basic, this book will take you through it all.
It covers a wide range of Excel applications & functions covering:

Worksheet formatting

Excel shortcuts

Formula setup

Excel graphs & charts

Cell referencing

Excel shortcuts

Excel tips and tricks

The AVERAGE Function

The SUM functions, The MAX functions, The MIN functions

The XLOOKUP function, The UNIQUE function, IFS FORMULA, MAXIFS FORMULA, MINI FS FORMULA

……and much more

13/12/2020

Indirect and offset formulas are different formulas they dont have similar meanings We can use offset formula with choose.

05/10/2020

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What do you want to look for?)

24/05/2020

Vlookup formula gives us work of if formula when we put 1 in the end.

20/10/2018

Array formula extracts multiple data from the table it needs ctr+shift+enter keys for the command you can not press only enter key it will show error.

13/11/2017

27/10/2017

Offset and match formula become more effective and more impressive when we put these formulas with the big spread sheet also it find out the data or answer from the intersection as well.
Offset needs reference no, row, columns so we can put match formula instead of row and columns then it looks so easy and fruitfull.

01/10/2017

Every excel formula starts with = or + Sig.

24/09/2017

Whenever you want a table sort by A to Z or Smallest to Largest here are Short cut for that
Alt+ A+ S.

19/09/2017

In this tutorial, i will cover some basic and useful Excel Shortcuts like:

a. Alt: Display key tips next to each Ribbon command

b. Ctrl+D: Copy the cell contents down

c. Ctrl+R: Copy the cell contents to the right.