Tag: BCOM210 Financial Modeling

Presentation software is a category of application software that is specifically designed to allow users to create a presentation of ideas by stringing together text, …

Advanced Excel refers to features and functions of Microsoft Excel tool which helps the user to perform complex and large calculations, data processing on the …

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 …