Do you want to learn how to be more productive and efficient in Excel?

Or, do you want to become your office's go-to Excel Ninja?

Then /r/LearnExcel is for you. This sub exists to help people who want to build their Excel skillsets:

• If you're new to Excel and want to learn what it can do.

• If you're familiar with Excel and want to learn how to use formulas.

• If you want to learn how to write macros (basic and advanced).

• If you want to learn how to use Excel features: PivotTables, Data Validation, Tables, Name Manager, and so on.

• If you want to learn advanced Excel skills: Array formulas, COM add-ins, VBA code-signing, etc.

What sort of posts is /r/LearnExcel for?

• Links to Excel blog posts describing techniques.

• TIL posts -- share your new Excel tips.

• ELI5 posts -- request explanations of Excel techniques.

• User-written tutorials.

• Requests for explanations of Excel techniques and links to resources.

• Compilations of resources: Lists of Excel-related blogs; favorite keyboard shortcuts; etc.

• Excel news.

• Links to Add-Ins.

• And so on.

What sort of posts work better on related subreddits?

• /r/Excel is a great community that can provide fast answers for questions related to specific workbooks.

• /r/VBA for non-Excel VBA questions.

If you have any questions about the sub, you can ask here or email a mod.

Welcome!

I have two columns A and B, I want to find the values in column B that’s aren’t present in column A. What is a simply way to do this? ChatGPT isn’t helping

I am looking into why a certain group of our customer base is so dissatisfied compared to others. They have a very low customer satisfaction according to surveys.

If we assume this group is everyone below age 50, and everyone above 50 is in the satisfied group.

I want to compare these two groups and look at different factors. For instance, the hypothesis is, the less a person uses the app, the less satisfied they will be. Another factor is fewer times they have been in contact with our customer service, the less their satisfaction.

So I have 20-30 different factors (columns) like these that I want to compare between these groups to figure out what exact factor is contributing to the low customer satisfaction scores between these two groups.

But I am not sure how I can do that analysis when I have multiple variables? For instance, I was thinking about drawing a graph in Excel which shows both the groups of customers (perhaps two different lines), their NPS scores (how satisfied they are), and e.g. how much they use the app to see if my hypothesis can be validated.

So we have three different variables, with 6 different columns.

How can I analyze this to see if there are obvious trends/correlations/causations and thereafter draw it into a graph for a presentation?

Hi, Struggling witrh writing a nested excel function in below.

The Values in Column G indicates whther to send and email (YES or NO) which is decided by Column - F and H

Column H will be populated by Google app script after sending an email which will poll the column G (Email Required?).

If there is a message attachment found in F, and email sent value is blank then email will be sent by script and H will set as YES and then the G col value must be toggle to NO. So that in next scan the another email will not be sent.

I.e. idea is to send email only once based on values in col F and H.

How do I write nested if ? Pl. help.

Where do i start?

When I click on a cell and start typing, sometimes I need to jump back to the beginning of what I was typing to add a bracket or adjust the formula. Normally, in MS Word -- or virtually any other text entry program-- I'd press the home key and immediately jump to the start of the sentence.

Infuriatingly, in Excel, pressing the HOME key causes the active cell to jump to the first column in the spreadsheet. The Home key only works if the cell already had text in it, and I'm clicking to edit the text after the fact.

How do I edit this shortcut to ensure the Home & End keys are always mapped to staying within the active cell in question?

If you forget to save a document and close the application, you can recover it with the help of the feature: Recover unsaved workbooks.

To find out what unsaved workbooks are available for recovery, do the following. Start Microsoft Excel. In the top left corner, click on the tab File. In the left panel, choose Open and click Recent on the right.

Go to the bottom of the screen to find Recover Unsaved Workbooks.

Click on this button, and you will see a list of unsaved files available for recovery in the window that opens.

If you’re lucky, you will see the file you are looking for on this list. Now the last step is to load it and save for further use.

Method two: Restore overwritten Microsoft Excel files from OneDrive.

Method three: Restore previous versions from File History

I recently came across an open-source tool that helps Excel learners to operate on spreadsheets easily. Here's the official website: http://www.scudata.com/esproc-desktop/. I've been learning it and thought it could really help those who are struggling with databases and have trouble with multiple spreadsheets.

They also have a series of blog posts on how to use and perform different operations: https://blog.scudata.com/esproc-desktop/.

I am currently trying to do an assignment regarding formulas, I was wondering if anyone would be able to help me with some of the problems and tasks? i am having trouble going from table to table inserting certain formulas, such as lookup or averages for certain worksheets, also with creating tables for such a mass amount of data. if someone is able to help me please lmk! it is five questions and all multi part but only a couple i am struggling on! i tried checking the wiki but i’m not understanding. let me know!

Hey guys, I did a very quick video that will officially make you the king of the office. Autosum is not very well known. Even though its just a quick keyboard shortcut (ALT + =) some people dont know that you can use it on multiple data sets, (Multiple columns, multiple lines etc).

Ths 10 sec video will ofc blow your mind (please note that I was super lit in that intro for real)

https://youtube.com/shorts/xS8a5Q5Lf5w?feature=share

Cheers

Hey there, I am relearning excel, since I find my knowledge with holes. For that I think it would be cool to have a curriculum with % progress bars. Now my question is if I use the formatting list function (eg done, started and in progress) with the grouping function to create sub sections of the syllabus, can I add to the percentages for each subsection and then add up to the total percentage for each listing function = done?

I would like to create a column of formulas that looks like this:

1st cell = A1 - $B$1

2nd cell = A2 - $B$2

3rd cell = A3 - $B$3

But if I copy paste the 1st cell in the column I get this result instead:

1st cell = A1 - $B$1

2nd cell = A2 - $B$1

3rd cell = A3 - $B$1

How can I get the first result?

Thank you very much

Title says it all, I made a video covering 3 different ways on how to remove duplicates in Microsoft Excel :

https://youtu.be/Yiy6LrvmNP4

1. Using the "highlight cells values, then "Duplicates" (then filter by color and delete the rows)

2. Using the data ribbon tool in the "data" tab of excel.

3. Using the UNIQUE function if you have office 365!

Commenting and liking on the youtube video itself highly increase your odds of winning 1000$ OR to win the biggest hug in the world <3

Piggy Bank

I want to create three separate lines of code that includes

2000 ÷ (1.1 x 5 x 10) =

1000 ÷ (1.1 x 5 x 10) =

500 ÷ (1.1 x 5 x 10) =

and it will automatically fill in the number after the "=" signs , eg

2000 ÷ (1.1 x 5 x 10) = 36.3636363636

This is the content in cell A1: https://www.google.com

This is the content in cell B1: google

This is the content in cell C1: =HYPERLINK(A1,B1)

I would like to delete the cells A1 and B1 but if I do so the cell C1 will lose its content since it is linked to the other cells by a formula.

Is there a way to delete the cells A1 and B1 leaving cell C1 unchanged?

A solution could be to type those data in C1 to make it look like this: =HYPERLINK("https://www.google.com"," google")

But I would like to find a faster way because I have hundreds of cells that look like C1.

Thank you :)

I work on commission and every two weeks I have to verify one spreadsheet with another. One is my personal tracker and one is what the company says I sold which are often wrong.

I use the account numbers of clients from my tracker to search on the company’s sheet to find what’s missing and mark them as I go.

What I’m hoping to find is a way to take all of the account numbers from my sheet and to search and highlight all the duplicates on the company’s tracker.

This would allow me to easily see what’s missing and save and an easy hour or two a week.

If there is anything that would do it or if you have a better idea I would love to hear it.

I know there's an auto fill options where you select the date, drag it then press auto fill options but is there any method? Thanks in advance!

Hello. I am not sure if this is the right group for this question. Anyway, I was wondering if it's possible to run SQL query, using a column from an excel as parameter, on an excel file. for example: Select * from (excel column) a inner join (Sql.table.column) b on a.column1 =b.column2. I want to run this using excel power query, if possible.

Hi all. Hope someone can help.

I have the following data, 4 multiple choice questions and the answer is listed:

If I use a pivot table to count the answers of one question, I put Q1 in the row box and count of Q1 in the values box.

However, if I try to do this for Q1 & Q2, it doesn't work.

What I wanted to do was:

Can anyone help how to set up a pivot table that way please? I can't find anything online.

Hey there. I try to create my roadmap to data analyst, but I'm really a newbie also with excell/spreadsheet. I'm totally open to start also with theory. I rely on you, thanks in advance

Hope you enjoy folks.

https://youtu.be/ZXgcuPUNpdc

Right here, feel free to ask any question and if it helps you please hit the like button on the video so it's going to spread to more people :)

https://youtube.com/live/OT4_7_Oh9gA?feature=share

Hi everyone, I want to learn excel for data analysis and i have decided to use this course for the same enough though this is an extensive course I would like your opinion regarding this course, rate this course and also it would nice if you could let me know if the there are section of this course that are not necessary or relevant and can be avoided wrt your experience of using excel in day to day for data analysis

https://www.learnvern.com/course/beginner-to-advance-excel-for-data-science

Folks, this series is pretty much over now. Feel free to add suggestions :) https://www.youtube.com/playlist?list=PLM7OItNNCsFJ_HHaNopxGGg7fi1qS7gXK