Wednesday, May 23, 2012
Login

Posts Tagged ‘Excel’

Excel To SAP (Sales Order).flv


excelsap.com presents Excel SAP Loader – a deeply integrated third-party solution for SAP Business One. With single sign-on, it takes an Excel Spreadsheet, extracts the required data and loads it into the relevant SAP Object for persistence into the database within few seconds, using the SAP API.


Save a Form in Excel: Podcast #1272


Kim has designed a simple data entry spreadsheet and would like to have a way to paste the data into the next empty row of a database worksheet she has created. In Episode 1272, takes a look at how to finesse the macro recorder to solve this problem.


lynda.com Tutorial | Excel 2010 Power Shortcuts—Split screens and frozen titles in a flash


Watch the entire course at www.lynda.com In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more.


AutoFill Options in MS Excel


Learn how to save time and ensure accuracy when entering data into your Excel spreadsheet. Excel’s AutoFill feature has many options to explore. Want to fill workdays only? Watch to see how? To see all of my MS Excel “Tips & Timesavers” vist my website: thecompanyrocks.com


Select Short or Long Drop Down List in Excel


www.contextures.com In an Excel worksheet, add a drop down list in a cell, to make data entry easier. In this example, created by Alex Jankowski, users can see a short list of frequently used customer names, or a long list, with all customer names. No macros are required — the data validation formula does all the work. Watch this video to see how to name a list, then select the short or full drop down lists in the worksheet cells, based on that list. These instructions are for Excel 2007 and Excel 2010. For Excel 2003, use the toolbar commands.


 

Powered by Yahoo! Answers