Online Course in Computer Science in USA

View Online Courses in Computer Science in USA 2017

Computer Science

The USA remains the world’s most popular destination for international students. Universities in the US dominate the world rankings and the country also offers a wide variety of exciting study locations. State university systems are partially subsidized by state governments, and may have many campuses spread around the state, with hundreds of thousands of students.

Online Course in Computer Science in USA

Read More

Learning Apple Final Cut Pro X Training Video

Courses for Success
Online Part time Open Enrollment USA USA Online

In this project-based Learning Apple Final Cut Pro X video tutorial series, you'll quickly have relevant skills for real-world applications. [+]

Online Courses in Computer Science in USA. A Practical Final Cut Training Course That Teaches Real World Skills In this project-based Learning Apple Final Cut Pro X video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Learning Apple Final Cut Pro X Training Video course to get: Concise, informative and broadcast-quality Apple Final Cut Pro X training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Apple Final Cut Pro X subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Apple Final Cut Pro X tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 10.5 hours to complete this course 142 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning Apple Final Cut Pro X Training Video, expert author and teacher Andy Anderson introduces you to this latest version of the popular video editing software from Apple. Whether you are a pro transitioning to FCP X, or a beginner who just wants to put together clips of your children, this video tutorial will teach you how to do that! Starting with the very basics - setting up your preferences. From there, you will cover topic like organizing and planning your projects, importing your source material, and setting up your project. You will then jump the the heart of the matter - editing. Ripple edits, replace editing, three-point edits, even editing and managing your audio - you will learn it all. Andy then brings the fun with transitions, filters and matts. You will create titles, and add text and even animations to your video. A close look at color management leads to the most important - sharing your video, and a multitude of output options. By the conclusion of this computer based Learning Apple Final Cut Pro X Training Video course, you will be fully capable of importing, editing sprucing up and finally outputting all your video projects, from feature film to baby's first steps. This course includes extensive video and audio working files so that you can learn alongside the author with the same file he is showing in the training. Units of Study 01. Getting Started 0101 Introduction 0102 Working Through The App Store 0103 Editing Preferences 0104 Playback Preferences 0105 Import Preferences 0106 Working With The Event Library And View 0107 Understanding The Timeline 02. Basic Import And Editing In FCP 0201 Introduction 0202 Organization Is The Key To Success 0203 Creating Events And Projects 0204 Adding Transitions 0205 Editing A Clip With The Blade Tool 0206 Saving FCP For Display 03. Populating Events With Clips & Files 0301 Introduction 0302 Events Do's And Do Nots 0303 Importing Files 0304 Capturing From Tape 0305 Capturing Live Video 0306 Organizing The Events Library 0307 Merging Events 0308 Moving And Copying Between Events 0309 Transcoding And Analysis 04. Working With And Organizing Clips 0401 Introduction 0402 Opening The Work Files 0403 Organizing In The Event Browser 0404 Marking Clips 0405 Sorting Through Marked Clips 0406 Skimming In The Event Browser 05. Clips, Keywords, And Metadata 0501 Introduction 0502 Creating Clip-Related Keywords 0503 Metadata To The Max 0504 Customizing Clip Names 0505 Finding What You Need 0506 Smart Collections 0507 Generating Event Library Folders 06. Projects & The Timeline 0601 Introduction 0602 Creating A Working Project 0603 Gaining Control Of Projects 0604 Creating Temporary Projects 0605 Modifying Project Properties 0606 Finding Lost Clips 07. Editing 101 0701 Introduction 0702 Appending Versus Inserting 0703 Performing An Overwrite Edit 0704 Connect Track Editing 0705 Replace Editing 0706 Playing A Portion Of A Clip 0707 Viewing Clip Times 08. Beyond Simple Edits 0801 Introduction 0802 Editing By End Points 0803 Three-Point Edits 0804 Separating Audio And Video 0805 Deleting Tips 0806 Adding Gaps And Placeholders 0807 Skimming And The Playhead 09. Editing And Marking Tips & Tricks 0901 Introduction 0902 Moving Clips On The Timeline 0903 Lifting And Overwriting Clips 0904 The Position Tool And Snapping 0905 Creating Markers 0906 Moving Markers 0907 Converting Markers To A To Do 0908 Searching And Finding Markers 10. Editing Tips & Tricks 1001 Introduction 1002 Editing Techniques 1003 Performing A Rolling Edit 1004 Editing Tips And Tricks 1005 Separating Audio And Video 1006 Making Editing Precise 11. Auditions And Consolidating Clips 1101 Introduction 1102 What Is Audition 1103 Creating An Audition 1104 Creating An Audition From Multiple Clips 1105 Working With A Secondary Storyline 1106 Generating A Compound Clip 12. Working With Audio 1201 Introduction 1202 Adding Audio Work Files 1203 Reading The Waveform And The Music Browser 1204 Working With The Audio Inspector 1205 Controlling Clip Volume 1206 Defining Clip And FCP Volume 1207 Creating And Adjusting Audio Keyframes 13. More On Controlling Audio 1301 Introduction 1302 Adding And Fading Audio Clips 1303 Cross Fading Audio 1304 Changing Audio Properties 1305 Panning Audio Clips 1306 Audio Equalization 1307 Matching Audio Clips 1308 Enhancing Audio 1309 Working With Audio Effects 1310 Saving Custom Effects And Filters 14. Getting Creative With Transitions, Filters, And Mattes 1401 Introduction 1402 Transforming A Clip 1403 Trim/Crop/Distort 1404 Adding Additional Work Files 1405 Blending Modes And Opacity 1406 All About Mattes 1407 Applying A Key 1408 Controlling Plug-In Effects 1409 Applying Transitions 1410 Overlap Versus Available Media 15. Titles, Text, And Generators 1501 Introduction 1502 Creating A Title 1503 Modifying A Title 1504 Additional Title Effects 1505 Creating Basic Text 1506 Working With Generators 16. Bringing The Timeline To Life 1601 Introduction 1602 Generating A Basic Animation 1603 Modifying An Animation 1604 Animating A Movie Clip 1605 Additional Animating Effects 1606 Controlling Opacity With Keyframes 1607 Adjusting Animation Keyframes 1608 Changing A Clips Speed 1609 Generating A Speed Ramp 1610 Creating A Freeze Frame 1611 Combining Multiple Clips 17. Working With Color 1701 Introduction 1702 Automatic Color Correction 1703 Color Manipulation Using Effects 1704 Understanding Video Scopes 1705 Working With Color Boards 1706 Adjusting Exposure 1707 Controlling Color Saturation 1708 Manipulating Clip Color 1709 Controlling Color Information With Masks 1710 Using Preset Shapes To Control Color 1711 Copying And Pasting Color Information 18. Getting Ready For Primetime 1801 Introduction 1802 Gathering Media For Export 1803 Consolidating A Project 1804 Checking Before Exporting 1805 Exporting Quicktime Video And/Or Audio 1806 Exporting Sequences And Frames 1807 Using Apple Compressor 1808 Sharing With The World 1809 Exporting To Blu-Ray And DVD 1810 Browsing Multiple Clips 1811 Adjusting Event Library Thumbnails 1812 Closing Thoughts System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need the software to watch the training course? All the courses are stand alone and can be viewed without the software itself, However, you many not be able to complete any working files/projects set by the trainer if you do not have the software. [-]

Certificate in Intermediate Microsoft Excel 2013 Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2013, and discover how this powerful MS Office program can boost your productivity. [+]

Start Now To Learn Intermediate Microsoft Excel 2013 Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2013, and discover how this powerful MS Office program can boost your productivity. In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. So get ready for six fun, action-packed weeks that will make you an Excel expert! Course Fast Facts: Learn Certificate in Intermediate Microsoft Excel 2013 Online Course in only 6 weeks Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course How is the Certificate in Intermediate Microsoft Excel 2013 Online Course studied? Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the Certificate in Intermediate Microsoft Excel 2013 Online Course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Excel 2013 Charts and Graphs In our first lesson, you'll discover why Excel 2013 is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So, today, you'll find out how to choose the right chart for telling your story and then how to create, format, and edit your chart to help others clearly visualize that story. More Excel Charts There are so many great charting features and enhancements in Excel 2013, there's no way we could cover all of them in a single lesson. So, today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well-known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step, so you'll see the value for yourself. AutoFilter and Sorting Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that? Goal Seeking Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature. PivotTables Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss! Advanced PivotTables Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So, today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using the Excel 2013 PivotTable filtering tool called Slicer. Solver Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off. Sparklines There's nothing more exciting than learning how to master a new feature in Excel. In today's lesson, we'll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you'll have the skills to create dashboardlike mini charts sure to make you the envy of your office. If you enjoy creating charts, you'll really enjoy this lesson. Macros Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you? Introduction to Functions If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category. Math/Trig Functions Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of the more complex functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat! VLOOKUP, INDEX, and MATCH Functions Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. Today, you're going to learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short-changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss! Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Certificate in Introduction to Microsoft Excel 2010 Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

This Certificate in Introduction to Microsoft Excel 2010 Online Course will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. [+]

Online Courses in Computer Science in USA. Learn the Secrets Behind Microsoft Excel 2010! This Certificate in Introduction to Microsoft Excel 2010 Online Course will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This is not a tutorial, but an in-depth class where you’ll get training, help, and personal support from an experienced instructor as you’re learning Excel basics step-by-step. By the time you’re done, you’ll be using this vital Office 2010 tool like a pro. Do you work with numbers? Then you need to master Microsoft Excel 2010—and this is the place to do it. Even “non-techie” beginners will find it easy to learn Excel in this fun, step-by-step online course. Course Fast Facts: Only 6 weeks to complete this course Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course How to study online course? Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Excel Basics In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas. Creating a Worksheet In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted. Time-Savers Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also cover the art of file management in this lesson, so you'll have no trouble saving, retrieving, printing, and emailing your worksheets, or copying, renaming, and even deleting files. By the time you finish this lesson, you'll really start to feel like an Excel pro. Relative & Absolute References Do you know the difference between a relative reference, an absolute reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios. 3-Dimensional Workbooks With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you will join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks. Sorting and Subtotaling No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a database in Excel, you'll also learn how to subtotal, sort, and filter. Charting In this lesson and the next, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart. Advanced Graphing Techniques Today, we'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart, the bubble chart, and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings, and you'll discover the best ways to print or otherwise display the truly impressive charts that you'll be creating. The Function Wizard Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers. Financial Functions We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time. Worksheet Automation Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how macros can be used to reduce just about any complex task to a single keystroke. Decision-Making I think you'll be intrigued by our final lesson, in which you'll teach Excel not only how to make decisions, but also how to act upon those decisions. We'll use a special function in Excel that allows it to make comparisons and use that comparison as the basis for important decisions. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Certificate in Computer Skills for the Workplace Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; [+]

Learn How to Implement the Powers of Modern Office Software Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; add and edit data in a database; understand the implications of file sizes, memory limitations, and network arrangements; and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not. This computer skills for the workplace online course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. We'll focus on practical application for software most common to the workplace. When you finish this course, you will have learned why employers consider technological literacy so critical to the success of any organization. Course Fast Facts: Only 6 weeks to complete this course Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course Course Delivery Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Overview: The Workplace Technology Solution Whether you're looking for a new job or looking to improve your position at your current company, computer skills are essential to your success. In our first lesson, we'll examine how companies set up and use technology solutions. Then we'll take a close look at some of the components of those solutions. Just understanding how technology fits into the overall flow of work at your company will advance your position relative to your peers. Outlook: E-Mail and Scheduling Your computer has a software program installed on it that's referred to as an "operating system." Most often, this system is Microsoft Windows, but it could be others, such as Macintosh or Linux. In this lesson, you'll learn how this system controls many important parts of the computer and how you use those controls every day for tasks like managing where you keep important files, and printing hard copies of documents. We'll also talk about menus, taskbars, and shortcuts along the way. Word: Creating and Formatting Documents Next to e-mail, the word processor is probably the most frequently used application software in the workplace. Yet, if you've never taken the time to learn the basic features of most word processors, you're not performing nearly to your potential. In today's lesson, you'll learn and practice the important capabilities of word processors like Microsoft Word. Word: More Advanced Formatting There are many excellent features in Microsoft Word that can enable you to create and edit very professional-looking documents. In this lesson, we are going to incorporate some of the more advanced Word functions to create documents that are sure to impress your peers and your supervisor. We’ll focus on formatting and organizing your information using a wide range of Word processor tools. Excel: Spreadsheet Basics During today's lesson, we'll go over some important fundamental concepts related to spreadsheets, including spreadsheet organization, formatting, basic formulas, and data sorting. Once you discover how to create a basic budget spreadsheet, you'll see how the skills and knowledge you gain from this lesson can have a powerful impact on your ability to contribute more in the workplace. Excel: Formatting, Charts, and Printing In this lesson, we'll discuss more details about the spreadsheet, and how to provide easy-to-understand, accurate data. You'll learn how to build graphs that can graphically display numeric information so you can easily demonstrate trends, analyze past results, and predict future performance. You'll also find out how to use some advanced spreadsheet tools that can make your spreadsheets even more effective. Access: Database Basics During this lesson, we'll examine the components of a database, focusing primarily on the user interface. In your job, you might use this interface to perform a lot of different functions, including data input, data output, and data maintenance. Clerks work with databases to input information. Other employees might work with databases to filter, sort, and read information. Database-management personnel interface with databases to keep them accurate, reliable, and secure. PowerPoint: Creating and Editing a Presentation Powerpoint is an important tool for creating presentations suitable for the work environment. This powerful program has many features, but they must be used correctly or else your audience will be distracted or overloaded. In this lesson, we’ll explore the best ways to create an effective presentation that incorporates the right mix of multi-media. You’ll learn how to insert graphics and audio into your presentation in an effective and organized manner. Integrating Microsoft Office Programs The suite of Microsoft Office products includes Excel and Access, both very powerful on their own. In this lesson, you are going to learn how to actually integrate information from one program to the other. You can create data lists with either one and easily transfer the information to the other. Considering all the work we do with lists on the computer, this is a very important skill in today’s work environment. Using the Internet In today's lesson, we’re going to have fun working with the Internet. This is the greatest source of information you'll ever have access to—yet it can confusing and overwhelming if you are not familiar with the basic Internet tools. You’ll really enjoy seeing how easy it is to find information that specifically meets your needs and interests. Transferring and Protecting Data Today, we'll go various methods for transferring information from one computer to another. We’ll explore different terms used to describe the volume of information—or size of a file—and then learn how to most effectively and efficiently move that data from place to place. You’ll learn about bytes, megabytes, memory sticks, and external hard drives. Putting Your Skills to Work In our final lesson, we will focus on putting all your new knowledge to work! have three specific goals. The first is to identify ways to use your computer skills to find a new job. The second is to use those same computer skills to get a promotion within your current organization. Our third goal is to explore strategies for continued learning in order to support your ever-growing employment goals. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Introduction to SQL Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

You'll learn how to read and write simple and complex SQL statements, and advanced data manipulation techniques. [+]

Online Courses in Computer Science in USA. Learn the Basic Structure of Relational Databases You'll learn how to read and write simple and complex SQL statements, and advanced data manipulation techniques. Course Fast Facts: Only 6 weeks to complete this course Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work, at your own pace, in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course How to study online course? Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Database Basics, and Structures Query Language In our first lesson, we'll explore the basic structure and history of relational databases. Then, you'll understand what SQL is and how it is used with a relational database. Sorting and Retrieving Data In this lesson, you'll learn how to use SQL to sort and retrieve data from tables. We'll talk about important query terms that enable you to communicate with your database, as well as syntax rules that will enable you to create clear and understandable queries while avoiding system generated errors. Filtering Data In this lesson, you'll learn how to use SQL to filter retrieved data. You'll practice sorting retrieved data using the ORDER BY clause. You'll be able to sort single and multiple columns, and you'll know how to specify sort directions such as ascending and descending order. You'll also learn additional query terms that will help you customize your SQL queries. Calculated Fields and Functions Today, you'll learn how to reformat retrieved data with calculated fields and functions. You'll also learn how to create alternate names for columns and you'll discover the secret behind merging columns with the concatenation symbol. Summarizing and Grouping Data In this lesson, we'll discuss gathering significant statistics from data using aggregate functions. You'll also learn how to use the GROUP BY clause in conjunction with an aggregate function to gather important statistics from a table. Then you'll find out how to use the HAVING clause in conjunction with an aggregate function to filter groups of data from a table. Working with Subqueries Today's lesson is all about subqueries. You'll learn how to extract data from multiple tables simultaneously, how to use calculated fields in subqueries, how to use the DATEPART () function in subqueries, and how to use aggregate functions in subqueries. Then we'll talk about qualification—a technique used to combine a table name with a column name so there's no question about which table the column name refers to. Creating and Using Table Joins In this lesson, you'll learn how to use joins to gather information from two or more tables simultaneously. You'll learn how to use the inner join, self-join, natural join, and the outer join. Then you'll become familiar with the term Cartesian product. Inserting, Updating, and Deleting Data In today's lesson, you'll discover how to manipulate data using the INSERT, UPDATE, and DELETE statements. You'll learn how to insert partial and complete rows into a table, and how to update information already stored in a table. You find out how to transfer data to a new table, how to transfer data to an existing table, and how to delete rows from a table. Table Creation and Maintenance Today, you'll find out how SQL can be used to create and maintain tables. You'll learn how to use the CREATE TABLE keywords to create a table, then we'll discuss how to use the ALTER TABLE, DROP TABLE, ADD COLUMN, and DROP COLUMN keywords to manipulate the tables themselves. You'll also find out how to define a primary key, data type, and field size. Creating and Understanding Views In this lesson, you'll learn how and why views are used in SQL. You'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. I'll also teach you how to update and delete a view. Understanding Transaction Processing, Constraints, and Indexes Today, you'll learn how transaction processing, constraints, and indexes are implemented in SQL. You'll work through an example that demonstrates how a transaction is created, how constraints are used in the creation of a table, and how indexes are used to improve the performance of a database by optimizing the speed at which queries are processed. Understanding Stored Procedures, Triggers, and Cursors In our last lesson, you'll find out how stored procedures, triggers, and cursors are implemented in SQL. You'll see how stored procedures are created and executed, as well as how triggers work. You'll also see how cursors are declared in SQL. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Introduction to Microsoft Excel 2016

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course. [+]

Learn How to Master Microsoft Excel 2016 Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course. These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016. This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2016 tool like a pro. Course Fast Facts: Learn The Introduction to Microsoft Excel 2016 Online Course in only 6 weeks Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course Course Delivery Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete The Introduction Microsoft Excel 2016 Online Course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Lesson 01 - Excel Basics In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas. Lesson 02 - Creating a Worksheet In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted. Lesson 03 - Time-Savers Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro. Lesson 04 - Relative, Absolute, Mixed, and Circular References Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios. Lesson 05 - 3-Dimensional Workbooks With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks. Lesson 06 - Sorting, Subtotaling, and Filtering No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter. Lesson 07 - Charting Basics In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart. Lesson 08 - Advanced Charting Techniques Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating. Lesson 09 - Intro to Excel's Statistical Functions Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers. Lesson 10 - Financial Functions We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time. Lesson 11 - Worksheet Automation Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke. Lesson 12 - Mastering Excel's IF Function I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader and Microsoft Word [-]

Excel 2013 Essentials Online Short Course

Courses for Success
Online Part time Open Enrollment USA USA Online

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013. [+]

Online Courses in Computer Science in USA. Learn the Basic Features of Excel 2013 You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013. Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making! By the end of this Excel 2013 Essentials Online Short Course, you will be able to: Open and close Excel Differentiate between worksheets, workbooks, rows, columns, and cells Understand the new Interface and the new Backstage View Enter labels and values Edit data Add rows and columns Check spelling Open, close, and save workbooks (including publishing to PDF and sending via E-mail) Switch between Excel views and create custom views Use Zoom Set up, Preview and print your workbook Build, copy and edit formulas Use absolute referencing appropriately Understand the difference between Formulas and Functions Understand the new Function Names Use the Formulas Tab Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN Use the status bar to perform calculations Use AutoFill and AutoComplete Sort and filter data Use sparklines Format text and numbers Use alignment options Merge cells Apply borders Use cell styles Use conditional formatting Change the workbook theme Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Module One: Getting Started Course Objectives Module Two: Opening and Closing Excel Opening Excel Understanding the Interface Using Backstage View Understanding Worksheets Understanding Workbooks Module Three: Your First Worksheet Entering Data Editing Data Using the Wrap Command Adding Rows and Columns Checking Your Spelling Module Four: Working with Excel Files Saving Files Publishing Files to PDF Sending Files via E-Mail Closing Files Opening Files Module Five: Viewing Excel Data An Overview of Excel’s Views Switching Views Creating Custom Views Using Zoom Switching Between Open Files Module Six: Printing Excel Data An Overview of the Page Layout Tab Setting Up Your Page Using Print Preview Printing Data Module Seven: Building Formulas The Math Basics of Excel Building a Formula Editing a Formula Copying a Formula Relative vs. Absolute References Module Eight: Using Excel Functions Formulas vs. Functions Using the SUM Function Using Other Basic Excel Functions Understanding the Formulas Tab Using the Status Bar to Perform Calculations Understanding the New Function Names Module Nine: Using Time Saving Tools Using AutoFill Using AutoComplete Sorting Data Filtering Data Adding Sparklines Module Ten: Formatting Your Data Changing the Appearance of Text Changing the Appearance of Numbers Setting Alignment Options Using Merge Removing Formatting Module Eleven: Advanced Formatting Tools Adding Borders Adding Fill Color Using Cell Styles Using Conditional Formatting Changing the Theme Module Twelve: Wrapping Up Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Excel 2013 Advanced Online Short Course

Courses for Success
Online Part time Open Enrollment USA USA Online

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. [+]

Get Ahead with Advanced Skills in Excel 2013 Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making! Learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013. At the end of this Excel 2013 Advanced Online Short Course, you will be able to: Use SmartArt and other objects in worksheets Trace precedent cells and dependent cells, as well as use other auditing tools Create and work with charts Create Pivot Tables and Pivot Charts Record and run macros Solve formula errors Use What If Analysis tools Use tools to manage rows, columns, duplicates, and validation Group and outline data Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Module One: Getting Started Course Objectives Module Two: SmartArt and Objects Inserting SmartArt Editing the Diagram Adding Pictures Adding Textboxes Drawing Shapes About the Contextual Tabs Module Three: Auditing Tracing Precedent Cells Tracing the Dependents of a Cell Displaying Formulas Within the Sheet Adding, Displaying, Editing, and Removing Comments Module Four: Creating Charts Using Recommended Charts Inserting a Chart Overview of the Chart Tools Tabs Understanding Chart Elements Resizing and Moving the Chart Module Five: Working with Charts Using Chart Elements Using Chart Styles and Colors Using Chart Filters Working with Data Labels Module Six: Creating Pivot Tables and Pivot Charts Inserting a PivotTable using Excel Recommendations Choosing Fields and Grouping Data Overview of the Pivot Table Tools Tabs Changing the Data Displayed and Refreshing the PivotTable Creating a Pivot Chart from a Pivot Table or Data Some Real-life Examples Module Seven: Macros Displaying the Developer Tab Recording and Running Macros Changing the Security Level Customizing and Changing the Quick Access Toolbar Module Eight: Solving Formula Errors Using Named Ranges Understanding Formula Errors Using Error Checking Using the Trace Errors Commands Evaluating Formulas Module Nine: Using What If Analysis Using Goal Seek Using the Scenario Manager Using a One Input Data Table Using a Two Input Data Table Module Ten: Managing Your Data Transposing Data from Rows to Columns Using the Text to Columns Feature Checking for Duplicates Creating Data Validation Rules Consolidating Data Module Eleven: Grouping and Outlining Data Grouping Data Adding Subtotals Outlining Data Viewing Grouped and Outlined Data Module Twelve: Wrapping Up Words from the Wise Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Web Design Online Course Bundle

Courses for Success
Online Part time Open Enrollment USA USA Online

Looking to design websites, either professionally or for your own use? We will guide you through the process of building an entire web page from scratch using Photoshop! You’ll learn how to best organize the Photoshop interface to streamline your workspace for web design, eliminating the clutter and making creating web pages fast and easy. [+]

Online Courses in Computer Science in USA. Understand the Basics of Crafting Websites from Scratch Looking to design websites, either professionally or for your own use? We will guide you through the process of building an entire web page from scratch using Photoshop! You’ll learn how to best organize the Photoshop interface to streamline your workspace for web design, eliminating the clutter and making creating web pages fast and easy. Explore the various grid systems that can be used as templates to build professional looking web pages. Next, it’s on to wireframing and UI design, where you’ll learn how to create a mockup that can be sent to clients for approval, or simply kept for personal reference. You’ll also discover how to build upon a wireframe to design a beautiful, and functional web page. Once you’re satisfied with your design, this course will show you how to extract the HTML and CSS that will bring your design to life, and how to customize the code to suit your needs. So if you’re interested in web design for fun or profit, this course will set you up with everything you will need. Need to learn how to build a website, or brush up on your coding skills to enhance an existing site? This course will show you, step-by-step, how to set up a web site from scratch and tips and tricks of the trade to make your site more attractive and user-friendly. From what tools you need to build your site and creating and formatting pages, to what to test and look for before your site goes live, our award-winning trainer gives detailed and valuable information that will help you to master HTML coding skills. With real world examples, and the follow-along videos this course is entertaining as it is informative. This is an incredible opportunity to invest in yourself and your future, get started with Courses For Success today! Course Fast Facts: Easy to follow online videos 2-7 hours of study is required per course Unlimited lifetime access to online course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Course Delivery Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device. Units of Study Receive Lifetime Access to Course Materials, so you can review at any time. The Ultimate Web Design Training Bundle, consists of the following 5 courses: Course 1 - Certificate In Building Websites with Photoshop CC Online Course Let's Get Started! Getting Your Files Organized! Doing Nuthing? Let's Build A Web Layout From Scratch! Inserting And Formatting Text! Now It's Time For Some Graphics! Site Rollout: From A Single Page To A Multi-Page Site! Inserting Additional Page Elements! Going Live: Uploading the Completed Site! Course 2 - Certificate In Photoshop CC For The Web Online Course Let's Get Started! Getting Your Files Organized! Doing Nuthing? Let's Build A Web Layout From Scratch! Inserting And Formatting Text! Now It's Time For Some Graphics! Site Rollout: From A Single Page To A Multi-Page Site! Inserting Additional Page Elements! Going Live: Uploading the Completed Site! Course 3 - Certificate In HTML5 & CSS3 Website Design Online Course Let's Get Started! Getting Your Files Organized! Doing Nuthing? Let's Build A Web Layout From Scratch! Inserting And Formatting Text! Now It's Time For Some Graphics! Site Rollout: From A Single Page To A Multi-Page Site! Inserting Additional Page Elements! Going Live: Uploading the Completed Site! Course 4 - Certificate In Building Responsive Websites with HTML5 & CSS3 Online Course Let's Get Started! Getting Your Files Organized! Doing Nuthing? Let's Build A Web Layout From Scratch! Inserting And Formatting Text! Now It's Time For Some Graphics! Site Rollout: From A Single Page To A Multi-Page Site! Inserting Additional Page Elements! Going Live: Uploading the Completed Site! Course 5 - Certificate In Building Websites with Dreamweaver CS6 Online Course Let's Get Started! Getting Your Files Organized! Doing Nuthing? Let's Build A Web Layout From Scratch! Inserting And Formatting Text! Now It's Time For Some Graphics! Site Rollout: From A Single Page To A Multi-Page Site! Inserting Additional Page Elements! Going Live: Uploading the Completed Site! Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

HTML5 & CSS3 Online Course Bundle

Courses for Success
Online Part time Open Enrollment USA USA Online

Ever wanted to build your own websites either professionally or to meet your own needs? This course package will guide you through the process of building an entire website from scratch and equip you with a powerful web skill set enabling you to design and develop professional quality websites yourself. [+]

Gain Practical Web Skills and Build a Website Ever wanted to build your own websites either professionally or to meet your own needs? This course package will guide you through the process of building an entire website from scratch and equip you with a powerful web skill set enabling you to design and develop professional quality websites yourself. The HTML5 & CSS3 Site Design Online Course will get you started with a thorough guide on building your first website from what tools you need to build your site and creating and formatting pages, to what to test and look for before your site goes live, our award-winning trainer gives detailed and valuable information that will help you to master HTML coding skills. With real world examples, and the follow-along videos this course is entertaining as it is informative. Next up the Website Wireframing with HTML 5 & CSS3 course will walk you through the process of creating a website wireframe in just under three hours! This series of instructional videos will guide you through the process of creating the basic sections of your site, arranging and aligning text and images, and adding interactive features. Once you’re finished creating the wireframe, and will show you how to put it online to share with coworkers and clients Modern websites also need to factor in the ever growing mobile market, as such we've included the Building Responsive Websites with HTML5 & CSS3 Online Course. In this hands-on training course, we take you step-by-step through, how to build beautifully designed, responsive websites that adjust and function perfectly on smartphones, tablets, and desktop displays. You’ll begin with the fundamentals of responsive design, beginning with multiple style sheets, media queries and various expressions. Also Included is Applying Design to Wireframes with HTML5 + CSS3 and CSS Floating Layouts Online Short Course which will help you grow your HTML and CSS skills even further. For more information on what's included in these courses please see the units of study tab. This is an incredible opportunity to invest in yourself and your future, get started with Courses For Success today! Course Fast Facts: Easy to follow online videos Only 2 to 6 hours of study is required per course Unlimited lifetime access to course materials Study as many courses as you want Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Course Delivery Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Receive Lifetime Access to Course Materials, so you can review at any time. The Ultimate HTML5 & CSS3 Training Bundle consists of the following 5 courses: Course 1 - Certificate In HTML5 & CSS3 Site Design Online Course Welcome to HTML5 & CSS3! A Look At What We Will Build Lets Get Started! Programs In The Beginning...HTML Fundamentals Understanding What CSS is All About Viewing A Pages Background Code Getting Your Files Organized! Organizing Site Files Creating A Page and Understanding Index Files Setting Up An External Style Sheet Build A Web Layout From Scratch! Setting Up The Page Structure Connecting the External Style Sheet and Testing Inserting and Formatting the Site Header Finishing Up The Basic Layout Debugging for Internet Explorer Understanding How the Layout Works Using Divs for Page Layout Inserting And FormattingText! Inserting Text Into the Layout Setting Up Paragraphs and Headings Adjusting the Layout For Text, Part 1 Adjusting the Layout For Text, Part 2 Formatting HTML Headings with CSS Some Graphics! Inserting an Image Resizing Images with your Graphics Editor Controlling Graphics with CSS Inserting the FeatureBox Images Site Rollout: From A Single Page To A Multi-Page Site! Getting Ready for Site Rollout How to Not Roll Out A Website Rollout Part 1: Setting Internal Hyperlinks Rollout Part 2: Creating The Sites Pages Course 2 - Certificate In Website Wireframing with HTML 5 & CSS3 Online Course Introduction Welcome! Understanding Layout Wireframing Why Using Photoshop May Not be the Best Choice Using HTML & CSS for Fast Wireframe Compositing Getting Started Setting Up the Rough Page Structure Building the Structural CSS Rules Connecting Up the HTML to the CSS Wireframing The Header in Greater Detail First Thing's First: Getting Organized Building the Logo Container Setting Up the Main Navigation Menu Building the Rest of the Layout Inserting the Hero Image Getting Started with the Hero Content Finishing Up the Hero Section Finishing Touches Inserting A Placeholder Image Adding A Logo Placeholder with Text Inserting the Remaining Image Placeholders Course 3 - Certificate In Applying Design to Wireframes with HTML5 + CSS3 Online Course Introduction Welcome! Here's What This Course Is All About Here's What We'll Create in this Course From Wireframe to Design Determining the Design's Message Choosing Your Design's Colour Palette Tools for Selecting Typefaces Getting the Design Underway Getting Started by Styling the Header Formatting Call-To-Action Buttons with CSS Adding Additional Shadow Effects to the Buttons Inserting & Formatting Graphics Inserting & Adjusting the Logo Setting Up the Hero Section Graphics Getting the Feature Section Images Inserted Cross-Browser Testing Online Testing Tools Running Virtual Operating Systems for Testing Making Minor Adjustments for Browser Compatibility Course 4 - Certificate In Building Responsive Websites with HTML5 & CSS3 Online Course Introduction Welcome A Look At What We'll Build Responsive Design Fundamentals Key Aspects of Responsive Design Determining Device Resolutions to Target Wireframing Responsive Layouts The Basics: Multiple Style Sheets & Media Queries The Concept of Using Multiple CSS Files Media Queries & Multiple Style Sheets Building Media Queries into a Single CSS File Building HTML Structure & CSS For All Screens Setting Up The HTML & CSS Files Getting Started with the Header Inserting The Main Nav Menu Building the Tablet Layout Setting Up The Medium Resolution CSS & Testing The Media Query Formatting the Medium Rez Header Formatting the Medium Rez Hero Section Building the Smartphone Layout Setting Up The Low Res CSS & Testing The Media Query Formatting the Low Rez Header Resolving Problems Caused By Floats Advanced Techniques for Responsive Design Disabling Device Smart Zoom Testing Your Responsive Layouts Setting Up Retina Display Graphics Where to Go From Here Course 5 - Certificate In CSS Floating Layouts Online Course CSS Float Fundamentals Basic Floating Using Floats On Multiple Items Introducing Clear A Practical Example: Creating A Thumbnail Gallery With Float And Clea Building A Flexible Layout Creating The Basic Structure Setting Properties And Testing The Layout Building A Combination Flexible / Fixed Layout Building The Basic Layout Structure Adding In Some Dummy Content Setting Properties Building A Fixed Layout Setting Up The Structure Setting Properties Bonus Videos 1 Building Dreamweaver Layouts Using Floats Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader and Microsoft Word [-]

Excel 365 and Excel, Beginner, Advanced and Expert Training Bundle, 4 Courses

Courses for Success
Online Part time Open Enrollment USA USA Online

This Excel Training Bundle is designed for basic to advanced users as it covers basic, intermediate and advanced level training, so whether you are just starting out with Excel or are an avid user looking to make the most of this new software, this may just be the package for you! [+]

Online Courses in Computer Science in USA. Learn Excel 365, Excel 2010, Excel 2013 This Excel Training Bundle is designed for basic to advanced users as it covers basic, intermediate and advanced level training, so whether you are just starting out with Excel or are an avid user looking to make the most of this new software, this may just be the package for you! You will be trained in all aspects of Excel applications including 365, Word, Excel, PowerPoint, OneNote, Outlook, Project and Publisher. You will have access to all online courses that cover basic, intermediate and advanced level training. Plus you will also receive access to new courses as they are added to the library. On completion of this extensive Microsoft Excel Bundle, you will be able to use Excel to its full potential. Save hundreds to thousands of dollars by not paying for each course individually! This is an incredible opportunity to invest in yourself and your future, be quick this offer is only available for a limited time! Excel Training Bundle Fast Facts: All courses are easy to follow and understand Only 6 to 8 hours of study is required per course 12 months membership to Microsoft Office Course Library Study as many courses as you want Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate of completion awarded How to study Excel Training Bundle Online Course Library? Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Receive Lifetime Access to Course Materials, so you can review at any time. Excel Courses available: Certificate In Excel 365 Essentials Certificate In Excel 2010 Essentials Certificate In Excel 2010 Advanced Certificate In Excel 2010 Expert Certificate In Excel 2013 Essentials Certificate In Excel 2013 Advanced Certificate In Excel 2013 Expert Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

The Ultimate Internationally Accredited Microsoft Office Online Library

Courses for Success
Online Full time Part time Open Enrollment USA USA Online

Invest in your future, build your skills and achieve your goals by becoming a member of our entire library of Internationally Accredited Microsoft Office Online Course. [+]

EXCLUSIVE ONLY AT KEYSTONE ACADEMY! 365, Word, Excel, PowerPoint, OneNote & many more Courses Invest in your future, build your skills and achieve your goals by becoming a member of our entire library of Internationally Accredited Microsoft Office Online Course. If you are planning on doing more than one course, becoming a member of our Intrenationally Accredited Microsoft Office Online Course Library is the best and most economical option. The Internationally Accredited Microsoft Office Online Course Library is designed for basic to advanced users as it covers basic, intermediate and advanced level training, so whether you are just starting out with Microsoft Office or are an avid user looking to make the most of this new software, this may just be the package for you! With our Internationally Accredited Microsoft Office Online Course Library you will be trained in all aspects of Microsoft applications including 365, Word, Excel, PowerPoint, OneNote, Outlook, Project and Publisher. You will have access to all online courses that cover basic, intermediate and advanced level training. Plus you will also receive access to new courses as they are added to the library. On completion of this extensive Internationally Accredited Microsoft Office Online Course Library, you will be able to use Microsoft Office to its full potential. Save hundreds to thousands of dollars by not paying for each course individually! This is an incredible opportunity to invest in yourself and your future, be quick this offer is only available for a limited time! Internationally Accredited Microsoft Office Online Course Library Fast Facts: All courses are easy to follow and understand Only 6 to 8 hours of study is required per course 12 months membership to Microsoft Office Course Library Study as many courses as you want Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate of completion awarded How to study Internationally Accredited Microsoft Office Online Course Library? Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Here are all the Microsoft Short Courses available: Certificate In Access 2010 Advanced Certificate In Access 2010 Essentials Certificate In Access 2010 Expert Certificate In Access 2013 Advanced Certificate In Access 2013 Essentials Certificate In Access 2013 Expert Certificate In Excel 2010 Advanced Certificate In Excel 2010 Essentials Certificate In Excel 2010 Expert Certificate In Excel 2013 Advanced Certificate In Excel 2013 Essentials Certificate In Excel 2013 Expert Certificate In InfoPath 2010 Advanced Certificate In InfoPath 2010 Essentials Certificate In InfoPath 2010 Expert Certificate In OneNote 2010 Advanced Certificate In OneNote 2010 Essentials Certificate In OneNote 2013 Advanced Certificate In OneNote 2013 Essentials Certificate In Outlook 2010 Advanced Certificate In Outlook 2010 Essentials Certificate In Outlook 2010 Expert Certificate In Outlook 2013 Advanced Certificate In Outlook 2013 Essentials Certificate In Outlook 2013 Expert Certificate In PowerPoint 2010 Advanced Certificate In PowerPoint 2010 Essentials Certificate In PowerPoint 2010 Expert Certificate In PowerPoint 2013 Advanced Certificate In PowerPoint 2013 Essentials Certificate In PowerPoint 2013 Expert Certificate In Publisher 2010 Advanced Certificate In Publisher 2010 Essentials Certificate In Publisher 2013 Advanced Certificate In Publisher 2013 Essentials Certificate In Visio 2010 Advanced Certificate In Visio 2010 Essentials Certificate In Word 2010 Advanced Certificate In Word 2010 Essentials Certificate In Word 2010 Expert Certificate In Word 2013 Advanced Certificate In Word 2013 Essentials Certificate In Word 2013 Expert New Microsoft Short Courses Just Launched!: Certificate In Excel 365 Essentials Certificate In Lync 365 Essentials Certificate In OneNote 365 Essentials Certificate In Outlook 365 Essentials Certificate In PowerPoint 365 Essentials Certificate In SharePoint 365 Essentials Certificate In Word 365 Essentials Certificate In Windows 7 Essentials Certificate In Windows 8 Essentials Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Certificate in Creating Web Pages Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

Create and post your very own Web site on the Internet using HTML in this extensive, hands-on, online six week Creating Web Pages Online Course. [+]

Online Courses in Computer Science in USA. Learn About the Capabilities of the World Wide Web and the Fundamentals of Web Design Create and post your very own Web site on the Internet using HTML in this extensive, hands-on, online six week Creating Web Pages Online Course. First, with your instructor's patient guidance, you'll plan the content, structure and layout of your Web site, create pages full of neatly formatted text, build links between the pages and to the outside world, and add color, backgrounds, graphics, and tables. You'll also learn critical and timely information on securing the best possible location in search engine listings, and powerful no-cost or low-cost web marketing strategies. Course Fast Facts: Only 6 weeks to complete this course Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course Course Delivery Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Getting Started In this lesson, you'll get started by learning where the Web is and how it works. We'll cover some important concepts and terminology, and hopefully clear up some buzzwords you may have heard but not quite understood. Then we'll go hands-on and get started creating your first website. Create Your First Web Page Today, you'll create your first Web page. You'll learn how to add tags and content to your page, view your page in a browser, reopen it in an editor to make additions and changes, save those changes, and then view the updated page in a Web browser. These skills will apply to every Web page you ever create, and they'll get you started on creating any page you can imagine. Formatting Text In today's lesson, you'll learn to beef up your pages with the design elements that you see in most websites. We'll discuss how to add headings, paragraphs, numbered lists, and bulleted lists to your pages, and we'll also talk about the secrets to adding special characters like © and &trade. Finally, you'll discover how to add links to other peoples' pages and to other pages within your own site. Fun With Pictures Here's your chance to add some visual excitement to your website! Today, we're going to learn the basics about adding pictures to your Web pages. You'll discover how to download pictures right off the Web, and you'll also learn how to prepare and use your own pictures from a digital camera. Creating Tables Tables are a terrific way to neatly organize content into rows and columns. You've no doubt seen tables used in other websites and countless other forms of publication. In today's lesson, you'll learn how to use HTML to create tables in your own Web pages! HTML, XHTML, and CSS If you've been involved in Web development at all during the last 20 years, you may have heard about HTML, XHTML, HTML5, and CSS. If you're new to all of this, it's a confusing mess of alphabet soup. In this lesson, you'll learn the who, how, what, when, where, and why of these technologies—and what you should use now so your website is in sync with current specs and future trends. Getting Started With CSS Virtually all modern websites use CSS style rules for all their website styling. In today's lesson, you'll learn what a style rule is, and you'll get some hands-on practice creating your own styles rules. You'll learn how to center and align pictures and text, and you'll discover the secrets to jazzing up your site with colors (and how to choose from the millions of color options available to you). Creating a Page Layout Today's lesson will introduce you to more advanced HTML and CSS topics, including how to create a page layout with a navigation bar. You'll learn how to create a page layout using div tags to put named page divisions in a Web page, and we'll discuss how to style your page divisions by adding an internal style sheet and some style rules. Building Your Site Most websites consist of multiple pages with some common content on each page. Today's lesson will teach you to use a layout page as template so you can build multipage websites more quickly. We'll cover liquid versus fixed layouts, how design a layout, and how to easily build additional pages from your layout page. This will help you to develop more professional-looking pages using the same modern coding techniques that seasoned professionals use! Getting Noticed Getting a site on the Internet is one thing. Getting people to notice it is quite another. In today's lesson, you'll learn about Internet directory services, search engines, Web-crawling infobots (not as creepy as they sound), and things you can do to make your own site stand out in the crowd! Publish Your Website In today's lesson, you'll learn how to publish your website for the whole world to see—well, at least anyone on the Internet. And best of all, you'll learn how to keep your site on the Internet, for free, forever! Authoring Systems In today's lesson, you'll learn about authoring systems like Dreamweaver and Expression Web, and how they can make Web development quicker and easier. You'll also learn a couple of ways to get an online presence without creating your own website! Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Certificate in Creating WordPress Websites Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

Want to build an attractive, sophisticated blog or website—without having to learn any special coding? WordPress is the answer you're looking for! WordPress is one of the world's most popular Web design tools because it's free, it's easy to use, and it produces professional results. [+]

Get Hands-on Experience in Creating WordPress Sites and Blogs Want to build an attractive, sophisticated blog or website—without having to learn any special coding? WordPress is the answer you're looking for! WordPress is one of the world's most popular Web design tools because it's free, it's easy to use, and it produces professional results. In this Certificate in Creating WordPress Websites Online Course, you'll get hands-on experience with this powerful tool as you create your own WordPress site and blog. As you walk through the process from start to finish, you'll find out how to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features. You'll discover the ease of using WordPress design themes to express your creativity, and you'll see how much fun it is to be part of the vibrant WordPress online community. In addition to mastering the technical elements of WordPress, you'll learn how to organize a blog or website, create appealing content, and achieve better positions on search engine results pages. By the end of this course, you'll be able to confidently use WordPress to create a blog or a personal, business, or organizational website. Course Fast Facts: Only 6 weeks to complete this course Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course How to study online course? Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Getting Started With WordPress In this first lesson, we'll explore the magic of WordPress! You'll discover how to use this free software to create an attractive, dynamic blog or website—without learning any special code. You'll find out what the two "flavors" of WordPress are and why we'll use the hosted WordPress.com version. Then you'll go online, sign up, and tour the WordPress Dashboard. You'll also plan your project and set goals for yourself. Creating a Blog What can a blog do that a website can't? Blogging's become a popular way to establish an online presence. We'll discuss how adding a blog can make a traditional website more effective. Then you'll build a blog with WordPress—by creating, refining, and categorizing posts. You'll also find out how to encourage and control visitor feedback. Making a WordPress Website Get the best of both worlds by combining a blog with a traditional website. In this lesson, you'll use WordPress to create and organize Web pages. And I'll show you how to convert your blog to a traditional website—or vice versa—with the click of a button. Making Your Pages Look Great This lesson's all about WordPress themes—the templates that give your website its look and feel. You'll discover how to choose a theme, install it, and tweak it. Working With Images and Multimedia Photos, drawings, charts, videos, and audio clips can make your website more appealing and understandable. In this lesson, I'll show you how to use WordPress to upload and insert images and multimedia files. Functionality: Getting the Most Out of WordPress Make your website or blog more informative and easier to navigate with some special WordPress tools. You'll learn how to use sidebar widgets, forms, maps, and syndicated newsfeeds to make your site more useful and usable. Making a User-Friendly Website If your online visitors have trouble understanding or navigating your website, they'll go somewhere else. This lesson helps you pinpoint and eliminate usability problems. Polishing Our WordPress Website In this lesson, we'll take a long, hard look at our class project and decide how to make it better. You'll create a front page featuring both static and dynamic content; add links to pages, documents, email, and other sites; and repair typos, grammatical errors, and other mistakes. Getting Search Engines to Love Your Website What if you launched a website and nobody came? This lesson will show you how to keep that from happening. You'll find out what makes search engines tick and how to get them to visit your pages. Making the Most of Statistics and Social Networking Statistics are just a bunch of numbers if you don’t know how to use them. We’ll focus on how to analyze stats so you can improve your site. You’ll also find out how to tie your WordPress pages into social sites like Facebook and Twitter. Launching Your WordPress Website It's time to put the finishing touches on your site. This lesson includes a prelaunch checklist, so your online guests won't find any mistakes. I'll also show you how to promote the site and manage contributors. Getting the Most From WordPress In our final lesson, you’ll learn how to build a sophisticated form, and I’ll review all the optional upgrades WordPress offers. You’ll discover how to personalize your domain name, use your mobile phone to update Web pages, and access the files that control your site’s appearance. I’ll also examine the pros and cons of moving to the self-hosted version of WordPress. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Certificate in Introduction to Microsoft Excel 2013 Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

Do you work with numbers? Then you need to master Microsoft Excel 2013—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course. [+]

Online Courses in Computer Science in USA. Start Now To Learn Introduction to Microsoft Excel 2013 Do you work with numbers? Then you need to master Microsoft Excel 2013—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course. These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers the new Quick Analysis, Flash Fill, and charting capabilities available in Excel 2013. This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2013 application like a pro. Course Fast Facts: Learn Certificate in Introduction to Microsoft Excel 2013 Online Course in only 6 weeks Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course How is the Certificate in Introduction to Microsoft Excel 2013 Online Course studied? Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the Certificate in Introduction to Microsoft Excel 2013 Online Course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Excel Basics In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas. Creating a Worksheet In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted. Time-Savers Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools, introduced in Excel 2013. By the time you finish this lesson, you'll really start to feel like an Excel pro. Relative, Absolute, Mixed, & Circular References Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios. 3-Dimensional Workbooks With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks. Sorting, Subtotaling, and Filtering No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter. Charting Basics In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart. Advanced Charting Techniques Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating. Intro to Excel's Statistical Functions Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers. Financial Functions We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time. Worksheet Automation Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke. Mastering Excel's IF Function I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]