Master Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video Course Easily learn Excel 2016 for complete beginners How to get Excel and installation requirements Helpful discussion of new features in 2016 Getting started with a Workbook Entering and editing data Creating charts and graphs How to create functions Protecting and securing your data All lessons in easy step-by-step format Practice with included exercise files Excel 2016 From The Beginning This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you from the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you're using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business. If most Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each process. Contents and Overview This course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 32 chapters of video lessons and 9 exercise files to gradually become a proficient user. It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them. Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more. Upon completion of this course you will know the essentials of Microsoft Excel 2016.
Discover The Many Benefits of This Popular Accounting Program Have complete control over the accounting of your business Quickly create estimates, statements, and deposits Effortlessly keep track of incoming and outgoing payments Get all of the tools to become a well-run operation Feel confident when reconciling bank statements Use This Course to Learn How to Manage Your Accounts Without the Headaches No matter what your business does, and regardless of what market it's in, keeping an accurate set of books is essential. You should always want accurate records on hand. Why, you ask? Because inaccurate or disorganized business records can make it very difficult to file your taxes, or worse, get you in trouble with the Internal Revenue Service. Using this easy-to-understand course on QuickBooks, however, will help you avoid any type of common pitfalls or mistakes. As you know, QuickBooks is one of the most popular accounting programs available and is used with small businesses pretty much everywhere. You'll essentially be getting a comprehensive crash course on information flow, reporting, systems, accounts, income measurement methods, sales, payroll, banking cycles, and much more. That's why this course was created. To provide in-depth and industry specific information so that you can tailor your accounting system to meet your needs. So, if you're a small or medium sized business owner, or even a freelance accountant, you can use QuickBooks Pro 2016 to keep track of everything. From accounts payable, down to your receivables, expenditures, debts, and payments. All of this is packaged to make you feel confident and to help you maintain order as far as your financial situation goes. Overview and Contents With all of the course's content, this QuickBooks Pro 2016 tutorial will teach you about all of the important requirements and valuable fundamentals behind using this accounting software. Once you get set up, you'll quickly find out how you're business is doing. QuickBooks gives you multiple indicators to determine the health of your business and produces reports for you that makes sense of it all. Whether you work as an entrepreneur just trying to finish up some last minute paperwork, or you're a freelance accountant wanting to get more done in less time, QuickBooks handles it all. Its streamlined workflow helps you from beginning to end. This course was created for people that see the advantages of QuickBooks and want to learn how to use the latest version. Designed from the ground up for ease of use by both small business owners and professional accountants alike. Perfect for those who are looking for a comprehensive and organized method to doing their books. At the completion of this course, you will have advanced knowledge, and skills, and be fully prepared to use QuickBooks Pro 2016 for every single one of your accounting needs.
Save Time and Money by Learning This Popular Accounting Program Manage the Accounting for Your Own Small Business Create Estimates, Statements, and Deposits Keep Track of Payments and Bills Reconcile Bank Statements Manage Your Own Accounts With this Popular Program QuickBooks is a very popular accounting software package, used in small businesses throughout the world. It was developed and marketed by Intuit, and originally released in 1994. Over the course of its history, many convenient features have been developed, including the addition of QuickBooks Online, a subscription service that can replace the outright purchase of QuickBooks software, and QuickBooks Point of Sale, which is meant to replace a business's cash register and keeps track of sales receipts. If you are a small business owner, or a freelance accountant, you can use QuickBooks to keep track of accounts payable, receivable, to pay bills, to keep track of payments or debts, and to maintain organization in terms of your business or personal finance. Overview and Contents Over the course of 75 video lectures and more than seven hours of content, this QuickBooks Pro 2015 tutorial will teach you all of the necessary fundamentals of this popular and comprehensive accounting software. You will learn how to install and set up the QuickBooks software, beginning with creating a file for your company. With this basic knowledge, you can move forward to developing a chart of accounts, creating estimates and invoices, and organizing a variety of financial statements. By the time you reach the end of the lectures, you will be a skilled QuickBooks Pro 2015 user, able to complete the most necessary accounting tasks all in one organized program. This class is perfect for accountants or small business owners who are looking for a comprehensive and organized method for doing their books. At the completion of this course, you will be fully equipped to use QuickBooks Pro 2015 for all of your small business accounting needs.
Discover the Powerful Features of This Popular Program Have complete control over your presentation's information Now have professional presentations for job or project Quickly create top-notch visuals for your audiences Feel confident and show off your new powerful slides Get all of the new tools to master presentation management Effortlessly add text, graphics, audio, video, charts, tables and SmartArt to your slides 6 hours of professional video with over 70 individual lessons that make everything clearer and easy to remember Practice what you learned with included exercise files Use This New Course to Easily Create Beautiful Presentations PowerPoint 2016 is by far the most popular presentation program in the world as it allows users to create, edit, and show illustrative presentations with the help of attention-grabbing slides. This crash course explains how you can combine the text, 3-D graphics, and multi-media to support your presentation-making needs. Using PowerPoint as a presentation tool is the way to go. Do you need some visual impact? Well, look no further. Because this course can show you how to take this program and make it do just that. In fact, making your presentation more interesting through the use of multi-media can only help improve your audience's focus. PowerPoint 2016 allows you to use your choice of images, audio clips, and videos to help you get your points across. These important sound effects and visual cues can also help a presenter like yourself, be more improvisational, and interactive, all of which is a very beneficial thing. This course essentially shows you why PowerPoint 2016 is the best and most complete presentation package available. It gives you 80 individual video tutorials that are quite in-depth. It also has exercise files so that you can practice the lessons you've learned. Everything you need is here so that you can learn how to produce a nice and professional-looking presentation. Once everything is finished, you can begin to prepare your talk. In fact, even if it went well but someone missed your presentation, you could still have them view it online at a time that's convenient for them. Simply upload your presentation to YouTube with everything featured in your work, including all of the slides, commentary, and transitions. So, whether you need processing, outlining, drawing, graphing, or more elaborate presentation management tools - it's all covered in this easy-to-understand course. You can not only create and modify your own presentations, but gain mastery on it eventually, too. All that is needed on your part is a little practice. Overview and Contents PowerPoint 2016 can be used in a number of different yet effective ways to communicate with your audience. Slides are completely customizable. Depending on your approach, you may want to have a presentation that's text-heavy, image-heavy, or some combination of both. Combining the two tends to give your listeners the benefit of both visual aids and notes all at the same time. PowerPoint 2016 also comes with many new features such as the brand-new transition type, Morph, that can help users make animations, transitions, and object movements across your slides. Pretty neat, right? This course covers that and so much more. It also shows you how to make presentations with alternative forms, styles, and custom layouts which are used by working professionals, teachers, students, medical practitioners, politicians, and countless others. They see the value in this unique course on PowerPoint 2016 as they want to know how to use it to quickly showcase their information and data. Perfect for those who are looking for a comprehensive and organized method to presentations. Great for those that want to add value to lectures, make more compelling speeches, or enhance studies and reports. So, what are you waiting for now? If you want to learn how to use the latest version of PowerPoint, then this is for you. At the completion of this course, you will have more knowledge, better skills, and be fully prepared to use PowerPoint 2016 for every single one of your complex presentation needs.
Everything you need to turn ordinary photos into impressive masterpieces Whopping 15 Hours of Expert Instruction More than 120 Individual Video Tutorials Course starts right at the very beginning Everything is explained in clear detail Full coverage of basic functions in Photoshop Elements 14 How to use Photoshop Organizer efficiently Where to get great content Printing your photos so they look professional Working miracles with the Editor Speeding your projects with Quick Mode Practical retouching and enhancing techniques Includes exercise files to practice what you’ve learned Adobe Photoshop Elements 14 For Beginners We've all seen amazing photos of models, natural scenes, and events that look absolutely perfect. Somebody will say "It's been Photoshopped!" Now you can have the advanced skills required to use Photoshop Elements 14 like a pro. This big 15 hour course starts right at the very beginning showing you how to download the software and get it going. Then we carefully walk you through each and every step toward becoming a true Photoshop power user. Use these skills for your job, your hobby, or even start a new business. Many Photoshop courses are designed for people who have some experience using the application. While this course will be very useful to students with experience, it was designed for the person who has never worked with Photoshop before and knows nothing about it. Contents and Overview This course starts right at the very beginning with how to get PSE14 and install it. We review what is different in Elements 14 so those who have worked with the previous version can fast forward to the new functions they need to understand. In Chapter 2 you learn start up, the all important keyboard shortcuts that will greatly speed your work, and how to get answers using Help. We also set up your preferences so you can customize PSE 14 for your use. Next you learn how to use Quick Start. That is the perfect way for the beginner to see impressive results. This includes an exercise where you create a slide show worthy of a professional presentation. Next we learn the many functions of The Organizer including catalogs, media browser, timelines, instant fix, image properties and much more. We cover Acquiring Content and Printing before getting to the heart of PSE 14: The Editor. This is where you learn how to create a workspace and manipulate your content for desired results. Later we look at editing in Expert Mode. Along the way we study the often used Quick Mode where you can instantly remove red eyes, add effects, textures, frames, and auto smart tone. As you progress we study Guided Editing where you resize photos and perform guided edits on image properties. Later we work on filters, lighting, adding text, text effects, color effects and much more as we advance through the massive 15 hours of instruction that take you through every detail of Photoshop Elements 14.
Master Excel's Powerful Data Functions in this Information-Packed 9-hour Video Training. Personal and Professional Financial Functions Statistical Functions for Description, Prediction and Interference Connecting to External Data Tables, Charts and Pivots Data Analysis The Versatility of Excel If you have already been using Microsoft Excel then you know that the calculation, graphing and tables available help you track, manipulate and report important data. There is more to excel than a few SUMs, though, and this is the training course to get you into the advanced uses of Excel so you can really use the data and numbers you are tracking to your advantage. This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2013 or previous software versions to this class and learn how to reach the next level of database tracking and reporting. Contents and Overview Through 52 lectures, this course will take you through learning how to use functions in everyday work environments. Personal and professional financial functions are covered including payments, future value and depreciations. Students will learn statistical functions like averages, percentiles, and regression. In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment. For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs. Lastly, students will cover important web applications. Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with strategizing and planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.
With the newest version of Microsoft’s word processing software, Word 2013, you can do more than ever when it comes to creating high-end, professional quality documents. In this Learn Word 2013 video training course, our expert instructor will walk you through the exciting new features of Word 2013. Throughout this 9-hour class, you’ll learn the most effective ways to create sophisticated documents along with valuable time saving tips. Starting with the basics, you’ll discover the many new templates Word 2013 has to offer as well as new ways to work with media. You’ll learn to add pictures directly from the internet (without saving them on your computer!) in addition to inserting online videos and watching them inside Word. Next, you’ll see how easy it is to open and edit PDFs, and to align your graphics perfectly. Your instructor will also introduce you to the program’s features that make viewing documents more convenient such as read mode, resume reading, object zoom, and collapsible headings. Finally, you’ll learn how set-up your documents for collaboration using SkyDrive, Simple Markup, and the comments feature. Whether you need to create compelling reports, persuasive sales letters, or polished proposals, our in-depth Word 2013 tutorials will give you the skills you need to make a good impression on any audience.
With the newest version of Microsoft’s presentation software, PowerPoint 2013, you can do more than ever when it comes to creating expertly designed slideshows. In this PowerPoint Training: How to Use PowerPoint 2013 course, our professional instructor will walk you through the exciting new features of PowerPoint 2013. Throughout this 9-hour class, you’ll learn the most effective ways to create polished presentations along with valuable shortcuts and tips for saving time. Starting with the basics, you’ll discover how to work with the colorful new PowerPoint 2013 templates and to design your own backgrounds from scratch. Then, you’ll learn to add images, hyperlinks, audio, and video for engaging slides and attention-grabbing animations. As you then learn to merge shapes, maximize smart guides, and use motion paths, you’ll master custom icon creation and accurately aligned graphics. Finally, you’ll see how to take your presentations to the cloud as you learn to save your work online and to publish to the SkyDrive. Don’t let technical difficulties get in your way. Prepare for every meeting by learning to size presentations in standard and wide screen layouts, and to run them on the web or via smartphones. From 10 minute slideshows to lengthy presentations, this PowerPoint 2013 training course will give you the tools you need to share your story effectively. Even if you’ve been making presentations for years, our tutorials will give you the inside scoop on new PowerPoint 2013 features that will take your work up another notch. Your presentations will look better than ever!
Time is money. That’s why the more you get done, the more you’re worth! Microsoft Outlook 2013 helps you achieve more by simplifying email and contact management challenges. Used in many businesses, Outlook’s calendars, search options, contact tools, and email design features make it easy to create visually appealing messages and to keep up with everyday duties. In our Learn Outlook 2013 video training course, you’ll learn the secrets of super-star productivity. During 7 information packed hours, our expert instructor will guide you on maximizing Outlook’s email, contacts, tasks, reminders, and calendar functions. Learn to shave time off tasks with the preview messages in a list and custom workspace options. Utilize inline replies and Lync IM real-time chats for lightning-fast response times. Assign commands to messages by flagging and adding comments directly inside your message list. Set-up one-time or recurring appointments and upload attachments to the calendar. Keep your contact details in one central place by taking advantage of the People Card. And master the program’s Exchange and SharePoint features so you can give your team access to shared calendars and task lists. It’s a simple way to get organized so you can start getting more stuff done!
During this QuickBooks Pro 2014 video training course, learn to use QuickBooks to manage your business's finances. Your certified QuickBooks Pro Advisor trainer will show how to create accounts to organizing customer, vendor, and item records. Discover how to setup QuickBooks Pro 2014 for the first time, pay employees, create reports, reconcile, work with sales tax, setup inventory, receive payments, and much more. This course is designed to be an introduction to the features offered by QuickBooks Pro 2014. This is not an accounting course. Each business and home financial situation is unique, with different procedures required in response to various rules, laws and policies. Please consult your accountant, employer, QuickBooks Pro Advisor or other appropriate expert with regard to specific requirements or guidelines. Course goal and objectives: Creating your company file Working with QuickBooks preferences Creating estimates Setup the chart of accounts for your business Working with customers and jobs Entering and paying bills Reconciling bank statements Working with loans Using reports to provide you the information required
Learn the essentials of Microsoft Windows 8 with this online training program. Discover how to access apps and accessories, and how to change various applications and settings. Learn to navigate the Windows 8 interface, including the Start screen, using Charms, Live Tiles and accessing the desktop. Gain practical knowledge for connecting your Windows 8 device to a network. Learn how to take advantage of Windows 8 various multimedia applications for music, video and digital photos. Discover great tips and techniques for personalizing Windows 8 for your own specific needs, internet safety and security. Learn how to manage user accounts including adding users and changing passwords and much more with this online course. Benefits of this training course: By the end of this course, you will have practical knowledge of using Windows 8 Learn how to add your computer to network. Learn how to navigate the Windows 8 interface. Discover how to access the Control Panel and manage Windows updates. Learn practical tips for Ease of Access. Manage user accounts including adding users and changing passwords. Discover how to manage the various security options for Windows 8. Audience: Those new to Windows 8, or upgrading from previous versions of Windows.
Want to create print-ready documents that look like they were done by a graphic designer? You can! Event invitations, holiday cards, brochures, and flyers are all a snap when you discover the tricks of high-end desktop publishing in our Learn Microsoft Publisher 2013 course. In this 6.25-hour video training course, you’ll get the tools you need to add your unique touch of creativity to any kind of document. To kick things off, your expert instructor will help you explore the Publisher interface and get comfortable with navigating your way around it. Next, you’ll discover how to delete and add pages, and how to move pages around when you want to change your document’s order. Videos on paragraph formatting, working with columns, and using fonts will then teach you to make an impact with your text. You’ll learn to do this with images, too, as you learn techniques for adding cool effects—textures, gradients, shadows, and more—to your visuals. By the time the class is done, you’ll have mastered the process of preparing your Publisher project for professional printing or for publication on the internet. Benefits: Setting up new publications Graphics and visual effects Patterns, gradients, and textures Importing text and creating styles Column and paragraph formatting RBG, CMYK, and Pantone colors Inserting tables Mail merges Preparing for the print house Audience: Users new to Publisher 2013 and those upgrading from previous software versions
Learn Word 2010 by Simon Sez IT, is a 6.75 hour online training course ideal for those new to Microsoft Word or anyone looking to enhance their Word 2010 skills. The video training program covers the basics of using this essential word processing tool to more advanced topics. You will work your way through nineteen chapters, each one adding to the previous, for a comprehensive understanding of Word 2010 and all it has to offer. Starting with creation of a new document, saving, and formatting your document, you will learn about the Ribbon, tabs, and groups and how you can even create your own. Discover the capabilities of the new Navigation pane, including search, find and replace, and how to organize your work by dragging and dropping. Next, you will learn about templates, text and paragraph formatting. Learn how to effectively add tables and charts and how to use the new enhanced picture tools to make your graphics compelling. You will be able to add screenshots from within the program itself, and use WordArt and SmartArt to create truly professional documentation. Discover how to create a Table of Contents, an Index, and a bibliography in the style you choose, such as APA or Chicago Style. You will experience the creation of web documents and publishing to a blog with this training course. Benefits of this online training program: Learn the workspace and overview of the features in Word 2010. Discover how to insert tables and use them to best effect. How to publish and access web documents and how to publish directly to a blog. How to use the mail merge Wizard and how to manually setup a mail merge. Customize Word 2010 to meet your needs and the way you produce documentation. How to import and export and how to embed documents. Audience: Those new Microsoft Word, or those upgrading from previous versions of Microsoft Office.
Are you new to Microsoft Project 2010? Do you need to learn how to use Microsoft Project and keep track of all your projects? During the Learn Microsoft Project 2010 video training course, your professional trainer guides you through project management topics such as task creation, resource management, cost tracking, using WBS codes, critical path reporting, and more. Ideal for those seeking Microsoft Project 2010 training or anyone looking to enhance their Project knowledge, the Learn Microsoft Project 2010 training course provides 9 full hours of expert quality training videos. Discover the building blocks of a project. Start with information gathering and documentation, and when you feel comfortable with that, move on to the basics of tasks and resources. Get detailed step-by-step guidance on how to assign and allocate resources. Learn to document a project as you go by properly defining costs and adding notes—enabling full traceability and much more with this online training program. Benefits of this online course: Efficiently use schedules, calendars, and critical paths. Explore cost management features such as defining/tracking costs and reporting options. Use tools to plan, manage, and collaborate with other people and teams. Customize your workspace. Track using the resource calendar, task types, and budget resources. Get proficient at over allocations and leveling Audience: Project Managers and other business professionals who need an introduction to Project 2010 or are upgrading from a previous version of the program.
The Learn Microsoft Project 2010 - Advanced training is built around simplifying your life and helping your project succeed. This training course is a continuation of the Learn Project 2010 Beginners/Intermediate training by Simon Sez IT. Ideal for those seeking to enhance their Project knowledge, this training course provides 8 full hours of expert quality training videos, consisting of 10 chapters and 37 concise videos. Project planning is an art. There is so much to it: coordinating, scheduling, calendaring, organizing, budgeting, costs, resource management, etc. Without the right tools, it can become overwhelming. That’s why, in this training course, your trainer will present the advanced project management features Microsoft Project has to offer such as critical paths, scheduling, and calendars. Get motivated to become organized in delegating and tracking tasks, assigning resources, and putting the budget on paper and tracking its details. Learn the value of defining costs up front—baselining the costs so you can track them. Evaluate the project as you go from a detached view to determine resourcing problems. Understand how to assign, level, and divert resources so you can overcome resource problems to keep the project moving forward. The time invested in this online course is invaluable because you’re taught the macro and micro view of a project and how to track it all. Discover how to divide a project into parts and combine them when necessary. Learn how to create links and dependencies between projects and share resources. And discover how to maximize critical tools: customization, macros, views, VBA, writing code, creating new macros, importing and exporting and much more is covered under this training program. Benefits of this online training course: Consolidating multiple projects. Tools for resource types and defining costs. Discover how to use and customize reports. How to assign, level, and divert resources to overcome problems. Delegation and tracking of tasks. Audience: Project Managers and other business professionals who are familiar with Microsoft Project 2010 (or previous versions) and are looking to deepen their knowledge with more advanced skills.
Learn Outlook 2010 by Simon Sez IT is a 5-hour online training course consisting of two chapters: Chapter 1 is geared towards the basics of the program so you can get up to speed using Outlook 2010. Get started opening the Outlook client, then configure your email accounts and discover how to use contacts. Learn to use tasks, to-do lists, the workspace, the Ribbon, notes, appointment scheduling, calendars, reminders, and journals. Chapter 2 takes you beyond the basics. It introduces you to more advanced Outlook options such as customizing the workspace and creating groups, PST files, email rules for inbox management, and folders. You’ll then go through formatting emails, attachments, signatures, themes, and stationary. Before wrapping up, you’ll get a comprehensive breakdown on completing tasks, delegating tasks to others, security, phishing, managing junk mail/spam, filtering, searching, archiving, cleanup, and more with this training course. Benefits of this online program: General overview of Microsoft Outlook 2010. Customize the Quick Access Toolbar and the Ribbon. Learn how to change views and personalize appearance. See different ways of working with tasks: add items, creating reminders, update, flag, and categorize. Configure multiple email addresses by adding new accounts. Discover differences/similarities with the workspace of each core module: mail, calendar, contacts, tasks, and notes. Create rules for incoming or outgoing email messages. Attach files to your email message. Audience: Anyone new to Microsoft Office or upgrading from an older version of MS Office.
Ideal for those seeking to enhance their Excel 2010 knowledge, the Learn Excel 2010 – Advanced by Simon Sez IT is a 7-hour training course covering advanced level Excel topics. Microsoft has added very powerful tools to Excel over previous versions. Understanding these tools will save you time and energy combing through information. Learn how to create eye-catching charts and graphs (formatting axes and gridlines, showing basic trends, complex trends, even trends over time). Learn the differences between the various types of charts, relationships in data, and ways to show differences. Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. Excel’s tools are covered in depth which includes discussions on and are setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. You can move columns and rows to understand how the numbers relate more easily than ever before. Finally, once you have analyzed the data you will need to share it; ascertain the method for exporting charts and graphs for the best presentation. Benefits: Four basic steps to consider when creating charts and graphs. How to better format your charts and graphs like professionals do. Discover how to deal with complex trends in your charts and graphs. Learn how to use a bar chart and a pie chart to accentuate the differences in a data set. Discover the tools and options for exporting your charts and graphs. Discover the limitations of pie charts and the best way to correct them. Learn how to use Pivot Tables and Pivot Charts. Learn how to integrate graphics into your spreadsheets. Audience: Those seeking advanced Excel training
Learn Microsoft Access 2010 by Simon Sez IT is a 7-hour course filled with all the information you need to create, design, and customize high-performing databases. Your professional trainer will introduce you to Microsoft’s “Ribbon” interface, showing you tips and techniques to leverage its features for more efficient database management. Discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier. Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting—as your instructor gives you easy to understand methods for working with reports. Before the “Microsoft Access Training: Microsoft Access Tutorial” course is over, we’ll cover all key areas of the program: custom queries using defined criteria, select queries, updating queries, appending queries, deleting queries, inner joins, outer joins, table queries, and mail merges. Benefits: Learn the Access 2010 interface including the Backstage View, Ribbon Features, and Quick Access Toolbar. Explore the fundamentals of a database including records, fields, table objects, relationships, and primary keys. Discover techniques for creating forms that present data in a visual way. Understand and set-up the expression builder. Filter data in single and multiple columns in tables and forms. Learn how to create reports. Discover how to improve your report design, add existing fields, and how to group and sort right on the report. Learn how to update the database quickly using update queries, append queries, and delete queries. Audience: The course is intended for anyone new to database concepts and wishing to use Access 2010.
Ideal for those seeking to advance their careers by developing top-notch database skills, the Microsoft Access Training: Learn Microsoft Access 2010 course by Simon Sez IT provides 8 full hours of expert quality training videos. Learn Microsoft Access 2010 - Advanced takes the seemingly overwhelming concept of advanced database management and breaks it into several easy to understand, detailed chapters. A general understanding of previous versions of Microsoft Access will make this Microsoft Access Training: Learn Microsoft Access 2010 course comfortable and will be a great base from which to build. Beyond just getting data into the database, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine—in terms of how they look on paper and the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases. Benefits: Execute a set of defined actions and learn to create and modify macros. Identify best practices for naming objects in an Access 2010 Database. Learn to collect data from external sources. Distinguish the difference between Word and Excel macros, and the macros and VBA programs that are a part of Access. Learn best practices for setting-up a new database. Using VBA for robust error handling and making a handy switchboard. How to best use the multi-user aspects of Access 2010. Audience: Intermediate level Access users.
During this QuickBooks Pro 2013 video training course, learn to use QuickBooks to manage your business's finances. Your certified QuickBooks Pro Advisor trainer will show how to create accounts to organizing customer, vendor, and item records. Discover how to setup QuickBooks Pro 2013 for the first time, pay employees, create reports, reconcile, work with sales tax, setup inventory, receive payments, and much more. This course is designed to be an introduction to the features offered by QuickBooks Pro 2013. This is not an accounting course. Each business and home financial situation is unique, with different procedures required in response to various rules, laws and policies. Please consult your accountant, employer, QuickBooks ProAdvisor or other appropriate expert with regard to specific requirements or guidelines. Course Goal and Objectives: Creating your company file Working with QuickBooks preferences Creating estimates Working with vendors and bills Setup the chart of accounts for your business Reconciling statements Working with credit cards Working with sales tax including paying sales tax Working with payroll Working with customers and jobs Intended Audience: Small business owners or those managing QuickBooks for a small business