Free Online Articles Directory
 |
Link Formatting - 1057 - Learn Excel from MrExcel Podcast
Video Description: Carrie from yesterday's podcast called in to say that the links are not working. It turns out that Carrie and Mike wanted to copy the cell shading of the linked cell and regular links don't do that. For Episode 1057, I go back to Excel 2003 to show where the Paste Picture Link is hidden. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! Related Article Subjects: accounting, Business, excel, formatting, MrExcel, spreadsheets, technology, tutorial
How to Find the Earliest Date for Records that Match 2 Criteria in Excel
In this Dueling Excel podcast, how to find the earliest date for records that match two criteria. Episode 1104 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from...
WIIW - Classic Pivot Layout - 1058 - Learn Excel Podcast
Michael sends in a great tip today about pivot tables. While Excel 2007 replaced the drag and drop feature with drop zones, there is an obscure setting in Excel 2007 that will let you go...
Axel Font for Excel
Erik Spiekerman has designed a font that is ideal for use in Excel. The Axel font is designed to be narrow yet highly readable both on screen and on paper. In Episode 1054, we will...
Indian Pay Rounding - 1042 - Learn Excel from MrExcel
Another question from Gopal. New India Pay Commission guidelines suggests that pay should be rounded to increments of 10. If the amount over the last 10 is less than or equal to 0.99, then round...
How to Choose a Random Name in Excel
Dave wants to know how to choose a random name, but he does not want the complete list of names in the cells in the worksheet! Episode 1020 shows you how. This video is the podcast...
MrExcel's Learn Excel #930 - QAT 2007
It is frustrating that commands in Excel 2007 are spread out amongst 7 different ribbon tabs. Episode 930 will show you how to add your favorite commands to the QAT - Quick Access Toolbar so...
MrExcel's Learn Excel #913 - Pivot Rates II
Yesterday, I talked about Jason's request to format a grouped pivot field in the row area of a pivot table. There is a solution, but it requires a bit of work in the original data...
MrExcel's Learn Excel #923 - Icon Set Alignment
The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it. This video is the podcast companion... Business Excellence: Its in the Eye of the BeholderBy: Graeme Nichol | 15/02/2007 | Video ConferencingBusiness excellence programs are part of a solution in moving an organization towards excellence - not the whole and only solution Separating Business and Personal FinancesBy: Cindy Kue | 31/07/2008 | OutsourcingMoney management is one of the most difficult tasks that a small business owner must face. In the early days, you may have a very uneven income stream, putting out personal funds for startup expenses and operating at a loss. Simple Business Plan Templates: The Value They AddBy: Eric Powers | 19/10/2009 | Strategic PlanningA business plan template is an important tool, especially for an entrepreneur learning business plan format for the first time. These are some of the benefits of buying and using a business plan template to create your business plan. Nokia E63: Business Handset With Oodles Of FeaturesBy: Dharmendra Chaudhary | 18/02/2009 | Cell PhonesNokia E63 is a very powerful business mobile with oodles of features. This hand set of Nokia has been made and designed to meet the needs of professional life even while you are on the go. Its features make it a complete communication mobile phone. How to Write a Business Letter - Super Tips to Create a Stunning Business LetterBy: Michael Lee | 16/06/2008 | Career ManagementEven if your business may be just a small entrepreneurial startup, knowing how to write a business letter is a key skill that you, or at least one of your assistants, should know. The Importance of Excel® in the WorkplaceBy: Sheri Graves | 07/09/2007 | BusinessExcel is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace. Filtering data based on font, colour and format criteria, down rows or across columns in a Microsoft Excel spreadsheetBy: Blake Mcnaughton | 12/04/2009 | SoftwareWhen Microsoft Excel is used to manipulate, store and analyse data it can become extremely difficult to manage, let alone efficiently work to produce any meaningful insights. This is because with data sets large and small, the data must be meaningful, logical, structured, internally consistent and clean. This holds true regardless of whether the data has been imported into excel from another system or manually entered. Features of Microsoft Excel That Assist in Analysis of Financial DataBy: Suzanne Mullett | 28/03/2008 | SoftwareFinancial data can present itself in complex and challenging ways that make understanding an analysis difficult. Find out how MS Excel can help you to make sense of that data using some straightforward inbuilt processes.
|
 |
|||||
|
Article Categories
|
|||||||
|
|
|||||||
