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: Personal Assistant, Financial Training, Office Administrators...

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

...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: VBA (Microsoft Access / Office), Visual Basic 6, Microsoft 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: Office IT, MS Excel, Power Maps...

...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: Visual Basic, Visual Basic training, MS Excel...

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

...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: T Line Breaks, Mixed References, Basic Formulas...

..."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 Forms, Google Forms App, Google sheets...

...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: TRIM Function, SUMIF Function, 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: Web Applications, Google Sheet Data, Google Apps...

...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: Excel Formulas, IF statements, 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...