Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

coggno-logo2
Items in Cart: 0 items
Cart Total
Checkout
Filters Applied
  • Category: Software
  • Sub Category: Microsoft Office
Reset All
Best Sellers
Acrobat Pro 9 Introduction Course

Acrobat Pro 9 Introduction Course

In this course you will discover how to bring together content from multiple sources that you can customize within Acrobat Pro 9. - Learn how to add security to your PDF files and create user-interactive forms. - Learn how to modify text, add bookmarks and add navigation to guide your users. Video Length: 175 Minutes

Visited 1,678 times
$30.00
C Sharp Level 1 Course

C Sharp Level 1 Course

This course is the beginning track for certification. It is designed for the beginning C# programmer although there are topics of an advanced nature. The topics discussed within this curriculum focus primarily on C# code and not interface design or true event-based programming. Learn C# code C# Certifcation Video Length: 557 Minutes

Visited 1,724 times
$30.00
Windows 7 New Features Course

Windows 7 New Features Course

This course introduces students to the major new features and enhancements in Windows 7. Students will learn how to customize the Windows 7 environment, manage content by using libraries and Windows Explorer, search for content, interact with devices, and learn various Keyboard Shortcuts. - Learn how to customize the Windows 7 environment, manage content by using libraries and Windows Explorer, search for content, interact with devices, and learn various Keyboard Shortcuts. Prerequisites: Basic computer skills Video Length: 89 Minutes

Visited 1,564 times
$30.00
Database Design Introduction Course

Database Design Introduction Course

This course familiarizes the student with techniques to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project. Learn how to help prevent the new database developer from creating mistakes that add hours and days to a development project. Learn to properly create and normalize a relational database Video Length: 95 Minutes

Visited 1,752 times
$30.00
Excel 2010 Introduction Course

Excel 2010 Introduction Course

This course is designed to teach students the fundamentals of Excel. Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks). Instructor: Pam Conway Prerequisites: Basic Computer Experience Video Length: 230 Minutes

Visited 3,382 times
$30.00
Excel 2010 Advanced Course

Excel 2010 Advanced Course

This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparkline feature. Database management, PivotTables, PivotCharts and Slicers are covered in detail, as well as importing and exporting Excel data between applications. Instructor: Lisa Miles Prerequisites: Excel 2010 Intermediate or Equivalent Experience Video Length: 186 Minutes

Visited 2,659 times
$30.00
Outlook 2010 Advanced Course

Outlook 2010 Advanced Course

In this course students will learn how to subscribe to RSS news feeds and use the Outlook Social Connector to stay current with colleagues. Students will also learn how to manage their mailboxes and archive their mail, create and work with notes and Journal entries, share Outlook calendars and contacts, create e-mail templates, and use mail merge to send personalized messages to groups of contacts. - Learn how to subscribe to RSS news feeds and use the Outlook Social Connector to stay current with colleagues - Learn how to manage their mailboxes and archive their mail, create and work with notes and Journal entries, share Outlook calendars and contacts, create e-mail templates, and use mail merge to send personalized messages to groups of contacts. Prerequisites: Outlook 2010 Introduction or Equivalent Experience Video Length: 248 Minutes

Visited 1,377 times
$30.00
Word 2010 Advanced Course

Word 2010 Advanced Course

In this course students will create and use forms and create master documents that include a table of contents and a table of figures. They will also create macros, customize the ribbon and Quick Access toolbar, and work with XML documents.  They will work with pictures, the drawing tool, insert diagrams and SmartArt, and work with list. - Learn to create and use forms and create master documents that include a table of contents and a table of figures. - Create macros, customize the ribbon and Quick Access toolbar, and work with XML documents. - Learn to work with pictures, the drawing tool, insert diagrams and SmartArt, and work with list. Prerequisites: Word 2010 Intermediate or Equivalent Experience Video Length: 206 Minutes

Visited 1,957 times
$30.00
Recommended
Microsoft Business Contact Manager 3

Microsoft Business Contact Manager 3

Learn how to use Business Contact Manager and you will be able to link contacts, notes, meetings, documents, and emails and view them from a central point within the program. Business Contact Manager integrates with Outlook to create a beefed up contact management system.

Visited 1,784 times
$149.00
Captivate 5 Introduction Course

Captivate 5 Introduction Course

This course is designed for beginners and intermediate Adobe® Captivate® 5 users who want to create software demonstrations and interactive simulations.  Students will learn how to explore the Adobe Captivate 5 environment; create, update, publish and organize projects; record and modify audio; and add quizzes.

Visited 1,368 times
$30.00
Word 2007 Intermediate Course

Word 2007 Intermediate Course

This class builds on the skills and concepts taught in Word 2007: Basic. Students will work with styles, sections, and columns. They will format tables, print labels and envelopes, and work with graphics. They will also use document templates, manage document revisions, and work with Web features. - Learn to work with styles, sections, and columns. Learn to format tables, print labels and envelopes, and work with graphics. - Learn to document templates, manage document revisions, and work with Web features. Prerequisites: Word 2007 Introduction or Equivalent Video Length: 169 Minutes

Visited 1,782 times
$30.00
Windows 8 Essentials (Course)

Windows 8 Essentials (Course)

Windows 8 represents the biggest change in the Windows operating system since Windows 95. On the plus side, it’s faster, prettier, and very easy to operate for most tasks. On the minus side, the familiar Start button and Control Panel are gone (or hidden) and users must learn a whole new way of navigating through the Windows environment. Do the benefits outweigh the concerns? Take our Windows 8 course to learn more about this brand new version of Windows and how you can use it most effectively, including: Navigating and Customizing the Start Pane Finding the hidden Control Panel to tweak settings Using the mouse or touch-screen to navigate between programs How to troubleshoot program and printer issues Tips and Tweaks on over 50 new Windows features!

Visited 1,452 times
Free
All Courses

Excel Everest: Interactive, Comprehensive Excel Training

Excel Everest: Interactive, Comprehensive Excel Training   Excel Everest is an entirely different way to learn Excel. No, really. The whole Excel Everest experience takes place inside a giant interactive Excel workbook (called Excel Everest) that brings users step-by-step through 41+ business-critical topics, 160+ interactive, auto-graded exercises, and there's a scoreboard to measure progress along the way. Oh, and what Excel training would be complete without a dancing bear? (click "the fun button" once you're in Excel Everest). If helpful, watch a video overview of Excel Everest.    Who is Excel Everest for?    Your orgnization or employees may be a fit for Excel Everest if:  You need a comprehensive Excel training that covers all the essential business Excel skills, and with unlimited access and upgrades.  You need a training that covers all of your versioning needs, on both Mac & PC, including for Excel 2003, 2007, 2010, 2011, 2013, 2016  You realize that the best way to learn a complicated program like Excel is not by watching videos, but by going through exercises right there in an Excel document.  You'd like to use the same Excel training for your organization that companies like Google and Eventbrite use for their employees.  You want accountability, and a way to measure not if someone has watched a video, but if someone has completed the skill right there in Excel.    What is the concept behind Excel Everest?    The entire concept behind Excel Everest is that you can learn by doing. As you go through this course, you'll be guided on how to download the Excel Everest workbook. When you open it up, you'll see an index page with a set of 21 buttons that link you to the various areas of the workbook. And in each topic area, you'll:    Learn why a specific concept is important, especially for being successful in a corporation  Grasp the details on the topic through written explanations Go through a set of interactive Excersies that are categorized according to difficulty (easy, medium, and hard)   Best of all, as you complete these exercises, they're graded, so you can easily keep track of your progress through the course, see which topics you've made the most progress on, and earn badgeds for certain milestones.    What are the outcomes you should expect?    As a user, if you go through Excel Everest, you'll be able to go from knowing nothing (for those who need it, we cover the absolute basics), to a deep understanding of all of the business critical aspects of Excel. In no time, you'll have your colleagues asking you to teach them how to do a VLookup or set up a Pivot Table on their behalf.    As a training manager, you'll finally have a training system that provides interactivity, accountability, and a bit of fun along the way. Even small Excel errors can cost organizations an enormous amount of time, and even worse, inaccurate data can get reported up the chain and used for key business decisions. If you have limited training dollars to spend, you should put them toward Excel. An error in PowerPoint or Word doesn't result in catestrophic business outcomes. Excel Everest will help train on what matters most.  

Visited 602 times
$159.00
Learn Microsoft Excel 2013 – Advanced

Learn Microsoft Excel 2013 – Advanced

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.

Visited 451 times
$19.00
Learn Microsoft Word 2013 the Easy Way

Learn Microsoft Word 2013 the Easy Way

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.

Visited 368 times
$19.00
Learn Microsoft PowerPoint 2013 the Easy Way

Learn Microsoft PowerPoint 2013 the Easy Way

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!  

Visited 445 times
$19.00
Learn Microsoft Outlook 2013 the Easy Way

Learn Microsoft Outlook 2013 the Easy Way

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!

Visited 465 times
$19.00
Learn QuickBooks Pro 2014

Learn QuickBooks Pro 2014

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

Visited 3,001 times
$19.00
Learn Microsoft Windows 8

Learn Microsoft Windows 8

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.

Visited 2,306 times
$19.00
Learn Microsoft Publisher 2013

Learn Microsoft Publisher 2013

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    

Visited 2,702 times
$19.00
Learn Microsoft Word 2010

Learn Microsoft Word 2010

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.

Visited 2,946 times
$19.00
Microsoft Project 2010 Beginners/Intermediate Training

Microsoft Project 2010 Beginners/Intermediate Training

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.

Visited 2,004 times
$19.00
Microsoft Project 2010 Advanced Training

Microsoft Project 2010 Advanced Training

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.

Visited 1,463 times
$19.00
Learn Microsoft Outlook 2010

Learn Microsoft Outlook 2010

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.

Visited 1,568 times
$19.00
Learn Microsoft Excel 2010 Advanced Course

Learn Microsoft Excel 2010 Advanced Course

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    

Visited 1,858 times
$19.00
Microsoft Access 2010 Training - Beginners/Intermediate

Microsoft Access 2010 Training - Beginners/Intermediate

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.  

Visited 1,599 times
$19.00
Microsoft Access 2010 Training  Advanced

Microsoft Access 2010 Training Advanced

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.

Visited 1,453 times
$19.00