excel-diva.blogspot.com
Chatting about Excel and More: March 2015
http://excel-diva.blogspot.com/2015_03_01_archive.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Friday, March 27, 2015. Use Conditional Formatting's Icon Sets. Is a great feature in itself but today I wanted to focus on. Since everyone knows my love of lattes and chai, we will use a product line of coffees and teas. We want to emphasize the product lines that are are under budget in terms of their unit sales. Which spr...How t...
excel-diva.blogspot.com
Chatting about Excel and More: PMT function and Amortization Schedules
http://excel-diva.blogspot.com/2015/04/pmt-function-and-amortization-schedules.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Monday, April 13, 2015. PMT function and Amortization Schedules. In this example, we are going to walk through how to do a PMT. Function and then create an amortization schedule to make sure that the we did the PMT. Function correctly. The PMT. Click here to continue. Monday, April 13, 2015. Subscribe to: Post Comments (Atom). Inter...
excel-diva.blogspot.com
Chatting about Excel and More: Deleting Blank Sheet Rows
http://excel-diva.blogspot.com/2015/05/deleting-blank-sheet-rows.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Monday, May 18, 2015. Deleting Blank Sheet Rows. Deleting Blank Sheet Rows. If you select the column that you are interested in and then click on Find and Select. And then select Go To Special. And then select Blanks -. You will find that this is a more efficient way . Then select the dropdown arrow beside Delete. It's a great deal-...
excel-diva.blogspot.com
Chatting about Excel and More: Workbooks - Protection and Encryption
http://excel-diva.blogspot.com/2015/03/workbooks-protection-and-encryption.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Friday, March 6, 2015. Workbooks - Protection and Encryption. How to password protect and encrypt an Excel workbook. How many passwords do you have? The answer is probably too many. Below is a guest post from Joe Helstrom on protecting a workbook. Click here to see the steps needed to password your Excel workbook. Our Excel EBooks o...
excel-diva.blogspot.com
Chatting about Excel and More: August 2014
http://excel-diva.blogspot.com/2014_08_01_archive.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Monday, August 25, 2014. Selecting Non- Contiguous Cells. I was talking to someone the other day who had been using Excel for years but was unaware of how to select non-contiguous cells so I thought I would explain it in case you were interested. It is extremely easy. Then you hold down the CTRL. Key when you have finished. Key and ...
excel-diva.blogspot.com
Chatting about Excel and More: Visualize! Use Conditional Formatting's Icon Sets
http://excel-diva.blogspot.com/2015/03/visualize-use-conditional-formattings.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Friday, March 27, 2015. Use Conditional Formatting's Icon Sets. Is a great feature in itself but today I wanted to focus on. Since everyone knows my love of lattes and chai, we will use a product line of coffees and teas. We want to emphasize the product lines that are are under budget in terms of their unit sales. Which spr...Check...
excel-diva.blogspot.com
Chatting about Excel and More: February 2014
http://excel-diva.blogspot.com/2014_02_01_archive.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Wednesday, February 5, 2014. TRACKING FORMULA ERRORS in SPREADSHEETS. Guest Post: J. Helstrom. Spreadsheet formula errors may cause other calculations to also yield an error message. This is aggravating, especially if you’re working with a large worksheet. Formula errors can be fixed - the hard part is finding all of them. This blog...
excel-diva.blogspot.com
Chatting about Excel and More: May 2014
http://excel-diva.blogspot.com/2014_05_01_archive.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Monday, May 19, 2014. Protect Your Workbook Structure. If you share workbooks with others then I am sure you have experienced someone inserting or deleting a sheet and totally messing up your work. Or, that helpful person who renames the sheets for you? These steps pertain to the entire workbook - not just a worksheet. Our sister si...
excel-diva.blogspot.com
Chatting about Excel and More: February 2015
http://excel-diva.blogspot.com/2015_02_01_archive.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Tuesday, February 10, 2015. Use Data Validation to check for Duplicate Entries. If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and the CountIF feature to check for duplicate entries and then not allow the user to enter the duplicate data. Links to this post.
excel-diva.blogspot.com
Chatting about Excel and More: Copying Only the Cells that Contain Data
http://excel-diva.blogspot.com/2015/07/copying-only-cells-that-contain-data.html
Chatting about Excel and More. Software examples that you can easily understand and immediately apply to your own business needs. www.excel-diva.com and www.cpaselfstudy.com. Thursday, July 16, 2015. Copying Only the Cells that Contain Data. In my last blog entry I talked about using Go To Special to find blank cells. In this entry, written by guest Joe Helstrom, we cover using it to find blank cells as a useful way to only copy cells that contain data. Of course there is! Menu, under Find and Select.
SOCIAL ENGAGEMENT