How to Use the AutoSum Feature in Microsoft Excel 2013
Thursday, August 08 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.
- Published in Excel 2013, Latest
No Comments
Inserting and Deleting Sparklines in Microsoft Excel 2013
Thursday, August 01 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
- Published in Excel 2013, Latest
Using Flash Fill in Microsoft Excel 2013
Thursday, July 18 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
- Published in Excel 2013, Latest
How to Create Tables in Microsoft Excel 2013
Thursday, June 27 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”
- Published in Excel 2013, Latest, Microsoft, Office 2013
How to Format Cells in Microsoft Excel 2013
Friday, June 07 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.
- Published in Excel 2013, Latest, Microsoft
How to Insert Charts into an Excel Spreadsheet in Excel 2013
Friday, May 31 2013
Excel 2013 allows you to create charts from the data stored in a worksheet more easily than in previous versions. Charts are useful for times when you wish to create visual representations of the worksheet data for meetings, presentations, or reports. In this post, we will discuss how to insert charts into an Excel Spreadsheet
- Published in Excel 2013, Latest
How to Insert Functions into Spreadsheets in Excel 2013
Friday, May 24 2013
Excel is a multi-featured worksheet program in which you can create powerful worksheets that can manipulate numbers for you. It is a very powerful program, and has many advanced features that can automate and simplify your work. Whether you want it to create charts, worksheets, or data sources, Excel can assist you in accomplishing your
- Published in Excel 2013, Latest