Online Learning >> Computers

« back to courses page
Online computer classes
Please click on the course title to see the full course description.
 
We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence. Agenda Unit 1 - Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2 - Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3 - Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4 - Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data

Start date: 08/07/17

Online 24/7 (08/07/2017-09/01/2017)

Class Cost: $195.00

Instructor : John Rutledge  

Location : Online



View Details »
Acquire the basic skills to boost your website traffic, including how to analyze your visitor traffic, how to use search engine optimization to get greater visibility and exposure in Google searches, and how to redesign your web site copy to increase your visitors and results. No experience necessary, but if you are at an advanced level, your instructor is an SEO expert and can answer your toughest questions as well. Agenda Unit 1 Why web site analysis works Why web site managers analyze their visitor traffic Creating goals and objectives for your web site Understanding the web site visitor experience How data analysis can improve web site outcomes Unit 2 How Google Analytics functions Setting up Google Analytics accounts Analyzing traffic sources and visitor traffic Redesigning pages to improve retention Testing web site versions with Google Optimizer Unit 3 Search Engine Optimization Understanding how page ranking and positions are determined Redesigning the title bar, alt tags, heading area, and links your URL Keyword density and rewriting web page copy Strategies to improve your page rank Unit 4 Moving to Web 2.0 Generation Y and the Web 2.0 Attitude Developing user-created content Creating interactive web sites The future of web sites

Start date: 07/03/17

Online 24/7 (07/03/2017-07/28/2017)

Class Cost: $195.00

Instructor : Susan Hurrell 

Location : Online



View Details »
Being engaged with your online learners throughout the course is one of the three biggest weaknesses of online teachers. It is also one of the three biggest ways to take your online course to the next level, making it a superior learning experience for your learners. Come experience how to do it from the creator of the concept and practice of ‘continual engagement’ in teaching. Discover how to build student success through your interaction, how to give online learners feedback, communicating with them about everything from subject matter to delicate issues to grading. You will come away with advanced, practical, how-to tips from one of the foremost authorities on fostering online discussion. And you will see how your instructor models great interaction and engagement in the online environment. Agenda Unit 1 How Continual Engagement Helps You Foster Effective Online Discussions What is continual engagement? Why is continual engagement important? Breaking down the barriers to effective continual engagement in your discussion interaction Unit 2 Building Your Students’ Success through Your Interaction Why continual engagement in online discussion is important to your students’ success Choosing your words carefully in discussion interaction Strategies to use at the beginning of your term Strategies to use as the term gets underway Strategies to use when things get hectic Unit 3 Assessing Your Students’ Performance Giving effective feedback Communicating with students about grades Some special challenges of group work and how to overcome them Unit 4 Keeping Your Communication Skills Sharp How networking with your peers can build your skills Using break times effectively Working with an assistant How online interaction enhances your face-to-face instruction

Start date: 07/03/17

Online 24/7 (07/03/2017-07/28/2017)

Class Cost: $145.00

Instructor : Mary Dereshiwsky 

Location : Online



View Details »
Google+ has surpassed Twitter to become the second largest social network next to Facebook. Discover the best ways to use this popular and emerging social media platform to raise your online profile, and connect with current and potential new contacts. You’ll learn the advantages of using Google+, how it can help your organization to engage existing users and grow your base, and techniques for using the platform to create relationships, and expand your reach and knowledge in particular subject matter areas. Agenda Unit 1 What makes Google+ Unique -Why Use Google +? What makes it unique -How to Use Google + -Creating Posts and Messages -Sharing, and Google+ integration with other social media Unit 2 Bringing More Traffic to your site -How Google + will bring more traffic to your site -Developing relationships in Google + -How to get your content posted and reshared -Tips and tricks Unit 3 Connecting with Communities -Using Google+ Communities to connect with focused organizations, and highly interested and engaged users -Contributing to Communities to offer resources -Learning from Communities to gain additional knowledge and skills Unit 4 Stars: Advanced Tips -Using Google + as a conversation tool -Using Hangouts to broadcast your message -How to use Google + for all of your social media -What to Avoid: Google Negatives.

Start date: 08/07/17

Online 24/7 (08/07/2017-09/01/2017)

Class Cost: $195.00

Instructor : Jeff Kart 

Location : Online



View Details »
Take away a practical strategy and techniques for implementing social media for your organization or business. Learn how to create your own private social media using Ning, work socially using Google Docs and calendars, and move your website to an interactive Web 2.0 site. Then your instructor will help you choose which social media tools are right for your situation, and then integrate them into your web site to develop a social media strategy for your organization. Find out what you can be doing, what you should be doing, and take back a plan to integrate social media into your communication and marketing. Agenda Unit 1. Running a Community and Creating Your Own Social Network Using Ning Online Communities and Creating Your Own Social Network with Ning Top 5 Considerations When Starting a Social Network What Goes into Build a Great Social Network What is an online community manager What is Ning and How to Use the Platform Examples of Companies Using Ning Unit 2. What Tools to Use for Your Organization What tools and platforms will help get content on the web Readings on top new tools to consider How to select which tool to use How video fits into online marketing Organizing and collaborating with Google products How to take advantage of mobile and local in applications and search Unit 3. Integrating Social Platforms into Your Web Site Discovering how web design has changed and what is needed for true integration Understanding elements on web sites that increase interaction, engagement, search engines findability Learn best practices for website usability and landing page design Discuss how your sites compare and generate next steps that will improve your business Unit 4: Developing a Manageable Work Flow: Time, Resources, Policies, and Trends Developing a Manageable Work Flow Time and Resources: How do you know where to spend your time? Target Social Media Influencers to Boost Traffic and Sales Is Your Company Ready for Social Media or Are They Holding You Back? Trends - What''s Next or Are We Still Working on Last Year''s Trends? Social Media Policies and Planning For A CrisisRequirementsInternet connection ,IE8 or higher, Chrome, FireFox and access to Adobe Flash Player

Start date: 08/07/17

Online 24/7 (08/07/2017-09/01/2017)

Class Cost: $195.00

Instructor : Jennifer Selke 

Location : Online



View Details »
Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level! This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do. Agenda Unit 1 - Organizing Worksheet and Table Data Introduction to tables Formatting tables using styles Using formulas in tables Sorting and Filtering table data Unit 2 - Understanding Popular Excel Functions Understanding Name Manager Applying business functions Creating functions that handle text Performing basic lookup functions Creating functions that work with dates and times Unit 3 - Improving Worksheet Appearance Formatting cells in worksheets Correcting common function errors Creating and using worksheet outlines Customizing Excel user interface Unit 4 - Analyzing Data Using Data Validation and Pivot Tables Understanding how to convert text to columns Understanding how to analyze spreadsheet data Understanding the basic pivot table layout and key terms Creating and formatting simple pivot tables

Start date: 07/03/17

Online 24/7 (07/03/2017-07/28/2017)

Class Cost: $195.00

Instructor : Amy Klous 

Location : Online



View Details »
To be successful, organizations must manage by fact. As such, organizations depend on the measurement and analysis of performance to make key decisions that affect the organization. This Intermediate Six Sigma Green Belt course builds on the ideas and skills learned in the Introduction to Six Sigma Green Belt course that organizations use, specifically their Six Sigma teams, to improve. In this second course in the certification program, participants will learn process analysis, data collection and analysis, probability and valid statistical conclusions, and hypothesis testing. Many participants find this course to be the most challenging of the certification courses.

Start date: 07/03/17

Online 24/7 (07/03/2017-07/28/2017)

Class Cost: $195.00

Instructor : Scott Follett 

Location : Online



View Details »
Worldwide, video game sales including consoles, and online and mobile games are projected to reach $111 billion dollars this year. Mobile games are the fastest-growing segment of the market as more and more people play casual games. By 2019 Price Warehouse predicts social and casual game sales will exceed traditional game sales. In this intermediate introductory course you will learn the basics of video game design process, learn about the main video game genres, and use a game development application to begin your journey of making games. Agenda Unit 1 A brief history of Video Game Development - Arcades & Consoles - From PCs to Multiplayer - Play a Game -Game Analysis - Game Maker Introduction Unit 2 Player Motivation - Geographics, demographics, and psychographics - Who Plays - Why We Play - Game Maker Making Art: About Sprites, Objects, Rooms Unit 3 Platforms, Genres and Story Elements - Game Application: The Audience - Platforms & Player Modes - Story Elements: Premise, Backstory, Synopsis, Theme, & Setting - Character Archetypes & Character Development - Game Maker: Programming Events & Actions Unit 4 The Production Process - Documentation: The Game Design Doc - Creating the Team - Production Phases - Marketing - Game Maker: Your First Game

Start date: 07/03/17

Online 24/7 (07/03/2017-07/28/2017)

Class Cost: $245.00

Instructor : Jean Haefner 

Location : Online



View Details »
Boost your success with webinars by getting the most advanced and latest information on managing and marketing webinars. Find out when and how often to promote webinars, how to do follow up promotion to those who click-through on your initial emails, and how to generate more leads and inquiries. Discover our unique needs assessment model, and take back our 5 secrets to creating high response surveys. Market research can be simple, no-cost and effective, lowering your risks. Then take home our webinar planning timeline with the ideal timeframe for planning and marketing webinars for maximum success. Agenda Unit 1 Needs assessments, market research and surveys Determining the need and the size of the audience Gauging the competition Simple yet critical market research techniques Creating high response surveys Unit 2 Marketing virtual meetings When and how often to promote How much to spend on promotion Promoting with email, web sites and direct mail The 5 keys to successful marketing of virtual meetings Unit 3 Budgeting and pricing virtual meetings Setting income goals Budgeting startup costs Determine your profit margin Pricing your virtual meeting Unit 4 Planning for Successful Webinars -Choosing the best topics -Your webinar timeline -The 5 most common planning mistakes with webinars

Start date: 08/07/17

Online 24/7 (08/07/2017-09/01/2017)

Class Cost: $195.00

Instructor : Suzanne Kart 

Location : Online



View Details »
Get the keys to making online advertising work for you and your organization. See how pay-per-click advertising with Google AdWords works. Find out how to test low budget AdWord campaigns. Learn how you can target local audiences. Then discover Facebook advertising and how you can determine the demographics and even numbers of people you want to reach. No experience necessary, but if you are at an advanced level, your instructor is an online ad expert and can answer your toughest questions as well. Agenda Unit 1 The evolution of online advertising From mass marketing to targeted marketing The role of search in online advertising Return on investment for online advertising Competing effectively with online advertising Unit 2 Creating Google AdWord Campaigns Determining keywords Selecting your AdWord territory Understanding pricing strategies Creating an AdWord budget and evaluation Unit 3 Improving Online Advertising Results How SEO and online advertising complement each other Testing keywords and related keywords Using Traffic Estimator to improve keyword selection Successful strategies in using online advertising Unit 4 Facebook Ads Understanding Facebook uses and users Using demographics to target Facebook Ads Setting up Facebook Ads Trends and future of online advertising

Start date: 08/07/17

Online 24/7 (08/07/2017-09/01/2017)

Class Cost: $195.00

Instructor : Susan Hurrell 

Location : Online



View Details »