A Look at Macros and Their Uses - What is a Macro?
In this article, we examine the art of creating a macro and its use, especially for those who are not familiar with what a macro is.
Continue ReadingShowing items from computing/windows-platform/topics/microsoft-excel
An Introduction to Office Macros
Macros allow you to save time and money by automating tasks in your Office applications. This article gives you an introduction to macros, and shows …
Continue ReadingOffice Applications: What is out there besides MS Office?
A look at the various office applications available in the market. Review the alternatives to Microsoft Office 2007. The pros and cons of various …
Continue ReadingLearn How To Fit A Multiline Heading Into One Cell With This Micorosoft Excel Tutorial
Problem: The problem on List Format indicated that your headings should occupy only one row to allow for easy sorting. Your manager requires that you …
Continue ReadingDiscover What To Do When Your Manager Is Obsessed With Formatting And Cannot Make Up Her Mind With This Excel Tutorial
Problem: As shown in Fig. 1049, your manager wants all the totals in bold blue, Times, and in 12 point on one day, and the next day she wants you to …
Continue ReadingExcel Help: Have Web Data Update Automatically Every Two Minutes, By Mr. Excel
Problem: You have a Web query inserted in your spreadsheet that updates automatically when you open the spreadsheet. You would like the Web …
Continue ReadingLearn How To Quickly Create Charts For Any Region With This Microsoft Excel Tutorial
Problem: You need to create similar charts for each sales region from the transactional data shown in Fig. 994.
Continue ReadingLearn Why The Spaces In This Web Data Won't Go Away With This Microsoft Excel Tutorial
Problem: As shown in Fig. 1032, you imported this data from a Web page. After many attempts to remove the internal spaces, you are still unable do so.
Continue ReadingMicrosoft Excel Help: Use A Built-In Data Entry Form
Problem: You need to do data entry in Excel. You have a lot of records to key or to edit, as shown in Fig. 1041. Can you easily create a dialog to …
Continue ReadingMicrosoft Excel Help: Use Query To Get A Unique Set Of Records
Problem: You’ve seen many different ways to get a unique list of customers from a dataset in Excel. You are sitting back right now, thinking, couldn’t …
Continue ReadingRead Excel Tips Such As How To Transform Black And White Spreadsheets Into Color At BrightHub.com
Problem: Your worksheet is boring black and white, as shown in Fig. 1045. You want to jazz it up with color.
Continue ReadingDiscover How To Calculate Fields In A Pivot Table With This Excel Tutorial
Problem: You need to include a calculation in the pivot table that is not in your underlying data. Your data includes Quantity Sold, Revenue, and …
Continue Reading