Distance and online learning Spreadsheet courses

..."Have you ever want to get data from your Google Spreadsheet and use it in a web application? If yes then this course is perfect for you :) Step by step instruction on how to setup Google Sheets with a web app outputting data as JSON. Use AJAX from your web application to get that data into... Learn about: Web Page, Google Apps, Coding project...

...HLOOKUP, INDEX, MATCH, Nesting lookup functions, IF, Grouping and many more Create dynamic report with Excel Pivot Tables and Power Query Keyboard shortcuts... Learn about: Basic Mathematics, IT Auditing, MS Excel...

...Paste Insert an Image Intermediate Create a Sparkline Filtering data Naming a Range Autosize a Column Editing Formulae Formula Auditing Calculate the Average... Learn about: Excel for Accounting, Microsoft excel training, Changing Cells...

...edit existing documents and create new workbooks. The Microsoft Excel 2010 Basic qualification will give individuals the skill and knowledge on how... Learn about: Microsoft Excel, Entering and Editing Data, Modifying a Worksheet...

...Navigating -Adding and deleting columns and rows -Moving columns and rows -Freezing columns and rows -Adding, removing and renaming sheets within a... Learn about: Google Maps, Google Forms, Spread sheets...

...you’ll learn how to set up key fields in tables, plus you’ll use action queries to quickly and easily manipulate multiple-table records with one command... Learn about: Visual Basic training, MS Excel, Basic IT...

...Paste Insert an Image Intermediate Create a Sparkline Filtering data Naming a Range Autosize a Column Editing Formulae Formula Auditing Calculate the Average... Learn about: Microsoft Excel, Entering Data, Excel for Accounting...

...Trends. Omni Social Channel Analytics :- Learning Objectives - In this module, we go across channels to understand how measurement changes at an omni channel level... Learn about: Social Media, Media Marketing, Object-oriented training...

...as well as how they can be customized according to the options provided by the software. Unit 4: PREPARATION OF PAGES FOR PRINTING AND PRESENTATION. Learn... Learn about: Numerical information, Data Access, Data entry...

...marked with learners receiving an instant grade... Learn about: Macros and Custom Functions, Lookups and Data Tables, Financial and Date Functions...

...iPad Tips And Tricks 0301 Introduction To Tips And Tricks 0302 Working With The iPad Touch Keyboard 0303 Selection Techniques 0304 Additional Keyboarding... Learn about: Office IT, Microsoft excel training, MS Excel...

... excel spreadsheet which acts as a cashbook, as well as prepares a profit and loss for you – which will help you to submit your self-assessment tax return. If you want an easy, but very efficient way to do the small business bookkeeping using an excel spreadsheet, it’s a perfect... Learn about: Business Accounting, MS Excel, Tax return...

...Whether you need to learn the skills for work, want to fill the gaps in your CV or simply fancy learning something new, this Excel beginner course is perfect to do... Learn about: Excel Formula, Microsoft excel training, MS Excel...

...This course is perfect for: Business owners Students of accountancy Students of finance Students of bookkeeping Budding finance directors Management accountants... Learn about: Income entered, Background to VAT, Bank Reconciliation...

...software at an intermediate level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something... Learn about: Microsoft Excel, Microsoft Access, Microsoft Office...

...and you have transformed your work in Excel to the click of a button. Spreaddsheet automation. Saving time. Getting more from Excel. Intermediate to advanced Excel users... Learn about: MS Excel, Excel VBA, Microsoft Excel...

...to the Curriculum Design Spreadsheet Mark Objectives For Assessments Determine the Initial Class Structure Solidify Specific Course Groupings Customize... Learn about: Organize Tasks and Subtasks, Audience Introduction, Design Spreadsheet...

...Enter a Function Math and trigonometry function Statistical Functions Logical Functions Search and address Information functions Date and Time Functions... Learn about: Ms Office, Microsoft excel training, MS Excel...

...This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel... Learn about: IT Auditing, Microsoft Excel, Excel Sheet...

...data in worksheet cells Formatting data Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions)... Learn about: Construction Training, MS Excel, Microsoft Excel...