Jul 19 2017 02:39 PM
If you’re new to Excel, or even if you have some experience with it, you can walk through our most requested features in this tour. With real-world examples and helpful visuals, you’ll be able to sum, fill, sort, filter, and pivot like a pro. Download the template now.
Please note that this template only applies to Excel 2013 and 2016 for Windows.
Jul 21 2017 02:22 PM
Perhaps to keep on the top with the title "Please check this before ask the question"...
Jul 24 2017 01:45 AM
Good Morning,
I looked throught your document but unfortunately it didn't help me. In fact, i have a very big database and I would like to delete the rows in which some cells equals to 0. At first, I wanted the cells to be blank so I unticked the "Show a zero in cells that have zero values" checkbox and tried to delete the blank cells but it didn't work as the cells weren't really blank. So I'd like to know if it was possible to use a formula that can delete rows in which some cells are equals to zero.
Thank you in advance for your time and your help,
Have a great day
Best,
Jul 24 2017 02:23 AM
Hi Fanny,
Straightforward manual variant could be like this (assuming for this example your zero cells are in one column). Select this column and apply Filter in Data tab of Ribbon
Filter only cells which you want to delete (with zeros)
Select them and Delete Rows from right click menu
You see only the filter now
Expand filter and select all
Now you have all your rows but ones with zeros
If such transformation is repeating operation better to use Get&Transform then. And be sure you have a backup before deleting.
Jul 28 2017 01:45 AM
Aug 03 2017 06:35 AM
useful info but it didnt answer what i was looking for, how do i transfer data from a 2017 workbook to a 2018 workbook?
Aug 03 2017 11:18 AM
Aug 03 2017 12:23 PM
No, 2017 and 2918 are the names of my excel workbooks. I'm using Excel 2013, i want to transfer data from one excel workbook to another exel workbook
Aug 07 2017 09:54 AM
This is amazing! My mom could even learn Excel with this interactive spreadsheet. Thank you. (Well, OK, realistically my 84-year-old mother has no idea what a spreadsheet is, so...)
I've been using Excel since the dawn of time, and I learned so many cool tricks just using the first 2 lessons. Wonderful work! This will help TONS of people access the power of Microsoft Excel.
Aug 23 2017 07:44 AM
Aug 23 2017 09:18 AM
Veuillez pardonner mon français (je dois pratiquer, alors merci pour l'opportunité). Je pense que ils ont eu un peu des problemmes avec cette "build" et les commandes quand on fais le click droit. Quelle outil voulez-vous utiliser? Ca peut m'aide a vous aider!
Aug 24 2017 09:23 AM
Sep 12 2017 11:24 PM
Congratulations for a job well done, it is a really good tool for Excel beginners.
Feb 15 2018 08:07 AM
Please help-
I am lost - I just don't understand the logic of MS - I want to take the template of weekly assignment and create duplicate sheets that are formatted in the same way but every time I add a sheet it is not formatted and when I try to copy and paste it looks awful. How can I make this?
Feb 15 2018 05:36 PM