r/ExcelTips_ActiveGroup • u/LuGaAutomation • Jun 15 '23
Excel Dark Themes
Hello everyone, take a look at this video to truly give Excel a Dark Theme.
r/ExcelTips_ActiveGroup • u/LuGaAutomation • Jun 15 '23
Hello everyone, take a look at this video to truly give Excel a Dark Theme.
r/ExcelTips_ActiveGroup • u/mostlysanewithexcell • Oct 26 '23
r/ExcelTips_ActiveGroup • u/jjhaines • Jun 14 '23

All I want is to count the "H" as the value 0.5 instead of the value 1 seen in column "AH". To reflect my employee using a half day of vacation. I am using the Employee absence Template given from Excel. I think I have to used a combination of IF and COUNT IF statements but I am not sure. Does anyone have a quick solution for this? Current formula in AH row 10 is, =COUNTA(January!$C10:$AG10). Would appreciate any input. Thank you!
r/ExcelTips_ActiveGroup • u/avinashbaheti • May 01 '24
r/ExcelTips_ActiveGroup • u/Nearby-Minimum-1602 • May 09 '23
r/ExcelTips_ActiveGroup • u/ankit_mrmmbs • May 25 '23
url 1 - https://www.mrmmbsvision.com/uae/nft-marketplace-development
url 2 - https://www.mrmmbsvision.com/atlanta/nft-marketplace-development
i want the word "uae" and "atlanta" only in excel, so please share the excel formula to extract the word in middle of the url
r/ExcelTips_ActiveGroup • u/Stephnic7 • Nov 24 '22
r/ExcelTips_ActiveGroup • u/CascadiaRiot • Jan 25 '23
r/ExcelTips_ActiveGroup • u/ClaytonJamel11 • Jun 29 '23
r/ExcelTips_ActiveGroup • u/Pryor_Learning • Sep 26 '22
r/ExcelTips_ActiveGroup • u/InternationalDisk659 • Sep 21 '22
r/ExcelTips_ActiveGroup • u/RaspberryConscious73 • Jul 10 '24
r/ExcelTips_ActiveGroup • u/Consistent_Yak_7499 • Dec 14 '22
r/ExcelTips_ActiveGroup • u/landohylton • Sep 24 '23
r/ExcelTips_ActiveGroup • u/Excelly-AI • Mar 03 '23
Hi, I created a tool that can generate and explain any Excel formula.
I wanted to post it here since many people here need help with Excel formulas and hence might benefit. It's free for up to 10 formulas a day, which should suffice in most use cases :)
r/ExcelTips_ActiveGroup • u/Icy-Blacksmith-8690 • May 25 '23
Hello everyone! I leave you this interesting video on how to calculate percentages in Excel. I hope it works for you! https://www.youtube.com/watch?v=g1FQGZkauP8
r/ExcelTips_ActiveGroup • u/bencrunch • Oct 03 '22
r/ExcelTips_ActiveGroup • u/Ok_Inevitable_8055 • Jun 07 '23
Hello all,
Let me start with "I have 0 experience"
I am trying to take a workbook with multiple spreadsheets (60+) and save each sheet as its own PDF. have to save each and every one, every week.
Could someone please help me figure out what I'm doing wrong (preferably dumb it down)? I've tried youtube videos and each macro I try, I get errors, but this was the closest to what I needed.

r/ExcelTips_ActiveGroup • u/ScB277 • Jun 14 '23
r/ExcelTips_ActiveGroup • u/No-Guess5763 • Apr 26 '22
Most Commonly Asked Excel Interview Questions 2022
Knowledge of Excel is one of the most valued skill an organization demands. Lacking Excel skills can lead to lesser chances of clearing an interview. There are a lot of ways by which the candidates can improve their knowledge about Excel and prepare for the Excel Interview Questions. There are numerous kinds of questions that the candidate can prepare for. To begin with, Excel software has a lot of benefits and is a special program meant for the purpose of documentation of information along with the analysis. It comprises of a lot of rows and columns. The point where the rows and columns in excel meet is known as cell. The cell carries a single point of data or the information in a single piece. This makes the user to locate the data easily in Excel. This also proves to be beneficial in gathering information from altering of data.
Now let’s dive into the basics of Excel,
The Excel Interview Questions that a candidate should stay prepared for are:
How can you define Microsoft Excel briefly?
Microsoft Excel is a software or application in the computer in the format of a spreadsheet which lets the user to store data by converting it into the form of table. The following software was innovated by Microsoft and has now become one of the most necessary software. The following can be utilized on numerous operating systems like Windows, macOS, IOS and Android.
Necessary features that Microsoft Excel carries are:
The following software carries graphics tools
The following software carries inbuilt functions like SUM, COUNTIF, DATE and others.
The following software lets the user to make proper analysis of information by tables, filters and charts.
The following software features the availability of VBA or the Visual Basic Application
It also has flexible worksheet operations along with flexible worksheet operations
The following also lets the data validation in a simple manner
r/ExcelTips_ActiveGroup • u/Excel_4y • Jan 03 '22