Excel For Dummies, 2nd Edition: 2nd Edition (For Dummies Computer Book Series)

Product Information

Alternatively, pressing Ctrl+Alt+S allows you to save your work without navigating to the Save button. Therefore, all you have to remember in the following table is the second letter in the File menu hot key sequence.

I see lot of people asking for a pat in the back ( like looking for a certificate of completion ), this is a SELF-HELP course, and I am not sure I will have as much information given to me even if I attended a PAID COURSE.li>\n\n

If you’ve not yet saved the workbook on your OneDrive, a Share dialog box appears inviting you to upload the workbook file to OneDrive. Excel selects all the records of the database (without including the first row of field names) and opens the Sort dialog box. You are a wonderful teacher and have made it so easy for me to grow my knowledge of Excel — Thank you for these wonderful videos and instruction! These tasks can be complex, but for most users, they are reasonably simple tasks that are repeated often. A simple Excel dropdown list on a spreadsheet can make entering text much easier and, more importantly, ensure it is accurate.

In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel. For instance, QuickBooks Online offers a fixed asset, but it’s simply a list and doesn’t offer tracking.At the bottom right of the Excel spreadsheet, you can quickly zoom the document by using the minus and plus symbols. I feel very happy not only to be enriched with learning Excel tips by you but also to be enjoyed by your way of imparting training. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. And again, since I am learning this on my own to improve MY understanding of spreadsheet program, I can understand and appreciate why some persons want to squeeze a CERTIFICATE out of this as a ticket for a future job.