Courses
This Microsoft Access 2010 training course offers a ground-up guide to form and database creation and management with this powerful office productivity tool. Narrated by teacher, author and technology trainer Robert Tucker, this beginner friendly course begins with the very basics and gradually builds to a level of professional proficiency every users should know. Starting with the user interface, the hands-on training takes you through the creation of a single table, then moves to field types and properties, creating input forms, generating reports, and all the associated functions you would expect to know in a business environment. As you move through the video tutorial, Robert even begins to cover some advanced features such as Crosstab Queries, importing data from multiple sources, join queries, and more. By the end of the MS Access course, you will be fully versed in the creation and use of Microsoft Access databases, and know how to get quickly get your data in and out.
This hands-on Microsoft Excel 2011 For Mac course shows you how to effectively use the many features and functions of MS Excel. You will learn to leverage the power of the most important features Excel 2011 has to offer the Apple user, whether you're working in an all-Mac office or needing to coordinate with PC counterparts. Beginning your training with the creation of a sheet to record and monitor sales data, you'll learn the basics of what you can do with spreadsheets. The course then moves on to creating a Profit and Loss report, building a solid understanding of formulas along the way. Moving to score sheets for a sports day, you will discover conditional formatting, lookups, and more. You then create a functional expense claim form and a sales contact management sheet, exploring how you can easily manipulate text, and even create mail merges from within Excel. Whether wanting to beef up your existing Excel skills or learn the program from the ground up this InfiniteSkills Excel course is a tremendous resource with over 50 lessons.
This Microsoft Outlook 2010 training course from InfiniteSkills provides a complete guide to streamlining email, calendars and organization within this massively popular Office program. This multi-part course shows not only how to set up the application to fit your professional needs but also how to save time by becoming more organized and accomplishing basic tasks more efficiently. The training starts with the basics of what Outlook 2010 is, as Guy leads viewers through the configuration of email accounts, email organization options, and using the program's contacts, calendar, tasks, and notes features. The course even covers connecting to a Microsoft Exchange Server, which users working within a bigger business environment will especially find useful. By focusing on professional, real world challenges and tasks, the Outlook course helps you understand its role as a critical business tool.
This Powerpoint 2011 for Mac course from InfiniteSkills provides a powerful hands-on resource for learning the world's most popular professional presentation tool. You'll go step by step through the creative process of developing compelling presentations, complete with impressive transitions and multimedia elements. The training starts with a simple presentation, with the initial planning stages coming first. You then learn how to add and customize slides slides with text and images, as well as basic animations. As the MS Powerpoint tutorial continues, you will create a professional sales presentation, adding charts, transitions and accessible slide notes. You will then explore the possibilities of a stand-alone presentation, getting more in-depth with organizational charts, animations and music. You will also create slideshows, and build a non-linear presentation with action buttons that a viewer can easily control. Working files are included to help you get started quickly with no prior experience needed.
This complete Microsoft Word 2010 training course from InfiniteSkills provides over 100 lessons on the program's powerful everyday composition tools and extended range of functionality. Whether you've been using Word for years and are wanting to take your skills to the next level or you're starting out with the program for the first time, these hands-on lessons will show you exactly what it takes to produce professional letters, documents and forms from start to finish. The Word tutorial videos begin by helping you learn where the program's essential tools are: the ribbon, the toolbar, help and other handy options. The course then moves forward to cover editing text, formatting text, inserting images, performing mail merges, proofing, printing, and more. The expert instruction puts the creative process directly onscreen. Even complete beginners will find this powerful Word training easy to follow.
MySQL is the world's most popular relational database solution used in businesses and independent projects, with thousands of new developers and users coming on board every day. Because it continues to evolve and integrate into the biggest technologies on the web, there has never been a better time to learn, and this hands-on MySQL 5 tutorial course makes it easy. With a step-by-step approach tailored for beginners, course author Jason Gilmore introduces the fundamental concepts underlying relational databases and helps you learn how to build your own functional database and manage it using standard techniques and tools. You'll get 91 lessons taking you from MySQL installation and configuration through learning and using different data types, retrieving and filtering data, working with functions, performing backup and security tasks and more. No prior experience is needed. Matching work files are included so that you can follow the course point by point through the development process.
This Apple OS X Lion Server training course will teach you how to install, configure and monitor OS X Lion Server. Whether you are setting it up for a school, home network or business, you will learn the ins and outs of using Lion Server to its fullest capabilities. The video tutorial starts with the installation basic and advanced setup of your server. You will learn how to setup and configure a DNS server and DHCP service. You will learn about managing users and groups, using Profile Manager, client preferences, and configuring services. Chris also shows you how to manage your server using Server App throughout. As you dig deeper into Lion Server, you will learn how to configure a Time Machine service, setup file sharing using AFP, SMB, FTP and more. You will setup a Mail server, web hosting, Wiki server, Addressbook server, iCal server, iChat server and more!
In this PHP / MySQL training title from InfiniteSkills, you will learn the fundamentals of PHP and MySQL. These two platforms have been virtually inseparable for many years, and major groundbreaking websites such as WordPress, Wikipedia, and Facebook use PHP and MySQL technologies. This course is designed for the beginner; no previous programming or database experience is required. Your training begins with the absolute basics, covering topics such as creating variables, working with data types and outputting them to a webpage. You will learn how to work with arrays, how to use loops and control structures such as foreach, while and if. You will learn about functions and creating classes for object-oriented programming. You will master interacting with MySQL and using SQL functions to store and retrieve data. Doug also provides in-depth lessons on how PHP and MySQL can be used to send email, work with date and time functions, use cookies and sessions, building web forms, and much more.
In this VB for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel. The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.
Learn how to leverage the power of Microsoft Word and create strong, standout documents. First take a tour of the interface, where author Chris Grover shows you where to locate the Word editing features and get information about your documents. Chris then shows you how to set up a document to your exact specifications, with the correct page orientation, size, spacing, and breaks. He also shows how to format text and add interest with photos, SmartArt, tables, and charts. Plus, learn how to collaborate with others using Track Changes and share documents via print and email.
