Distance and online learning Excel training

...These intensive online trainings are open to anyone with an interest in the topic and give you access to world-class learning led. Are you interested in this course?... Learn about: Account Assistance, Accounting Formulas, Personal Assistant...

...Managing Worksheets & Workbooks; Navigating Worksheets & Workbooks; Formatting Worksheets & Workbooks; Customisation Options; Configuration Options... Learn about: Business Intelligence Features, MS Excel, Lookup Data Using Functions;...

...you will construct a basic invoicing system and at the same time get a chance to practice using advanced formulas, data validation and worksheet protection... Learn about: Visual Basic 6, Programming Application, VBA (Microsoft Access / Office)...

...million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel. Discovering data insights: you will gain new understandings... Learn about: Ms Office, MS Excel, Office IT...

...this course will provide your with all the knowledge you need to get started. You can download all of the materials used in the lectures, so that you can follow along... Learn about: MS Excel, VBA (Microsoft Access / Office), Visual Basic...

...Formulas for transformation of utm coordinates - geographic Generation of kml files from excel Conversion of coordinates to courses / bearings and distances... Learn about: Visual Basic, CAD tools, Google Earth...

...functions like IF, IFERROR, AND and OR. These functions allow you to make the value displayed in a cell dependent on the results of logical tests... Learn about: MS Excel, TRIM Function, Mixed References...

..."Create new spreadsheets Edit and format sheets Add and delete columns and rows Move columns and rows Freeze columns and rows Add, remove and rename sheets... Learn about: Google Docs, Google Maps, Product Design...

...Flash Fill Revision 2. Using the TRIM Function 3. Changing the Case of Text 4. The LEFT and RIGHT Functions 5. The MID Function 6. The CONCATENATE Function... Learn about: SUMIF Function, VLOOKUP Exact, MS Excel...

...Taught by an instructor with over 18 years development experience ready to help you learn. Exercise based course demonstrates building a fully functional... Learn about: Dynamic Data, AJAX Data, JSON Data...

...We’ll also encounter examples of using formulas to build formulas; mega formulas, sometimes dozens of lines long, which would be very hard to write manually... Learn about: IF statements, MS Excel, Optimizing Lookup...

...0104 Customize The Quick Access Toolbar 0105 Using The Included Working Files 0106 About The Author 02. Learning Microsoft Excel 2013 - Managing Excel...