How to Use the AutoSum Feature in Microsoft Excel 2013

Much of the time, people use Excel to sum columns and rows of data. In fact it occurs so frequently that Excel has included a feature called AutoSum that automatically performs a selected function, like SUM, on a selected column or row of uninterrupted (no blank) cells. This saves you time in creating basic formulas.
Read more
No Comments

Inserting and Deleting Sparklines in Microsoft Excel 2013

You can insert sparklines into your worksheets to illustrate changes to data values within a column or row of contiguous worksheet cells. A sparkline is basically a mini-chart that appears within a single selected worksheet cell and displays selected cell values as a trendline, columns, or a win-loss series.   To create a sparkline within
Read more
No Comments

Using Flash Fill in Microsoft Excel 2013

Click here for the complete Excel training             Starting in Excel 2013, you can use the “Flash Fill” feature to automatically fill-in values within a column with information entered into an adjacent column. This feature is most useful when dealing with data that has a consistent data entry pattern in
Read more
No Comments

How to Create Tables in Microsoft Excel 2013

Excel can store information in tables. An Excel table is information stored in a table format and defined as being a table within Excel. When you store information in a table format, you place the different types of information that you want to collect in columns, which are called “fields” in database terminology. Each “field”
Read more
No Comments

Managerial Accounting- Overview of Cost Behavior

Cost behavior analysis is the study of how certain costs behave in a business. Understanding cost behavior is crucial for managers so they can control costs effectively. In this post, we will give a brief overview of cost behavior and the different types of costs a manager can analyze. More information can be found on
Read more
No Comments

Small Business Accounting- Cash Versus Accrual Basis Accounting

There are two types of accounting: accrual and cash. It’s important for a small business to understand the two systems in order to select the correct accounting methods. In this post, we will discuss the differences between cash basis and accrual basis accounting.           Accrual basis accounting means that companies record
Read more
No Comments

How to Format Cells in Microsoft Excel 2013

Formatting cells in Excel can be a great way to add professionalism to an Excel spreadsheet. In can also be a great way to have numbers and figures in your charts stand out. In this post, we will discuss how to format cells in Microsoft Excel 2013.  1.Select the cells that you want to format.
Read more
No Comments

How to Insert Page Numbers into Headers or Footers in Word 2013

Automatic page numbering can be a great final touch to formal papers such as research documents and professional reports. In this post, we will discuss how to enter automatic numbering into the header or footer sections of a document in Microsoft Word 2013.           1. To view and edit header and
Read more
No Comments