Microsoft Excel
492 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by Trainedge Consulting
Scoop.it!

Mastering the Conversion of Minutes to Hours/Minutes in Excel - Accountingweb.com

Mastering the Conversion of Minutes to Hours/Minutes in Excel - Accountingweb.com | Microsoft Excel | Scoop.it
Understanding the decimal concept and Excel’s time-based number formats will help you grasp time-based values.
Trainedge Consulting's insight:

Excel stores times as a decimal portion of a day. Thus 12 hours is the same as 0.5. Three and a half-hours is represented as 0.145833333333333. Understanding this decimal concept along with Excel’s time-based number formats will help you whip time-based values into shape.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

The Power of the Pivot: Get Started with Excel Pivot Tables - Business 2 Community

The Power of the Pivot: Get Started with Excel Pivot Tables - Business 2 Community | Microsoft Excel | Scoop.it
If you rely on spreadsheets to manage any aspect of your business, pivot tables will make your life a lot easier.
Trainedge Consulting's insight:

A pivot table is a reporting tool that lets you sort, summarize, analyze, and present data in multiple ways while leaving your original data unchanged. Pivot tables work independently of your original rows and columns, thereby allowing you to create different views and reports without altering the original data table.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Infinite Skills' “Microsoft Excel - Creating Dynamic Dashboards” Teaches How ... - Virtual-Strategy Magazine (press release)

Infinite Skills' “Microsoft Excel - Creating Dynamic Dashboards” Teaches How ... - Virtual-Strategy Magazine (press release) | Microsoft Excel | Scoop.it
Software training firm Infinite Skills Inc. introduces its "Microsoft Excel - Creating Dynamic Dashboards", a 5 hour advanced course teaching Excel users how to create interactive visualizations and dashboards with Excel data.
Trainedge Consulting's insight:

With Infinite Skills’ "Microsoft Excel - Creating Dynamic Dashboards Tutorial", users with some Excel experience can learn to design custom, interactive visualizations of Excel data reports.


more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

The Excel Depression

The Excel Depression | Microsoft Excel | Scoop.it
Did a coding error basically destroy the economies of the Western world? You be the judge.
Trainedge Consulting's insight:

The real point with Reinhard-Rogoff is how the Right's propaganda machine operates. Every economic statistic, claim or assertion is useful only to the extent it can be used in their on-going war to remake America into the desired plutocracy.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

How to pull the first letter of a word in Excel | Taragis.Com

How to pull the first letter of a word in Excel | Taragis.Com | Microsoft Excel | Scoop.it
How to pull the first letter of a word in Excel http://t.co/w5bI5diQDl
Trainedge Consulting's insight:

This is the formula to pull first letter of a word in Excel : =LEFT(A2,FIND(” “,A2)-2)&MID(A2,FIND(” “,A2)+1,1)&”@taragismail.com”

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Highlight Duplicates Except First Number in Range in Microsoft Excel 2010 / 2013

Highlight Duplicates Except First Number in Range in Microsoft Excel 2010 / 2013 | Microsoft Excel | Scoop.it
In Excel, we can make values appear in a specific range by using Conditional Formatting or Formulas. Conditional formatting is a built in feature of Excel while formulas are flexible enough to fulfil our requirement.
Trainedge Consulting's insight:

Conditional formatting is a built in feature of Excel while formulas are flexible enough to fulfil our requirement.

We can use the COUNTIF function to return the output.

Countif: Counts the number of cells within a range that meets the condition.

Syntax: =COUNTIF(range,criteria)

range: It refers to the range of selected cells from which the function will check the number of items that have found.

criteria:  The condition which defines / specifies which cells to count.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Microsoft Overhauls Outlook for Mac, Promises Word, PowerPoint and Excel in 2015

Microsoft Overhauls Outlook for Mac, Promises Word, PowerPoint and Excel in 2015 | Microsoft Excel | Scoop.it
Microsoft just sprang a whole new version of Outlook for Mac on its subscribers in advance of a larger Office for Mac overhaul promised for next year.
Trainedge Consulting's insight:

Microsoft says you can run the new Outlook for Mac without uninstalling the Office for Mac 2011 suite, but it has some recommendations if you have just Outlook for Mac 2011 installed.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

10 Incredible Works of Art Made in Microsoft Excel

10 Incredible Works of Art Made in Microsoft Excel | Microsoft Excel | Scoop.it
Microsoft Excel is more than just blank rows and columns. Here are 10 incredible works of art made with the spreadsheet software.
Trainedge Consulting's insight:

 Excel has been unexpectedly used as a drawing tool to create some of the coolest illustrations.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

10 Tips, Tricks, Apps, and Add-Ins to Supercharge Microsoft Excel — QuickTip from CMIT Solutions | CMIT Solutions

10 Tips, Tricks, Apps, and Add-Ins to Supercharge Microsoft Excel — QuickTip from CMIT Solutions | CMIT Solutions | Microsoft Excel | Scoop.it
We worry about IT, so you don’t have to. At CMIT Solutions, information technology is our expertise. We take care of your small business IT needs with practical IT solutions.
Trainedge Consulting's insight:

1. Dig deep into data with PivotTable reports. 

2. Apply similar formatting to multiple sheets at the same time.

3. Improve user interface with Excel Utilities.

4. Improve user interface with ASAP Utilities.

5. Prevent bad data from mucking up worksheets.

6. Easily jump between multiple Excel spreadsheets using Office Tabs.

7. Open multiple worksheets with one double-click.

8. Use Search Commands for intuitive internal search.

9. Identify duplicate values

10. Insert rows and columns with ease.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

How to Separate Text in Columns in Ms. Excel 2010 | Share to World

How to Separate Text in Columns in Ms. Excel 2010 | Share to World | Microsoft Excel | Scoop.it
How to Separate Text in Columns in Ms. Excel 2010
Trainedge Consulting's insight:

Text to column is the best function to separate the contents of one excel cell into separate columns.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

How to Unhide Rows & Columns in MS Excel

How to Unhide Rows & Columns in MS Excel | Microsoft Excel | Scoop.it
How to unhide columns in MS Excel? You can also unhide rows in MS Excel. You can easily unhide or show all columns & rows in Excel to show the hidden columns and rows.
Trainedge Consulting's insight:

You can also right-click the selection of visible rows and columns that surround the hidden rows and columns, and then click Unhide.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Quip has Word/Excel in its sights, but will it hurt Microsoft domain? - Tech Times

Quip has Word/Excel in its sights, but will it hurt Microsoft domain? - Tech Times | Microsoft Excel | Scoop.it
Quip folds layers of spreadsheets into its suite of productivity software. Quip Spreadsheets is better than Google Sheets, but not quite as good as Excel, says Quip founder.
Trainedge Consulting's insight:

Quip's productivity suite features full support for importing all of the popular document types, allowing users to migrate those Word and Excel documents into a single workspace.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Peltier Tech Blog - Peltier Tech Excel Charts and Programming Blog

Peltier Tech Blog - Peltier Tech Excel Charts and Programming Blog | Microsoft Excel | Scoop.it
MS Excel resource: http://t.co/SOPjE4kud5 #excel
Trainedge Consulting's insight:

Pivot Table in Microsoft Excel 2007 is a quick and exciting way to slice and dice a large amount of data. Debra carefully explains the benefits of using Pivot Tables for fast data analysis, provides a step-by-step approach to those new to Pivot Tables, and offers tips and tricks that cannot be found elsewhere.

more...
No comment yet.
Rescooped by Trainedge Consulting from Into the Driver's Seat
Scoop.it!

Excel Vs. Access – Can A Spreadsheet Replace A Database?

Excel Vs. Access – Can A Spreadsheet Replace A Database? | Microsoft Excel | Scoop.it
Or should you be using both? Access and Excel both feature data filtering, collation and querying, but which program is suited to your work requirements, and how do you get the best of both worlds?

Via Jim Lerman
Trainedge Consulting's insight:

Access is a slightly different beast to Excel. Where Excel maintains a focus on numerical, potentially one-off data sequences, Access provides a storage solution for information that can be recalled and referenced across multiple places.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Best Excel Tutorial - OR Function: 10 Beneficial Ways to Use OR Function

Best Excel Tutorial - OR Function: 10 Beneficial Ways to Use OR Function | Microsoft Excel | Scoop.it
Teach yourself here how to use OR function in Excel. 10 examples for you for better understanding.
Trainedge Consulting's insight:

The OR function is a perfect tool that is included in the Microsoft Excel program, and operate as one of the functions that has solely been made for being logical.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Excel 2010 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems

Excel 2010 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems | Microsoft Excel | Scoop.it
Excel 2010 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems Offer Price $37.35 ISBN:1461457785 Authors Thomas J Quirk, Meghan Quirk, Howard Horton List Price : $49.95 Availablity Usually ships in 24 hours Publisher...
Trainedge Consulting's insight:

Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses.  Its powerful computational ability and graphical functions make learning statistics much easier than in years past.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

How to Make a Simple Graph or Chart in Excel

How to Make a Simple Graph or Chart in Excel | Microsoft Excel | Scoop.it
Excel is a powerful tool that you can use to create charts and graphs for small or large amounts of data. In this Excel tutorial, I'll show you how to take a small set of data and create a simple
Trainedge Consulting's insight:

To make this into a chart, you first want to select the entire range of data, including the titles (Test 1, etc).

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Dropbox and Microsoft form surprise partnership for Office integration - The Verge

Dropbox and Microsoft form surprise partnership for Office integration - The Verge | Microsoft Excel | Scoop.it
Microsoft and Dropbox are teaming up today to more closely integrate Dropbox into Office. The surprise partnership will benefit Dropbox users who use Office across desktop, mobile, and the web as...
Trainedge Consulting's insight:

Microsoft and Dropbox are teaming up today to more closely integrate Dropbox into Office. The surprise partnership will benefit Dropbox users who use Office across desktop, mobile, and the web as Microsoft’s productivity suite will soon become the standard way to edit Word, Excel, and PowerPoint files stored on Dropbox storage.

more...
No comment yet.
Rescooped by Trainedge Consulting from FrankensTeam's Excel Collection
Scoop.it!

Chart Events in Microsoft Excel - Peltier Tech Blog

Chart Events in Microsoft Excel - Peltier Tech Blog | Microsoft Excel | Scoop.it
When using a computer, you continuously interact with objects and programs through events. Here is how to use Chart Events to enhance your workbooks.

Via Kris
Trainedge Consulting's insight:

Chart events can make it much easier for people to use your programs, and add interactivity to your charts. 

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

How to rename Excel sheet tabs - OutofhoursAdmin

How to rename Excel sheet tabs - OutofhoursAdmin | Microsoft Excel | Scoop.it
This short tutorial shows you how to rename Excel sheet tabs so they are more relevant to the information contained within the spreadsheet...
Trainedge Consulting's insight:

To rename the individual sheets, all you have to do is right click on the name to bring up a menu, and select Rename. 

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Use Goal Seek to find the result you want by adjusting an input value - Excel

If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that
Trainedge Consulting's insight:

If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that you need to borrow some money. You know how much money you want, how long you want to take to pay off the loan, and how much you can afford to pay each month. You can use Goal Seek to determine what interest rate you will need to secure in order to meet your loan goal.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

MS Excel Tips - 3 Quick Tips | Stone Moor Business Services

MS Excel Tips - 3 Quick Tips | Stone Moor Business Services | Microsoft Excel | Scoop.it
MS Excel Tips - Check out our 3 quick tips for speeding up your workflow and helping with time management in Microsoft Excel.
Trainedge Consulting's insight:

1.enter ALT + =  to quickly add up all the data above.

2.copy as a picture

3.split text into new separate columns

 

3 Quick Tips For Microsoft Excel

 


 
more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Waiting For Perfect Conditions |Productivity Tips, MS Excel and Inspiration

Waiting For Perfect Conditions |Productivity Tips, MS Excel and Inspiration | Microsoft Excel | Scoop.it
Productivity Tips, MS Excel and Inspiration: Waiting For Perfect Conditions http://t.co/VygXsEWtkc
Trainedge Consulting's insight:

They know that excellence is not a product of perfect conditions or great circumstance, or else they would have limited their search for excellence to only some part of the globe.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

How strong is Microsoft Excel encryption? - Telegraph

How strong is Microsoft Excel encryption? - Telegraph | Microsoft Excel | Scoop.it
Excel encryption has strengthened over time, so newer versions should be sufficient to keep your files safe, said Rick Maybury
Trainedge Consulting's insight:

Excel 2000 encryption was weak and could be broken in a matter of seconds using widely available utilities on the web. It was strengthened significantly in Excel 2002/3, and changing from the default encryption method made it even stronger.

more...
No comment yet.
Scooped by Trainedge Consulting
Scoop.it!

Microsoft Excel Fails Math Test - The Age

Microsoft Excel Fails Math Test - The Age | Microsoft Excel | Scoop.it
Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.
Trainedge Consulting's insight:

Gainer said Excel makes mistakes multiplying 77.1 by 850, 10.2 by 6,425 and 20.4 by 3,212.5, but the program appears to be able to handle 16,383.75 times 4.

more...
No comment yet.