This course focuses on networking features and functionality available in Windows Server 2016, such as DNS, DHCP, and IPAM implementations. We will review remote access solutions, such as VPN and Direct Access. Additionally, this course will look at DFS and BranchCache solutions, advanced network features and functionality, and understanding of software-defined networking.
This program is part of the New Management Fundamentals Series. The overall goal of this program is to enable managers to learn and apply a practical approach to managing the performance of employees in a way that will achieve organizational results while enhancing the development and engagement of employees. Our performance management process is designed to get past the traditional annual performance plan and presents tools, templates and skills that reflect the current reality managers are facing -- dynamic, fast moving, complex, team-based, and cross-functional. Learners will complete each stage of the process, understand the management skills required to put it into practice as well as identify future opportunities for development.
This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.
In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.
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.
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.