Do you want to learn how to build a model to track your investment property cash flow in Google Sheets? Do you want a spreadsheet model that easily matches your current bank balance ? If so, then my course on how to build a single and multiple rental property cash flow tracker is for you! --------------------- What will I learn from this course? Our “ Make a Rental Property Cash Flow Tracker” course will teach you how to use Google Sheets to make a spreadsheet that will track and summarise your investment property incomings and outgoings. In just over an hour, you will learn how to build a simple model that will list cash transactions for a single investment property and split them out into categories such as Rental Income, Loan Payments and Insurance Payments. You will also learn how to build a second model for multiple investment properties . This model will give you a bird’s-eye view of your investments, so you can easily see each property’s cash flow performance. --------------------- What is the course structure? We use the free spreadsheet programme Google Sheets to create the models, which will be automatically saved on the cloud in your Google Drive. Because this course is about how to create the models, we do not include a download of the completed models for you to copy. The whole idea is for you to enhance your spreadsheet skills by making the models yourself . Once complete, the spreadsheet will belong to you so you can use it however you please! --------------------- What topics are covered? This course uses beginner to intermediate functions and tools to build the rental property cash flow tracker models. The functions we use are SUM and SUMIF and we also do some basic calculations by using formulas instead of functions. We also use several tools such as data validation and conditional formatting to enhance the security and “look and feel” of the spreadsheet. I will also show you a few techniques I like to use to keep my spreadsheets tidy and secure such as: How to make sure my functions do not break when adding and deleting rows and columns How to name worksheets to keep functions tidy that look up other worksheets By the end of our course you should have enhanced your Google Sheets skills and you will own a fully functioning rental property cash flow tracker. --------------------- So what are you waiting for? Sign up today and learn how to make a rental property cash flow tracker in Google Sheets. See you on the course!

SO, YOU’RE LOOKING FOR A COURSE THAT WILL TEACH YOU GOOGLE FORMS QUICKLY & IN A FUN MANNER? I’ve got just the course for you! Welcome, my name is Josh Werner with Learn Tech Plus and I’ve put this course together to help people just like you quickly master Google Forms...Whether you’re a beginner or experienced with Google Forms! If your goal is to become a master of Google Forms, then this course is perfect for you. It will get you started on the right path and give you the knowledge and skills you need to master Google Forms... Learning Google Forms is Not only for Experienced users, but also everyone else. Because when you have mastered Google Forms, you can get around Google Forms quickly! In short, a good understanding of Google Forms is tremendously beneficial. Now, in this course, we'll go far beyond that. By the end of it, you'll have gained complete proficiency in Google Forms even if you're currently a complete beginner! THAT’S RIGHT...NO PRIOR EXPERIENCE OR KNOWLEDGE IS REQUIRED! You don’t need any previous experience or knowledge to take this course. In fact, all you need is a desire to learn and master Google Forms. This is not one of those courses that will throw too much at you at once and cause you to get overwhelmed. This is a course that you’ll not only learn so much from, but also enjoy the journey as you’re learning (which is a very important part of the learning process) The course will take you by the hand and teach you everything you need to know step by step and even put your knowledge to practice immediately by showing you how to setup an account with Gmail and How to work with Google Forms Application. On top of this, you will also get my continuous support as well to make sure you’re successful with my course. LEARN GOOGLE FORMS BY DOING! (LEARN TO GOOGLE FROMS APP FROM SCRATCH!) We will go step by step and cover Google Forms. The goal here is to help you A) Setup an Account with Gmail B) Be able to work with Google Forms App Here’s what we’ll cover in the course: 001. Introduction 001. Overview 02. Setup Gmail Account 002. Overview 003. Setup Gmail Account 004. Summary 03. Forms 005. Overview 006. Create Blank Form 007. Create Form with Template 008. Add Question 009. Import Questions 010. Add Title and Description 011. Add Image 012. Add Video 013. Add Section 014. Responses 015. Customize Theme 016. Preview 017. Settings 018. Send 019. Make a Copy 020. Move to Trash 021. Get Pre-Filled Link 022. Print 023. Add Collaborators 024. Script Editor 025. Add-Ons 026. Preferences 027. Summary 04. Google Apps 028. Overview 029. Search 030. Maps 031. YouTube 032. Play 033. News 034. Gmail 035. Meet 036. Chat 037. Contacts 038. Drive 039. Calendar 040. Translate 041. Photos 042. Duo 043. Chrome 044. Shopping 045. Finance 046. Docs 047. Sheets 048. Slides 049. Books 050. Blogger 051. Hangouts 052. Keep 053. Jamboard 054. Classroom 055. Earth 056. Collections 057. Arts and Culture 058. Google Ads 059. Podcasts 060. Stadia 061. Google One 062. Travel 063. Forms 064. More From Google 065. Summary 05. Project 066. Overview 067. Name Form 068. Customize Theme 069. Preview 070. Settings 071. Send 072. More Menu 073. Add Question 074. Import Questions 075. Add Title and Description 076. Add Image 077. Add Video 078. Add Section 079. Viewing Mode 080. Print 081. Question Features 082. Summary 06. Conclusion 083. Summary Enroll Now I’d love to see you inside and help you learn and master Google Forms!

New to QuickBooks Online? Get comfortable quickly by watching this 1-hour overview course. Business owners will get a feel for the QBO interface as we tour the interface. We'll explore the the Sidebar, Gear, and Create buttons so you know where to look for what you need. Alicia will demonstrate a sample daily workflow so you can see the big picture about what's involved in managing your customers and expenses. And she'll show you the top mistakes people make so that you don't fall into the same traps. This standalone module introduces concepts that are explained in-depth in our other Master QuickBooks online courses. As a QuickBooks ProAdvisor and member of the Intuit Trainer/Writer Network, I’ve assisted hundreds of small businesses to set up and troubleshoot their QuickBooks files, saving them time and money. Complete this course and earn 1 CPE Credit.

In this Course I teach you what to look for & the common mistakes that Small Business Owners make. I teach you the Accounting behind the QuickBooks Entry so You can understand how QuickBooks works and the reports it generates. What You Will Learn in this Course: >How to Identifying & Clean Up Balance Sheet Accounts >Clean Up the Chart of Accounts- Correcting Account Types >Accounts Receivable: Create Credit Memos, Invoices, Apply Payments >Accounts Payable: Apply Bill Payments, Create Credits >Fix the Undeposited Funds Account >Book Interest for Loan Accounts >Understand the Equity Accounts >Correctly Allocate personal Expenses >Bank & Credit Card Reconciliation Clean Up >Change Accounts Associated to Items >Write Off Small Balances >Identify & Fix Overstated Revenue >Merging Accounts/Vendors/Customers with same names >Inactivating Chart of Accounts/Vendors/Customers >Clean Up Uncategorized Income or Expenses >Voiding Checks from a Prior Period >Fully Understand a Balance Sheet Report

DO NOT TAKE THIS COURSE IF YOU HAVE NO JAVASCRIPT EXPERIENCE  - JAVASCRIPT IS AN ABSOLUTE PREREQUISITE!!! Next level of Google Forms, add Google Apps Script and see how your content comes to life. Apps Script is a scripting framework for light-weight application development in the G Suite platform. It is based on JavaScript with a collection of methods and helpful classes that can really power up your Google Suite. Just like JavaScript - If you know JavaScript you know Google Apps Script. BONUS - Free downloadable course guide with resources and source code. Step by step learning! Source Code is included in addition to a helpful lesson guide which outlines step by step how to apply Google Apps Script to your own project. Everything you need is included in this course. Explore how to setup a form sending data to a Google Spreadsheet Explore how to add Google Apps Script to any Google Spreadsheet.   Open the Google Script online editor and begin coding. Customize the code - retrieve the form information. Setup a trigger to run code once the form data is received. See how you can add advanced functionality like sending emails all via Google Apps Script Explore how data is received in object form, iterate the object data and send it to an email address Put it all together in a live working application that picks up form submission data and send you a notification email. Send a response email to the user who submitted the form. Use the form data and send responses This is the perfect starter project to get started with Google Script and build upon the project to create your own custom functionality. Source code is included to try the code for yourself Create a starter project which you can use extend and do some really amazing things with. Course is taught by a web developer with over 18 years experience and 4+ years working with Google Apps Script. Fast and friendly support is provided in the Q&A section. See what you can do - you have nothing to lose make your own Google Apps Script project today.

Master Google Docs & Sheets, as well as supplemental Apps in the G Suite including Google Drive and Slides, and learn to use these tools to improve your business, market yourself as a professional, and collaborate effectively on cloud based projects. Over 1000 students are enrolled in this course to date, highlighting the demand for excellence in the area of G Suite, Google Drive, and cloud based software and competition in general. With more companies headed to G Suite's solutions everyday, being an expert in these apps has become a necessity for professionals. Major corporations and even Universities have been making the transition from local network drives office software to Google Drive and the G Suite apps. This has driven the demand for extensive training on G Suite. This course is designed to teach you to use Google Docs & Sheets as well as Google Drive to their maximum potential for personal use or for within your organization. We will cover the basics of constructing documents within each of the apps, and to do so we will be using mock Business Plans, P&L Statements, and Balance Sheets so that you can gain business application for each of these. Though, if you're just learning for personal use or school, these exercises will teach you to master the apps for whatever use you have as well. We will also learn to collaborate effectively within each app using the tools that Google provides us with. This is an excellent course for anyone from an individual just looking to become proficient, to the entrepreneur looking for more effective and efficient business solutions, to someone who works within a large organization that has moved to using Google Apps exclusively, as many have, and just needs to catch up. In this course, you will: Learn to use Google Sheets as effectively as you use Microsoft Excel or other spreadsheet solutions Master Formulas Put together complex P&Ls, Balance Sheets, and other forms that you use Spreadsheet solutions for Use Tables, Charts, Forms, and Sorting tools Learn Spreadsheet Terminology & Shortcuts Use Templates, Images, and Hyperlinks to polish your Spreadsheet Documents Sort & Interpret Data Effectively Learn to use Google Docs as effectively as you use Microsoft Word or other word processing software Build professional documents using Google Docs, to include Business Proposals, Executive Summaries, and learn to locate thousands of templates on Docs to save yourself time, and make your Business stand out Master the Formatting Tools of Google Docs Use Images, Tables, and other Tools to Polish your Google Docs Learn to use Google Docs & Sheets to collaborate effectively within your business or organization, as well as on external projects. Google Apps afford businesses a wide variety of resources that would otherwise be rather costly. Consider, for example, what you pay for office suite software on every company computer, and then the storage space you have to maintain on both local drives and servers. Google Apps provides a free, cloud based office suite, and up to 30GB of free storage per user. Storage can also be increased as needed at very affordable rates. As of this course posting, you can get an extra 100GB for $1.99 per month, a full TB for $9.99 per month, or you can switch to unlimited storage with G Suite for Business at $10/month per user. Why wait? Enroll in this course risk free, and start to Master Docs & Sheets TODAY!

Uncover The Many Benefits of QuickBooks Pro 2016 and QuickBooks Pro 2017 Have more control over your accounting needs Instantly create accurate estimates, statements, and deposits Quickly keep track of incoming and outgoing payments Receive tools to help you run an effective business Reconcile bank statements with absolute ease and more Use This 2-in-1 Bundle to Quickly and Effortlessly Manage Your Accounts Having an accurate set of books is vital for business. You should always want the right data and the right records because anything inaccurate or disorganized can make it very difficult to file your taxes, or worse, get you in big trouble. Using our easy-to-understand courses on QuickBooks (both the 2016 version and 2017 version), will help you avoid common mistakes that even some of the most elite entrepreneurs tend to make. QuickBooks is by far one of the world's most popular accounting programs. But it comes with hurdles. That's why we're bundling our courses so that you can master older and newer versions and really get the hang of it. You'll essentially be getting a comprehensive crash course on data reporting, organizing accounts, measurement methods, incoming sales, payroll, payment cycles, and more. Our goal is to provide in-depth information so that you can tailor your accounting system to meet your needs.

This will ensure that businesses and individuals manage revenue profitably but legally. Because as the economy stabilizes and new federal financial regulations are introduced, accountants knowledgeable with QuickBooks will be increasingly necessary to the management and oversight of capital - and long-term growth. So, if you're a small or medium sized business owner, or even a freelance accountant, you can use our bundle of QuickBooks Pro 2016 and 2017 to keep track of everything. From accounts payable, down to receivables, and monthly debts. All of this is packaged in our unique and informative bundle to help you feel ultra confident. Overview and Contents With the content, and easy to follow steps found inside, you'll become a master with QuickBooks. You'll get extremely helpful tutorials, too. Tutorials teaching you about the core fundamentals behind using this special accounting software.

Once you get set up, you'll discover the inner health of your business. QuickBooks gives you many indicators and lengthy reports to determine which direction your business needs to take in order to grow in the coming year. Whether you're advanced with QuickBooks, or you're a complete newbie that needs more practice, this is the right deal for you. Our 2-in-1 bundle shows you how to handle it all, without getting a massive headache. Great for those who love numbers and is looking for an organized method to doing their books. At the completion of these courses, you will receive a certificate, as you will have grown your accounting skill-set. And be fully prepared to use QuickBooks Pro 2016 and QuickBooks Pro 2017 for every single one of your business needs. Here’s what our students are saying… “Nice and complete overview of QuickBooks. Makes  learning QuickBooks much more approachable and manageable, then  learning it on your own. This is a great and cheaper alternative than  taking a more expensive course. Definitely recommended if you want to  learn QuickBooks and have no idea where to begin.” – Armanda Lopez "Great  class. Learned a lot about QuickBooks. I enjoyed taking this QuickBooks  class. The instructor was very clear and easy to understand.” – Maureen Carless “Vou can't teach an old dog new tricks. I have been using QuickBooks for over 10 years and I still found this course very helpful. Great choice of  voice, perfect pace and breakdown of content. Thank You..” –  Travis Tandy Did you know? Simon Sez IT teaches all sorts of software, including: - Microsoft Excel - Microsoft PowerPoint - Microsoft Word - Microsoft Project - Microsoft Outlook - QuickBooks - Photoshop Elements - Web Development Languages - And so much more!

Have you always wanted to know how much interest you can save by making extra loan repayments ? Do you want to learn how to build a spreadsheet model in Google Sheets to do exactly that? Do you want to learn how to use intermediate functions such as EDATE and INDEX/MATCH? If so, then this course is for you! --------------------- What will I learn from this course? In just over an hour, our “ Make a Loan Calculator with Extra Repayments” course will teach you how to make a spreadsheet that will show you how much a loan will truly cost over time with and without extra repayments. During the course, you will learn how to use the PMT function to calculate the regular repayment amount for a standard loan. You will then learn how to create a basic amortisation schedule so you can see how the numbers work over time. Then, we will add extra functionality to the model to allow fixed or variable extra repayments . We will then build a summary table that will show you the “magic number” of exactly how much interest you will save by making extra repayments. This is the number you’ll want to see! --------------------- What is the course structure? We use the free spreadsheet programme Google Sheets to create the models, which will be automatically saved on the cloud in your Google Drive. Not only will you grow your spreadsheeting skills, you will end up with a model that will belong to you so you can use it however you please! --------------------- What topics are covered? This course uses beginner to intermediate functions and tools to build the loan calculator with extra repayments model. The functions we use include SUM, PMT, EDATE and INDEX/MATCH and we also do some basic calculations by using formulas instead of functions. We also use several tools such as data validation to enhance the security of the spreadsheet. After you have completed this course you will have expanded your Google Sheets skills and you will own a fully functioning model. --------------------- So what are you waiting for? Sign up today and learn how to make a loan calculator with extra repayments model in Google Sheets. See you on the course!

Do you work with charts but struggle to identify which chart to use? Are you new to data analysis? Do you want to learn about the charting options Excel 2013/2010 offers? Are you looking for a structured way to learn about the Excel charting tools? If your answer was YES to some of the questions, this course might be of interest to you. When I created this course I put full emphasis on a structured and didactically sound way to gently show you how data visualization in Excel 2013 works. This course is especially suited towards a beginners audience to data visualization with Excel. Most of the concepts of this course also apply to Excel 2010, so you might also consider this course if you are on 2010. Beginners to data analysis often need a clear understanding of which chart type is suitable for a given dataset. I will give you this important knowledge right at the beginning so that you know from the start what you are dealing with and how you can utilize that knowledge. I will also show you step by step all you need to know about the basic chart formatting tools. You will learn how to add elements, format axes, change colors and so on. There is also a section about the frequently used types of charts and how you can easily create them in Excel. At the end of this beginners course you should be confident in using Excel for standard charts. You will be also able to format already existing charts and tailor them in accordance with your needs. I highly recommend to take a close look at the introductory videos on which type of chart to use for a given circumstance. Only if you know which chart type is suitable for a dataset will you be able to make full use of the many options Excel has to offer.

This course is an introduction to Microsoft 365 Sites. Upon completion of this course, users will have a basic understanding of Sharepoint Sites and Sites structure, navigation, libraries, searching, newsfeeds, views, permissions, and organization. Students will learn the differences of Libraries and Lists and how to create different kinds of Libraries and Lists, add files to Libraries, add items to Lists, learn to use the Newsfeed to keep abreast of action on the site, and create and customize Views. In addition, students will explore Site and content organization, understand navigation of sites, search for content, and learn the basics of Permissions. This IAAP-certified counts for 2.5 recertification points for the CAP certification under the Technology and Information Distribution content area. With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.