Uploaded videos
1-10 of 103-
Managing The Auto Complete Option In Outlook 2010.mp4
K2Enterprises
29 views
In Outlook 2010, Auto-Complete is the feature that suggests email addresses to you as type in data in to To, Cc, and Bcc fields of a message. While Auto-Complete is usually...
-
Handling Rounding Issues In Excel.mp4
K2Enterprises
71 views
One of the more frustrating aspects of working in Excel is how the application sometimes appears to add values together incorrectly, providing results that appear to be inc...
-
Creating Sticky PivotTable Formatting.mp4
K2Enterprises
95 views
One of the more frustrating aspects of working with PivotTables is the seeming inability to format a PivotTable so that the formatting remains intact when you refresh the P...
-
Advanced SUMIF and SUMIFS Formulas.mp4
K2Enterprises
110 views
SUMIF and SUMIFS are two of Excel's best functions. Using these two functions, we can create formulas that add data, subject to one or more conditions. The primary differen...
-
Creating A Chart With Two Vertical Axes.mp4
K2Enterprises
72 views
Sometimes when creating a chart, it is necessary to utilize two separate vertical axes because the numbers that are being charted are of different magnitudes. Doing so allo...
-
Using Two Minus Signs In Excel.mp4
K2Enterprises
205 views
The idea of using two minus signs together in an Excel formula might seem odd to many. However, doing so offers some rather interesting and powerful options. In this tip, w...
-
Creating A PDF Portfolio.mp4
K2Enterprises
204 views
A PDF Portfolio is a collection of documents contained inside a PDF "wrapper." Portfolios can include virtually all file types -- PDFs, Excel, Word, JPEG, MP4, CAD drawings...
-
Using Excel To Identify Entries That Add To A Specific Value.mp4
K2Enterprises
215 views
Have you ever encountered a large number of transactions and needed to find which of those transactions added to a specific amount? If so, then you've likely engaged in a t...
-
Emailing A Single Excel Worksheet.mp4
K2Enterprises
159 views
Many times, business professionals need to email a single Excel worksheet -- and not an entire workbook -- to an associate, client, customer, or third-party. While there ar...
-
Creating And Using Custom Styles In Excel.mp4
K2Enterprises
88 views
Suppose you have applied a number of formats to a particular cell or range of cells in Excel and you wish to save these formats for use in the future. You can do so by savi...
Advertisement










Play all(103)