Tag: BCOM106 Macro Economics

Excel. Chances are, that word alone inspires visions of lengthy spreadsheets, complicated macros, and the occasional pivot table or bar graph. It’s true—with more than …

Creating Tables Table Tables are designed to organize and display information, with data arranged in columns and rows. Tables make it easier to understand, read, …

Excel is a Microsoft Office software program that provides worksheets and workbooks. Worksheets are documents comprised of rows, columns, and cells. In each cell the …

Sorting Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, …

The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others (see table below), and …

To enter a date in Excel, use the “/” or “-” characters. To enter a time, use the “:” (colon). You can also enter a …

Excel has many functions to offer when it comes to manipulating text strings. Join Strings To join strings, use the & operator. Note: to insert …

Financial functions calculate financial information, such as net present value and payments. For example, you can calculate the monthly payments required to buy a car …

A PivotTable is an Excel tool for summarizing a list into a simple format. You create PivotTables from lists, as you define which fields should …

Use Excel Scenarios to store several versions of the data in a worksheet. For example, when preparing an annual budget, the Marketing and Finance departments …