Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros. This advanced video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same files the author trains you with.
This Advanced Microsoft Access 2010 Tutorial Video picks up where the InfiniteSkills beginner course leaves off and shows how to work with some of the program's more robust database creation and management features. Presented by a professional IT trainer, the video lessons go point by point through advanced query options and form design, as well as a number of shortcuts and productivity options that can simplify and shift the way you work. Given the advanced subject matter, the order of the Access course is logical and easy to follow. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and sub queries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data, and the course's full chapter on Macros make it easy to manage and access data in Access 2010. Project files are included to match the examples onscreen.
Join author and business coach Dave Crenshaw as he shows you the keys to becoming a respected thought leader and authority in your field. Whether you're already a visible professional or hoping to improve your presence, decision-making ability, and influence, this course can prepare you to take a meaningful step forward. Being recognized as a thought leader and authority inside and outside your company builds career capital and paves the way for new opportunities. This course demonstrates a step-by-step process to help you identify your thought leadership focus, find a mentor, develop expertise within your company, build a meaningful network externally, and develop personal publicity.
In this course, Dr. Patrick Crispen teaches the ins and outs of Blackboard 9 so that educators and trainers can get up to speed in the system quickly—even if they've never used Blackboard before. The course explores customizing a course site, managing users, and adding and organizing content, including multimedia. It also shows how to perform student assessments in the Grade Center, as well as how to communicate with students and encourage participation and collaboration.
In Blackboard 9 Essential Training for Students, Dr. Patrick Crispen shows how to get up and running on day one of class and start finding and logging into courses, submitting assignments and importing files, and taking tests. The course also shows how classmates and work groups can communicate in Blackboard with group assignments and email.
In this succinct course, author, speaker, and marketing expert Lorrie Thomas Ross provides an overview of the basics of branding your business or yourself through consistency, communication, and effective collateral. The course shows how images, messaging, and market positioning can help you build visibility and credibility among customers. It includes real examples of successful brands and how aspects such as color, logos, and fonts, not to mention a strong web presence, contribute to their success.
In this course, author Mariann Siegert shares how to harness the power of templates in Microsoft Word and create efficient and repeatable workflows. The course focuses on the basics of using and applying templates but also shows how to create custom templates with document property fields, macros, content controls, building blocks, and styles. Also discover how to create style set templates to make documents more efficient and consistent; use organizers to copy styles, macros, and Autotext between templates; modify the default Normal template; and create workgroup, global, and add-in templates to share with colleagues.