Free Online Articles Directory
 |
Parsing Variable Length - 1043 - Learn Excel from MrExcel
Video Description: Dawn's file has name in A and address in B. Except: the address field in column B contains the name again. Episode 1043 shows how to parse the variable-length name out from column B. 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, formula, mid, 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 Profiles Bakery Process ERP Leader 02By: Thomas Cutler | 19/06/2007 | TechnologyBusiness Excellence Profiles Bakery Process ERP Leader 02 Microsoft Office and the Small Business: ExcelBy: Rich Talbot | 27/06/2007 | FinanceMicrosoft Excel is a spreadsheet creation and analysis tool that gives you the tools you need to manage critical business data and the power to get the most out of your information. Excel provides you with the tools to easily access, process, analyse, share and display the information you need in running your business. Business Excellence Profiles Escape Velocity Systems as Leading ERP for Baked Goods SectorBy: Thomas Cutler | 10/07/2007 | TechnologyBusiness Excellence Profiles Escape Velocity Systems as Leading ERP for Baked Goods Sector 3 Ways that MS Excel Courses Can Drastically Improve Productivity for TeachersBy: Rich Talbot | 20/06/2007 | TutoringDue to shrinking budgets and rising standards, today's teachers are expected to handle more work and responsibility than ever before. In order to shoulder the burden most teachers spend long hours after the bell rings recording grades, documenting attendance records, and cataloguing other information that is critical for assessing grade reports. DIY Accounting Small Business Accounting Software Questions And AnswersBy: Terry Cartwright | 26/05/2008 | TaxesDIY Accounting small business accounting software package is a series of accounting templates written on excel accounting spreadsheets, suitable for UK self employed business whether producing an automated monthly profit and loss account and self employed tax return form. These notes detail the typical questions and answers by clients. Do Your Own Business Valuation – Part 3: Quantifying Business ReturnsBy: David Coffman | 28/09/2009 | Small BusinessSeries of articles designed to help small business owners do their own business valuation. Part 3 is about how to quantify the returns of a business. Great Business Plan Tips for an EntrepreneurBy: Eric Powers | 09/12/2009 | BusinessGreat potential entrepreneurs should start with a great business plan which will lead to adequate funding as well as better guidance to their team. These tips will help to create that great business plan. Datasafexl: a Brief Overview of Microsoft ® Excel VulnerabilitiesBy: Nikolas Petousis | 16/12/2008 | SecurityIn this article, we will provide you with a brief overview of the Microsoft ® Excel security environment and examine in more detail the effectiveness of Microsoft ® Excel's built-in protection features.
|
 |
|||||
|
Article Categories
|
|||||||
|
|
|||||||
