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, Microsoft excel training, Office managers...

...Managing Worksheets & Workbooks; Navigating Worksheets & Workbooks; Formatting Worksheets & Workbooks; Customisation Options; Configuration Options... Learn about: Restrict Editing & Protect Workbook, Business Intelligence Features, Creating Pivot Tables...

...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: Microsoft Office, Excel Formula, Microsoft excel training...

...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: Power Maps, Microsoft Excel, Data exploration...

...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: Object-oriented programming, 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: Excel Sheet, Visual Basic, CAD 2D...

...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, Mixed References, Excel Formula...

..."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 App, Sheet content, Google Maps...

...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 Page, JSON Data, Coding project...

...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, MS Excel, Advanced MATCH...

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