• An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10) - SkillsFuture Online Course

    Microsoft Excel is an important and powerful program for many businesses. The PivotTable feature is one of the most useful, powerful and misunderstood features. PivotTables are absolutely not just about big data and large companies. Although PivotTables can work with very large data sets they are just as useful for micro businesses trying to understand where their sales opportunities lie or for individuals working on their household finances or even their fantasy football leagues. This PivotTable course from Skillsology teaches you how to draw these conclusions easily and present and manage your findings effectively. Using screenshots, video examples and exercises, you’ll soon be able to make the most out of your data, whether ‘Big’ or small, to further your business or personal life. Turn redundant data into useful analysis with PivotTable.  - Manage your data and information in a more intelligent system  - Realize your data's full potential to your advantage  - Discover ways to enhance your data output  - Learn about the advantages of PivotTable    This training is for PivotTable (PC version: 2013, 2007/10) This course is SkillsFuture Credit Eligible.

  • Maximize your Database with Microsoft Access 2013

    Maximize your Database with Microsoft Access 2013 - SkillsFuture Online Course

    Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better - Know the different ways of vizualising your data with Microsoft Access- Pick up the knowledge of utilizing Access for better understanding your data- Learn how you can stretch your data for optimum analysis 

  • An Essential Online Course: Microsoft Excel Course PC & MAC

    An Essential Online Course: Microsoft Excel Course PC & MAC - SkillsFuture Online Course

    Cut Excel down to size with our tailored online course. Achieve certificated proficiency in hours. Available in all major PC and Mac versions. We reviewed Excel's 500 functions, ruthlessly stripping out all non-essentials, to arrive at our highly refined syllabus. Our diagnostic tool then focuses your time on those parts of that syllabus that will be most valuable to you. Our regularly updated course consists of a carefully balanced combination of text, illustrations, videos and end-of-unit tests to measure your progress. Pick up the basics of Microsoft Excel and be fluent in all of its functions! - Learn from the basics to advanced functions of Microsoft Excel  - Know about the features and functions in Microsoft Excel  - Understand the features and functions offered in Microsoft Excel  - Be able to apply the skill set into your daily work to improve productivity Training for Excel PC (PC versions: 2013, 2007/10, 2003, 2016 | Mac versions: 2011, 2016) This course is Skillsfuture Credit Eligible.

  • All IT and Software Courses

    • Learn about Digital Audio with Steinberg Nuendo 5 - SkillsFuture Online Course

      Learn about Digital Audio with Steinberg Nuendo 5

      SGD $49.00

      Course Description

      Steinberg's Nuendo 5 is the latest update to the popular professional digital audio post-production software. In this VTC course, author Mark Struthers will demonstrate the program's system requirements before looking at how to make initial input and output connections that allow Nuendo to communicate with microphones, synths, and soundcard hardware. He intentionally declutters Nuendo's project window so that you can focus on the track in hand instead of getting distracted by large complex projects. As the course progresses, Mark will guide you through specific tasks and functions, such as creating projects, archiving, audio editing, using markers and much more, so that techniques and tips can be absorbed quickly. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis course is SkillsFuture Credit Eligible.

      Read More...

    • Sony Vegas Pro 10 - SkillsFuture Online Course

      Sony Vegas Pro 10

      SGD $49.00

      Course Description

      Sony's 'Vegas Pro 10' is the latest update to the extremely popular professional digital video editing software. In this course, students are shown important user interface features and their positions on the main Vegas screen. Then, using the included work files, author Mark Struthers goes on to demonstrate how to produce a complete DVD from the timeline. Along the way, audio is scrutinized as is the use of the integrated mixer. Editing functions are inspected and tips and tricks such as track management feature throughout. As the student gains more knowledge, the course illustrates how to use some of the more esoteric functions such as video rotation and using titles as opening and closing credits.  Swiftly create professional-looking DVDs, even stunning widescreen productions.  - Learn what goes into creating a DVD  - Be able to create different kind of content in DVD  - Learn how to create your own media content using Sony DVD Architect  - Learn how to polish your projects before transferring into DVD  This course is SkillsFuture Credit Eligible.

      Read More...

    • Utilize your Business Intelligence with Analytics - SkillsFuture Online Course

      Utilize your Business Intelligence with Analytics

      SGD $45.00

      Course Description

      Data is the fuel that powers modern business and the ability to aggregate and quickly slice and dice data to make accurate, timely decisions is vital in today's environment. Business intelligence is the set of techniques and tools that transform raw, day-to-day, operational data into categorized, aggregated, useful information for fast business analysis purposes. Microsoft's business intelligence tools including SQL Server 2014, SQL Server Analysis Services, Visual Studio/SSDT and Excel provide end users with the power to perform self-service BI and it provides developers the tools they need to create enterprise level BI systems. In this course, Mark Long, teaches you how to work with these tools to create multidimensional data cubes and Microsoft's new tabular data model to provide BI services and help you prepare for Microsoft's certification exam 70-466 Implementing Data Models and Reports with SQL Server. Data plays an integral part in understanding analysis. - Learn how to maintain your database  - Know how you should sort your data in SQL Server  - Learn about the different functions of data warehouse - Be able to handle and monitor the activity in your database  This course is eligible for SkillsFuture Credit.  

      Read More...

    • PostgreSQL: Know how to handle database jobs - SkillsFuture Online Course

      PostgreSQL: Know how to handle database jobs

      SGD $45.00

      Course Description

      This VTC course is an introduction to the popular open source and free database management system PostgreSQL. Author Dima Kassab covers the basics needed to create databases and database objects. The course assumes no prior knowledge of database concepts. It sets the groundwork for more advanced topics such as database administration and development. Topics covered include: installations, data types, main database operators/functions, and creating/modifying database objects such as tables, views, indexes, and sequences.  Take the first step in maintaining your database. - Learn how to maintain your database  - Know about the features and functions of PostgreSQL. - Learn about the different administrative tools available - Be able to handle and monitor the activity in your database  This course is SkillsFuture Credit Eligible.

      Read More...

    • Microsoft Word 2013 - SkillsFuture Online Course

      Microsoft Word 2013

      SGD $49.00

      Course Description

      In this VTC course, students will learn how to work with basic to advanced functions of Microsoft Word 2013. This efficient word processing program allows you to edit text, graphics, tables, page layouts, styles, and more. Intermediate to advanced users will learn how to complete a mail merge, use screenshots or clippings, implement hyperlinks, set up collaboration, create a table of contents, and utilize macros. Microsoft Word even provides connected services so users can utilize social media networks within files. Word is part of the cloud, SkyDrive, which allows everyone to utilize remote access anywhere, anytime. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.

      Read More...

    • Microsoft Visual Basic for Applications (VBA) - SkillsFuture Online Course

      Microsoft Visual Basic for Applications (VBA)

      SGD $45.00

      Course Description

      The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.

      Read More...

    • Microsoft Project 2013 - SkillsFuture Online Course

      Microsoft Project 2013

      SGD $45.00

      Course Description

      Microsoft Project is the standard-bearing tool to help project managers track all the vitals of their projects: tasks, resources, schedule, and cost. With the 2013 version of Project, Microsoft introduces several new features and improves existing ones. In this VTC course, author Brian Culp will guide users through techniques that allow project managers to quickly get up to speed on this powerful toolkit. Users will learn how to start projects, create and edit tasks, assign resources to tasks, share project information, and much more. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.

      Read More...

    • Microsoft Office for Mac 2011 - SkillsFuture Online Course

      Microsoft Office for Mac 2011

      SGD $45.00

      Course Description

      Office for Mac 2011 is a powerful update of the widely used productivity suite. Mac users now have access to a slew of updated features which are designed to simplify workflow while still maintaining the incredible strength of inter-application collaboration. This VTC course explores the 2011 update through a detail driven approach and with the help of practical examples. All of the major applications in Office are covered, along with several of the lesser profile utilities. Office may be constantly changing, but that doesn't mean you need to be left behind! Jump on board with Sam McGuire and get the very most out of the tools you use on a daily basis. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.

      Read More...

    • Maximize your Database with Microsoft Access 2013 - SkillsFuture Online Course

      Maximize your Database with Microsoft Access 2013

      SGD $40.00

      Course Description

      Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better - Know the different ways of vizualising your data with Microsoft Access- Pick up the knowledge of utilizing Access for better understanding your data- Learn how you can stretch your data for optimum analysis 

      Read More...

    • Joomla! 2.5: An Essential Management System - SkillsFuture Online Course

      Joomla! 2.5: An Essential Management System

      SGD $45.00

      Course Description

      Joomla is a popular and highly functional content management system. Joomla is a mobile ready, responsive system that will adapt to user platforms and is extremely user friendly for both site users and site managers. In this VTC course, author Melanie Hedgespeth will show you how to install Joomla and work with the site from an administrative standpoint. From the administration side of Joomla you will learn how to handle users and permissions, increase Joomla functionality with extensions, change templates and most importantly how to keep your site secure and backed up. Keep your back covered with Joomla! - Learn how you can keep your page secure and backed up with Joomla - Know how Joomla can play a constructive part in maintaining your page  - Learn how Joomla can prevent malicious acts on your page  ‚Äč- Understand how Joomla's key functions can fend off attacks on your pages This course is SkillsFuture Credit Eligible.

      Read More...

    • FileMaker Pro 12: Beginner - SkillsFuture Online Course

      FileMaker Pro 12: Beginner

      SGD $80.00

      Course Description

      FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting, interface design and new FileMaker Pro 12 features including charting, snapshot links and the inspector. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. Discover how data can be managed efficiently.  - Find out how you can manage your database - Learn ways to fully utilize your data's potential  - Know how queries can be implemented to run the data better  - Understand an effective solution to optimize your database's productivity  This course is SkillsFuture Credit Eligible.

      Read More...

    • Practical Python for Beginners - SkillsFuture Online Course

      Practical Python for Beginners

      SGD $45.00

      Course Description

      Python is a widely used high-level, general-purpose, interpreted, dynamic programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than possible in languages such as C++ or Java. The language provides constructs intended to enable clear programs on both a small and large scale. Practical Python for Beginners Our Python training is designed for students with no prior programming experience. While designed for beginners, by the end of the training experience the student will be familiar with professional design concepts, software development tools, as well as professional software development techniques & topics. Pick up a new programming language into the mix of new skills! - Pick up a new programming language  - Increase your employability with an extra language under your belt  - Learn how the different languages work to develop web site and applications  - Be able to create cutting edge applications with this course This course is SkillsFuture Credit Eligible.

      Read More...

    • Crystal Reports: Advanced - SkillsFuture Online Course

      Crystal Reports: Advanced

      SGD $45.00

      Course Description

      Crystal Reports is one of the most popular report writing applications available today. Its ability to create complex reports from a variety of data connections (including Microsoft, Oracle, and Business Objects) is highly acclaimed. In this VTC course, expert instructor Lauri Matson walks you through the power of Crystal Reports, exploring its features and showing you how to simplify the complexities. Anyone involved in creating reports from stored data will benefit from this course. You'll become be a master of design, formulas, parameters, and more. You will learn how to create advanced reports, analyze databases and table relationships, write formulas and functions, enhance your reports with charts and graphs, and much, much more. Experience with databases and spreadsheet programs is assumed, prior knowledge of Crystal Reports is recommended.  Learn how you can manage your database from becoming redundant.  - Find out how you can manage your database - Learn ways to fully utilize your data's potential  - Know how to analyze reports from your data  - Learn commands, formula and queries for your database  This course is eligible for SkillsFuture Credit and UTAP funding.

      Read More...

    • Database Optimization - SkillsFuture Online Course

      Database Optimization

      SGD $45.00

      Course Description

      This Database Optimization course provides viewers with important techniques and checklists to configure, monitor, and manage their databases. You will learn how to develop a tuning strategy, explore the tuning and diagnostic tools, understand the relational database model and implications on performance, evaluate the application for efficient design, structure, and other factors affecting performance and evaluate hardware for effects on performance. Join us as we review best practices in designing, optimizing, and maintaining your database. You will benefit from this course whether you have some experience with optimizing databases or are just starting out. Work files are included. Learn how you can manage your database from becoming redundant. - Find out how you can mange your database- Learn ways to fully utlize your data's potential - Know how to analyze reports from your data - Learn how to apply formula, queries and commands into your database This course is SkillsFuture Credit Eligible.

      Read More...

    • 1st step towards 3D Modelling: Substance Designer 2.1 - SkillsFuture Online Course

      1st step towards 3D Modelling: Substance Designer 2.1

      SGD $45.00

      Course Description

      Substance Designer is a revolutionary next generation tool for the creation of smart textures for 3D. Designed to fully leverage Raster, Vector, and Procedural image-making technologies along with advanced filtering techniques to create multichannel texture assets which can be dynamically changed by the end user at run time. The resulting files, known as “Substances,’ are a remarkably flexible solution for many 3D texturing needs including Video Game Design and Architectural Visualization. This latest version of Substance Designer is a must-have for anybody who is serious about working in 3D. Taught by 2D and 3D artist Jason Maranto, this VTC course is designed to quickly elevate your understanding of this powerful application. Focusing heavily on the sophisticated tools available within Substance Designer and taught in an in-depth but easy-to-follow style, this course will help you master Substance Designer to create 3D texture assets of unparalleled flexibility and power. Discover more possibilities with 3D modelling. - Learn about the multiple functions in Substance Designer  - Find out how Substance Designer can produce satisfactory models  - Know more about the versatility of creating 3D models - Upgrade your modelling process to the latest software available in the market  This course is SkillsFuture Credit Eligible.

      Read More...

    • Discover More of Your Data with Microsoft Excel  - SkillsFuture Online Course

      Discover More of Your Data with Microsoft Excel

      SGD $40.00

      Course Description

      Microsoft Excel is one of the most popular programs to use for analyzing, extracting, and cleaning the tremendous amounts of data that we have collected. Learn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools. Understand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports. This course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.Realise the full potential of your data with Microsoft Excel. - Learn about the functions in Excel that can help your understand data better - Know the different ways of vizualising your data with Excel- Pick up the knowledge of utilizing Excel for better understanding your data- Learn how you can stretch your data for optimum analysis This course is SkillsFuture Credit Eligible.

      Read More...