Is Your PC Ready for Blu-ray? Equipment Needed
With major manufacturing concerns pretty much removed from preliminary releases of Blu-ray, the best time to capitalize on this technology is now. …
Continue ReadingShowing items from windows platform
Learn How To Number Each Record For A Customer, Starting At One For A New Customer With This Microsoft Excel Tutorial
Problem: You have a list of invoice data, as shown in Fig. 810. You wish to number the records in such a way that the first invoice number for Ford is …
Continue ReadingLearn How To Remove Blanks From A Range While Keeping The Original Sequence With This Microsoft Excel Tutorial
Problem: Someone has given you data pasted from Word, as shown in Fig. 774. There are a number of blank cells in the list. You want to eliminate the …
Continue ReadingLearn How To Use A Pivot Table To Summarize Detailed Data With This Microsoft Excel Tutorial
Problem: You have 50,000 rows of sales data, as shown in Fig. 841. You want to produce a summary report showing sales by region and product.
Continue ReadingLearn How To Use Consolidation To Combine Two Lists With This Microsoft Excel Tutorial
Problem: Jerry and Tina each compiled sales figures from paper invoices, as shown in Fig. 791. You need to combine Jerry and Tina’s list into a single …
Continue ReadingMicrosoft Excel Help: Create A Summary Of Four Lists
Problem: You have a list of Webelos scouts. As shown in Fig. 804, the list shows who attended various sessions at camp. You need to produce a master …
Continue ReadingRead Excel Tips Such As How To Add A Group Number To Each Set Of Records With A Unique Customer Number At BrightHub.com
Problem: You have a list of invoice data. You wish to number the records in such a way that the invoices for the first customer all have a group …
Continue ReadingRead Excel Tips Such As How To Increase A Range By Two Percent At BrightHub.com
Problem: You run the repair department for a company. As shown in Fig. 779, you have a spreadsheet of prices. Your manager tells you to increase the …
Continue ReadingExcel Help: My Manager Wants The Subtotal Lines In Bold Pink Tahoma Font, By Mr. Excel
Problem: Your manager loves your reports with automatic subtotals. He wants the subtotal lines formatted in bold pink Tahoma 15 point font. Again, …
Continue ReadingLearn How To Create Subtotals By Product Within Region With This MIcrosoft Excel Tutorial
Problem: In the dataset shown in Fig. 705, you want to add subtotals by two fields, such as Product and Region.
Continue ReadingLearn How To Subtotal One Column And SubAverage Another Column With This Microsoft Excel Tutorial
Problem: In the dataset in Fig. 753, you want to create a subtotal of revenue. It does not make sense to subtotal the unit prices in column C. It …
Continue ReadingMicrosoft Excel Help: My Manager Wants A Blank Line For Every Subtotal
Problem: Your manager wants you to add a blank line between sections of the subtotal report. This is a fairly standard request. Quite simply, data …
Continue Reading