How to Change the SUM of a Range Dynamically in MS Excel
To change the SUM of a Range Dynamically is easier than you thought in MS Excel. Let’s say you have a data table like this: PROBLEM: We want to create a SUM for the GROSS column that would adjust itself dynamically when new sales records are added to the table. How would you do that?…
Read MoreTechnical Writing is Technical Training
“Technical Writing is Technical Training” is probably the summary of my technical communication career. I know my trainer friends will object to this statement but I’ll say it again all the same: “Technical writing is technical training.” Then I’ll add: “It’s the training of a special type.” Or at least it should be. If by…
Read MoreCorrecting Capitalization Errors in MS Excel — How to Retype a List of Names Properly with PROPER Function
© Ugur Akinci Let’s say you have a list of hundreds of names typed with all kinds of capitalization errors: PROBLEM: How can you correct the capitalization errors in every name and make sure each first and last names begins with a CAPITAL letter, followed by lower-case letters? SOLUTION: It’s very easy. Just select a…
Read MoreHow to Display the Last Modification Date of a MS Excel Workbook by Using MS Excel Macro
Time for a simple MS Excel macro. Imagine you have a MS Excel document that is updated regularly or frequently. So you think it’d make sense to display the last date on which the document was modified so that your readers would know how fresh and updated the document is. If you enter the formula…
Read More