The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition. =SUMIF(range, criteria, [sum_range]) Find the sum of Total stats for Grass type Pokemon: The condition is that the type is “Grass”. Example SUMIF function, step by step: Select the cell… Continue reading Excel SUMIF Function
Tag: Excel function
Uses of Macros and Recording a Macro
Macros are a powerful tool in Excel that can help automate repetitive tasks and save time. Some common uses of macros in Excel include: Automating data entry tasks: Macros can be used to automate tasks such as copying and pasting data, formatting cells, and inserting formulas. Updating charts and graphs: Macros can update charts and… Continue reading Uses of Macros and Recording a Macro
Macros in Excel
Macros in Excel are a series of commands and actions that are recorded and saved as a program or script that can be executed at a later time with a single click. Macros allow users to automate repetitive tasks and increase productivity. Macros can be created and edited using the Visual Basic editor within Excel.… Continue reading Macros in Excel
Macro Functions to Sorting values, Copy Values from one sheet to another
Solution Here ‘Input’ refers to main sheet and the values from ‘Input’ is copied to ‘Output’. sorting2 – macro function to sort Shoppee_Run() – A new sheet is created on running macros, copy values from one another, erase the new sheet on every ‘Run’ of macros. Also it creates as a csv file.
PIVOT TABLE SHORTCUT KEYS
To group Pivot table items – Alt + Shift + Right Arrow To Ungroup Pivot table items – Alt + Shift + Left Arrow To hide Pivot table items – Ctrl + – To create a Pivot chart on the same sheet – Alt + F1 To create a Pivot chart on the new worksheet… Continue reading PIVOT TABLE SHORTCUT KEYS
Excel Row & Column Formatting Short cut Keys
To select the entire Row – Shift + Space To select the entire Column – Ctrl + Space To delete a column – Alt + H + D+ C To delete a row – Shift + Space, Ctrl + – T o hide a selected row – Ctrl + 9 To unhide a selected row… Continue reading Excel Row & Column Formatting Short cut Keys
Excel: Transpose Rows into Columns
We can convert the values in each row of the same column to different columns of the same row.We can transform the items in one of those rows into columns (or vice versa). It would take a lot of time to copy and paste each individual header — but the transpose feature allows to do… Continue reading Excel: Transpose Rows into Columns