Interconnecting Cisco Networking Devices Part 2 (ICND2) v. 3
Certification Prep with Practice Exam
Hours: 17
Lectures: 416

Cisco Training for exam 200-105 ICND2 v3.0 is the second part of the two exam series for completing Cisco Certified Network Associate (CCNA) certification.

This course builds on the concepts introduced in CCNA ICND1 v3.0 and introduces new technologies and concepts such as Virtual LAN (VLAN), Quality of Service (QoS), advanced routing protocols (OSPF, EIGRP etc.), VLAN trunking and Spanning Tree Protocol (STP).

This course also enables the students to understand the newly introduced features of network programmability and network virtualization. These concepts are the basics of understanding the software-defined-network architecture (SDN).

Cisco CCNA ICND2 v3.0 is the second course of the Cisco Certified Network Associate (CCNA) series. This course provides the students with the more advanced knowledge of networking technologies and protocols necessary to design, implement, maintain, operate and troubleshoot small to medium sized networks involving multiple devices. The course is equally useful for IT professionals working as network administrators in their organizations as well as support and sales engineers working with system integrators.

Certification Course
$299
Building Cryptocurrencies with JavaScript
Hours: 2.5
Lectures: 15

Any IT professional or hobbyist anticipating a solid understanding of how cryptocurrency technology works and desires an understanding of crypto's use cases and potential (including blockchains and distributed applications) needs to go through this course to leverage cryptocurrency in new or existing development projects. Anyone desiring to learn how cryptocurrency solutions are designed, configured, and developed needs the knowldege and practice presented in this course. This not only includes web, mobile, and service application developers, but also architects, UI designers, testers, and administrators. This course provides a solid understanding of how crypto and blockchain technology works and a solid foundation for platform evaluation and learning lower level details.

Before taking this course, a student should ideally (but not absolutely) have some experience in:
Creating applications with Javascript and Angular
Some exposure to cryptocurrencies, either via the markets or from a technical standpoint
JavaScript development of complete web app solutions with a major JS development platform (Angular)
CRYPTO/BLOCKCHAIN EXPERIENCE IS NOT REQUIRED!!!
Skills Course
$99
Building Cryptocurrencies and Smart Contracts
Hours: 4
Lectures: 21

Any IT professional or hobbyist anticipating a solid understanding of how cryptocurrency and smart contract technology works and desires an understanding of crypto's use cases and potential (including blockchains and distributed applications) needs to go through this course to leverage cryptocurrency and smart contracts in new or existing development projects. Anyone desiring to learn how cryptocurrency solutions are designed, configured, and developed needs the knowldege and practice presented in this course. This not only includes web, mobile, and service application developers, but also architects, UI designers, testers, and administrators. This course provides a solid understanding of how crypto and blockchain technology works and a solid foundation for platform evaluation and learning lower level details.

Before taking this course, a student should ideally (but not absolutely) have some experience in:
Creating applications with Javascript and Angular
Some exposure to cryptocurrencies, either via the markets or from a technical standpoint
JavaScript development of complete web app solutions with a major JS development platform (Angular)

CRYPTO/SMART CONTRACT/BLOCKCHAIN EXPERIENCE IS NOT REQUIRED!!!
Skills Course
$99
Intro to the NEM Blockchain for Developers
Hours: 3
Lectures:27

Any IT professional or hobbyist anticipating a solid understanding of how cryptocurrency and smart contract technology works and desires an understanding of crypto's use cases and potential (including blockchains and distributed applications) needs to go through this course to leverage cryptocurrency and smart contracts in new or existing development projects. Anyone desiring to learn how cryptocurrency solutions are designed, configured, and developed needs the knowldege and practice presented in this course. This not only includes web, mobile, and service application developers, but also architects, UI designers, testers, and administrators. This course provides a solid understanding of how crypto and blockchain technology works and a solid foundation for platform evaluation and learning lower level details.

This course was built for forward-looking developers who need to familiarize themselves with the advanced blockchain technology offered by NEM. With a new, major upgrade rolling out, the material presented here is based on this new NEM version (2.0) code-named Catapult. This course is designed for those developers who want to begin creating cryptocurrencies, smart contracts, and distributed apps onthe NEM blockchain and need a good springboard to start their descent into this deep and detailed set of technologies, theories, and implementations. This course focuses on the outstanding components of NEM technologies and weaves them together to create a solid understanding of the system stack's component interactions and dependencies. Of course, the info presented here is just as valuable for architects, testers, and product managers as they too should understand how the NEM blockchain system is designed and used to create the next level of distributed ledger tech.

This course IS NOT intended for non-technical students. The content presented is in the context of technical review and implementation.

Before taking this course, a student should ideally (but not absolutely) have some experience in:

- Creating applications with Javascript and Angular

- Some exposure to cryptocurrencies, either via the markets or from a technical standpoint

- JavaScript development of complete web app solutions with a major JS development platform (Angular)

- CRYPTO/SMART CONTRACT/BLOCKCHAIN EXPERIENCE IS NOT REQUIRED!!!

Skills Course
$99
Bitcoin Investing Fundamentals

You might think that Bitcoin is for nerds, but it is actually an amazing way to invest your money, pay for things and/or accept payments safely and securely.

Sign up for this course today and begin exploring the amazing world of Bitcoin and integrate it into your daily life.

Who is the target audience?
  • Online entrepreneurs
  • People who want to get into Bitcoin but don't know how
  • People who wan to use cryptocurrency in their daily lives

Disclaimer: We are not lawyers. We are not accountants. This course is not tax, legal or investing advice. If your country has not yet started taxing Bitcoin investment income make sure to keep good records because they likely will at some point.

Skills Course
$49
Complete Steemit Course: Earn Cryptocurrency For Free
Hours: 1.5
Lectures: 13

Steemit is a social media and blogging platform that pays you for posting content.

So, you do what you already do on Facebook, on Instagram, or on LinkedIn, etc. – you post content, you share content, and you comment. However, Steemit PAYS you for doing just that.

Take a look at Steemit. You’ll see a page of posts about anything: travel, food, business, pets, etc. They're earning hundreds or thousands of dollars.

Steemit leverages a revolutionary new technology called the blockchain.

The blockchain is the technology that underpins Bitcoin – the first ever cryptocurrency. In the case of Bitcoin, no 3rd parties (banks, governments, exchanges, etc.) are needed to make transactions – no bank fees, no exchange fees, no central banks, no uncertainty over government interference with the money supply, etc.

And similarly with Steemit, no centralized authority is needed. So no ads, no selling of your personal information, no censorship, etc.

The Steem blockchain protocol, in addition to being able to store value ($$$), can also store content. And it rewards people for creating content, curating content, and even commenting on content with its cryptocurrency Steem.

There are no ads, so where does the money come from?

The Steem protocol, just like that Bitcoin protocol, creates money out of thin air.

Since the decoupling of the US dollar to gold by Richard Nixon in 1971, a system of national fiat currencies has been used. Since the cost of producing any denomination of a national currency is negligible, all money is in fact created out of thin air. However, people believe in a currency’s value and trade with it accordingly. So a US dollar is worth what it is.

It’s the same with cryptocurrencies: their value is derived from how much people believe in them, or are prepared to pay for them. Bitcoin, Ethereum, Steem, and all other cryptocurrencies are traded everyday. Their values go up and down according to the irrefutable laws of supply and demand.

Steemit provides you with a chance to earn rewards in a well regarded cryptocurrency without having to invest any money.

Nothing I recommend you do on this course will cost you a penny. Everything I recommend on this course will earn you money.

Skills Course
$49
Math for Machine Learning
Hours: 5
Lectures: 80

Would you like to learn a mathematics subject that is crucial for many high-demand lucrative career fields such as:

  • Computer Science
  • Data Science
  • Artificial Intelligence

If you're looking to gain a solid foundation in Machine Learning to further your career goals, in a way that allows you to study on your own schedule at a fraction of the cost it would take at a traditional university, this online course is for you. If you're a working professional needing a refresher on machine learning or a complete beginner who needs to learn Machine Learning for the first time, this online course is for you.

Why you should take this online course: You need to refresh your knowledge of machine learning for your career to earn a higher salary. You need to learn machine learning because it is a required mathematical subject for your chosen career field such as data science or artificial intelligence. You intend to pursue a masters degree or PhD, and machine learning is a required or recommended subject.

Why you should choose this instructor: I earned my PhD in Mathematics from the University of California, Riverside. I have created many successful online math courses that students around the world have found invaluable—courses in linear algebra, discrete math, and calculus.

In this course, we will cover the core concepts such as:

  • Linear Regression
  • Linear Discriminant Analysis
  • Logistic Regression
  • Artificial Neural Networks
  • Support Vector Machines
Skills Course
$99
VMware Ultimate Bootcamp vSphere 6.0
Hours: 12
Lectures: 670

The VMware Ultimate Bootcamp vSphere 6.0 is a course that features intensive hands-on training that focuses on installing, configuring, managing and troubleshooting VMware vSphere 6.0, which includes VMware ESXi 6.0 and VMware vCenter Server 6.0. This course enables the candidates to efficiently manage and administer a vSphere infrastructure of any size for any organization. It is the foundation course for most of the other VMware technologies courses and also provides a starting point to explore deeper in the field of software-defined data center.

The VMware Ultimate Bootcamp vSphere 6.0 course covers the fundamental tools and techniques required to plan, install and administer a VMware environment including disaster recovery and backup. It also teaches the students on creating, configuring and securing virtual machines. The students will get a basic understanding of licensing and different components of the VMware vSphere suite of applications. The course will be helpful in preparing for the Certified Virtualization Expert (CVE) exam from VMware.

Skills Course
$99
Employee Motivation
Skills Course
$99
RESTful Services: Fundamentals
Skills Course
$99
OWASP Proactive Controls
Skills Course
$99
OWASP: Threats Fundamentals
Skills Course
$99
OWASP: Forgery and Phishing
Skills Course
$99
OWASP: Avoiding Hacker Tricks
Skills Course
$99
SQL 2014 Developer P1: T-SQL and .NET Code
Skills Course
$99
SQL 2014 Developer P3: Partitions, Queries and XML
Skills Course
$99
SQL 2014 Developer P2: VS 2012 and Data Types
Skills Course
$99
Employee Onboarding
Skills Course
$99
VMware vSphere 6.5 Ultimate Bootcamp
Skills Course
$149
VMware Ultimate Bootcamp vSphere 4.1
Skills Course
$149
VMware Ultimate Bootcamp vSphere 5.0
Skills Course
$149
Vmware sSphere 4.x/5.x to vSphere 5.5 Upgrade and New Technology Ultimate Bootcamp
Hours: 3
Lectures: 40


Skills Course
$149
VMware vSphere 5.5 Ultimate Bootcamp
Skills Course
$149
VMware Advanced Security
Hours: 3
Lectures: 40

Hadoop: Fundamentals training course is designed to give you the basic overview of the Hadoop framework. The course covers the fundamental concepts to process and analyze large sets of data stored in HDFS. The course also briefly touches the more advanced concepts like Sqoop and Flume for data ingestion. The more details about these advanced concepts is covered under the course Hadoop: Intermediate.

The Hadoop: Fundamentals course is part of a two course series which covers the essential concepts in getting to know Hadoop and the big-data analytics. With increasing digital trend in the world, the importance of big data and data analytics is going to continue growing in the coming years. This course will enable the candidates to explore opportunities in this growing field of digital science.

This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce.

Hadoop is becoming an essential tool in the ever-growing Big-Data architecture. This training is designed to benefit:

  • Software developers and architects working in Big-Data organizations
  • Business and technical analytics professionals
  • Senior IT professionals
  • Data management professionals
  • Project managers
  • Data scientists

Skills Course
$99
Hadoop & MapReduce Fundamentals
Hours: 3
Lectures: 40

Hadoop: Fundamentals training course is designed to give you the basic overview of the Hadoop framework. The course covers the fundamental concepts to process and analyze large sets of data stored in HDFS. The course also briefly touches the more advanced concepts like Sqoop and Flume for data ingestion. The more details about these advanced concepts is covered under the course Hadoop: Intermediate.

The Hadoop: Fundamentals course is part of a two course series which covers the essential concepts in getting to know Hadoop and the big-data analytics. With increasing digital trend in the world, the importance of big data and data analytics is going to continue growing in the coming years. This course will enable the candidates to explore opportunities in this growing field of digital science.

This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce. This course will teach students about Hadoop architecture, ETL, and MapReduce.

Hadoop is becoming an essential tool in the ever-growing Big-Data architecture. This training is designed to benefit:

  • Software developers and architects working in Big-Data organizations
  • Business and technical analytics professionals
  • Senior IT professionals
  • Data management professionals
  • Project managers
  • Data scientists

Skills Course
$99
Intermediate Hadoop: Process & Analyze Large Data Sets
Hours: 4.5
Lectures: 54

Hadoop: Intermediate training course is designed to give you in-depth knowledge about the Hadoop framework discussed in our Hadoop and MapReduce Fundamentals course. The course covers the concepts to process and analyze large sets of data stored in HDFS. It teaches Sqoop and Flume for data ingestion.

The Hadoop: Intermediate course is part of a two course series which covers the essential concepts in getting to know Hadoop and the big-data analytics. With increasing digital trend in the world, the importance of big data and data analytics is going to continue growing in the coming years. This course will enable the candidates to explore opportunities in this growing field of digital science.

Hadoop is becoming an essential tool in the ever-growing Big-Data architecture. This training is designed to benefit:

  • Software developers and architects working in Big-Data organizations
  • Business and technical analytics professionals
  • Senior IT professionals
  • Data management professionals
  • Project managers
  • Data scientists
Skills Course
$199
Business Intelligence with Microsoft Excel
Hours: 4
Lectures: 42

Excel 2013 is a game changer for any Excel user. Excel 2013 provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.

This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2013.

In this course we learn the following:

Power Query

  • Cleaning up Data
  • Merging Data
  • Appending Data
  • Grouping Data
  • Loading data to PowerPivot

Power Pivot

  • Create relationships between Tables
  • Manage millions of rows of data
  • Custom Calculations, Key Metrics and KPIs
  • Analyzing Data with Pivot Tables
  • Analyzing Date data

Power View

  • Creating Tables and Cards
  • Visualizing data with Graphs
  • Creating Interactive dashboards
  • Filter and Ask Questions of your Data
  • Powerful data analysis with ScatterPlots and BubblePlots
  • Visualize Geographical data and maps

Power Map

  • Mapping Data with Power Map
  • Changing the Method of Visualization
  • Changing the Method of Aggregation
  • Mapping Data over Time
  • Creating Tours

This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.

Skills Course
$99
Reports and Data Analysis with Excel Pivot Tables
Hours: 2.5
Lectures: 40

Create amazing reports and analyze data in minutes with Excel Pivot Tables. This course focuses on creating and understanding how to use Excel Pivot Tables to quickly analyze and understand your business data. Pivot Tables make it easy to compile management reports and generate new insight and intelligence from your data in minutes.

This Excel Business Intelligence training course is for all business users who are required to develop management reports, analyze data or ask ad-hoc questions of their data. McKinsey Consulting in a recent report entitled 'Big data: The next frontier for innovation, competition, and productivity' emphasizes that data skills will become the basis for competition, innovation, growth and productivity. The report also highlights the need for around 1.5 million managers in United States with data skills.

This course has over 25 video lectures that take you step by step through creating management reports and analyzing data with a couple of clicks of the mouse. The course is structured into 9 sections which takes you from creating simple management reports to sophisticated data analysis.

Learn techniques to easily aggregate your data, produce reports, understand trends, filter your data, create interactive reports and use sophisticated calculations.

So begin your journey today with Excel Business Intelligence.

  • Create management reports in minutes
  • Analyze business data effectively
  • Learn to format Pivot Tables
  • Calculate trends
  • Calculate percentage contributions
  • Create a range of calculations such as rankings and difference from
  • Learn to create frequency analysis with Pivot Tables
  • Use Slicers to analyze data in seconds


Skills Course
$49
Data Analysis and Dashboards with Google Data Studio
Hours: 2.5
Lectures: 62

In this course we are going to show you how to supercharge your Google Sheets into Interactive Dashboards and incredible reports. Google Data Studio works seamlessly with your Google Sheets data to create amazing data analysis in minutes.

Google Data Studio is an incredibly easy to use drag and drop tool that allows a multitude of different visualizations to be created in minutes. The addition of filtering tools produces stunning reports that will take your data analysis to the next level.

Google Data Studio is available for free to people with a Google or Gmail account. In addition reports and dashboards can be shared to any users whether they have a Google account or not.

In this course we are going to teach you the following:

  • How to connect Data Studio to Google Sheets
  • Learn how to calculate Averages, Highest values, Lowest Values and number of Unique Values
  • Create Scorecards to display key metrics and KPIs
  • Create powerful trend analysis graphs to help with forecasting
  • Create Year to Date, Month to Date and Previous Month calculations with the click of a mouse button
  • Learn to gain powerful analysis from Stacked Bar and 100% graphs
  • Create powerful Time and Category filters to easily create interactive reports
  • Learn to share your Reports and Dashboards with other users

Google Data Studio is truly an amazing product for creating insight and intelligence from your Google Sheets data.You will need a Google Account,Google Sheets and Google Data Studio.

Skills Course
$49
Powerful Reports & Dashboards with Microsoft Power BI
Hours: 5.5
Lectures: 69

Microsoft Power BI is continually evolving. We have added the following new lessons to address the new features that Power BI have added in recent months:

  • Using the new Table and Matrix visualizations
  • Creating Drill through between different sheets. For example you could be reviewing a list of Products and want to select one Product to view a summary of this product
  • Themes - Learn how to add new Power BI Themes from the Community Theme Gallery
  • Changes in Custom Visuals - We look at how to easily add Custom Visualizations from the new Microsoft Office Store
  • Creating Apps - Learn how to easily share your dashboards and reports using Power BI apps and App workspaces
  • Relative Date Filters - In this lesson we show how to easily create a dashboard displaying Microsoft stock data. Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters
  • Quick Measures - Learn how to easily create and use Quick Measures. Calculate averages across categories or Year to Date totals on tables.
  • Ribbon Chart - Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.

-----------------------------------------

Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today! Microsoft Power BI is available for free - all you need to do is sign up!

In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions. Power BI uses powerful drag and drop capabilities that make it a breeze to create reports and dashboard. I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop.

This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful PowerBI Desktop Designer.

Skills Course
$99
Complete Introduction to Business Data Analysis
Hours: 4.5
Lectures: 68

The Complete Introduction to Business Data Analysis teaches you how to apply different methods of data analysis to turn your data into new insight and intelligence.

The ability to ask questions of your data is a powerful competitive advantage, resulting in new income streams, better decision making and improved productivity. A recent McKinsey Consulting report has identified that data analysis is one of the most important skills required in the American economy at the current time.

This course focuses on the following different methods of analysis. During the course you will understand why the form of analysis is important and also provide examples of using the analysis using Excel 2013.

The following methods of analysis are included:

  • Comparison Analysis
  • Trend Analysis
  • Ranking Analysis
  • Interactive Dashboards
  • Contribution Analysis
  • Variance Analysis
  • Pareto Analysis
  • Frequency Analysis
  • Correlations

The Complete Introduction to Business Data Analysis is designed for all business professionals who want to take their ability to turn data into information to the next level. If you are an Excel user then you will want to learn the easy to use techniques that are taught in this course.

This course is presented using Excel 2013. Excel 2010 can be used for the majority of the training exercises. Small parts of the course do use Excel Power Pivot and Power View. Please note that this course does not include any complicated formulas, VBA or macros. The course utilizes drag and drop techniques to create the majority of the different data analysis techniques.

Skills Course
$99
Tables and Formulas with Excel
Hours: 3
Lectures: 42

Welcome to this course on Tables, Conditional Formatting and Excel formulas. This course is for all Excel users who want to take their Excel skills and capabilities to the next level.

This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets. The course is presented in an easy to follow step by step approach. The course also includes practical activities for the student to practice the skills that have been learnt in the course.

The course will provide you with a comprehensive understanding of the following:

Tables

  • How to create and format Tables
  • How to easily filter data in text, numeric and date fields
  • Easily Sum, Average, Count and use Max and Min in your tables
  • Use Slicers to easily filter Table data

Conditional Formatting

  • How to apply conditional formatting rules
  • How to easily highlight the Top 10
  • Learn to use Data Bars and Color Scales
  • Learn to apply icons

Formulas

  • Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS
  • Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay
  • Learn Text formulas such as LEFT, MID, RIGHT and TRIM
  • Learn to use the IF formula to create powerful 'IF Then' logic
  • Learn the HLOOKUP and VLOOKUP

This course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.

Skills Course
$99
Interactive Dashboards with Excel Pivot Tables
Hours: 1.5
Lectures: 29

This course is for all Excel users who wish to learn how to create powerful interactive dashboards using Pivot Charts and Pivot Tables. This course will teach you to turn your Excel data into powerful tables, graphs and dashboards.

In this course you will learn to create three different dashboards.

The first dashboard will focus on Sales information creating key metrics, trends, top 10 analysis and a percentage contribution.

The second dashboard will focus on Human Resource data and display key metrics, number of employees by age, number of employees by years of service and gender profile.

The third dashboard focuses on financial information and allows the user to understand the variance of the Profit from previous months and how much it has changed from month to month. In addition techniques and tools such as sparklines, data bars, trendlines and slicers are also included.

This course is very important for all Excel users who are required to develop management reporting or to perform data analysis and wish to gain insight and intelligence from their data.

The course is designed to take you through step by step to create the interactive dashboards using simple drag and drop techniques. This course does not include any custom programming or macros. All the dashboards and techniques can be followed by any Excel user who understands the basic principles of Excel.

An introductory knowledge of Pivot Tables and Pivot Charts will assist you in the course. However you can follow the step by step instructions if you do not have an in-depth knowledge of Pivot Tables and Pivot Charts. Please note that you will require Excel 2010 or 2013 for this course. The course is presented using Excel 2013.

Skills Course
$49
Data Modelling and Analysis with Excel Power Pivot
Hours: 2.5
Lectures: 37

Power Pivot has been described as the most important new feature in Excel in 20 years. Power Pivot has been developed by Microsoft to help companies analyze and understand the growing quantities of data that are created on a daily basis.

Power Pivot will improve your time to create reports, develop data analysis and gain insight into your your data by at least 80%.

  • Create relationships between tables of data without Vlookups
  • Create powerful Key Metric and Key Performance Indicator calculations
  • Manage and work with data models of millions of records of data
  • Create powerful new dashboards and reports

Power Pivot is a free Add-in for Excel 2010 and is called the Data Model in Excel 2013 that provides capabilities to handle large quantities of data. PowerPivot is a columnar database that is capable of storing and manipulating hundreds of millions rows of data. PowerPivot brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. PowerPivot has been referred to as the most important feature for Excel in 20 years.

Power Pivot makes it easy to setup relationships between tables of data in the same way as databases and therefore does not require the use of Excel functions such as Vlookup. PowerPivot therefore decreases the time substantially to analyse and gain new insight from business and marketing data.

Power Pivot allows the rapid development of powerful PivotTables and PivotCharts in Excel utilising the latest Slicer technology to easily analyse and view data from multiple different perspectives. PowerPivot also adds a new Data Analysis Expressions (DAX) formula language that provides new and powerful calculations and insight to the business user.


Skills Course
$49
Excel Productivity
Hours: 2.5
Lectures: 27

Microsoft Excel is the most in demand tool for mining and making sense of data. Anyone that can harness this power will be a sought after employee. If you are running a business, being proficient in Excel can help you see your business in a whole new light.

Leading a team? Boost their efficiency in minutes with this mega packed Excel Productivity course.

Excel Productivity shows you have to work faster and smarter in Excel. You'll pick up great tips that will make working in Excel a pleasure.

Some of the areas covered include:

  • Conditional formatting
  • Various types of sorting
  • Days and years between dates
  • Removing duplicates
  • Viewing multiple sheets in a single view
  • and more

The best part is that the above list will keep growing with great Excel insider, productivity tips for working smarter and faster.

Skills Course
$49
Google Analytics with Google Data Studio
Hours: 1.5
Lectures: 41

If you are a Google Analytics user you will know how much data can be provided to you. However it is not always easy to access this data and make sense of it within Google Analytics. In this course Ian Littlejohn will show you how to easily create your own custom Google Data Studio reports and dashboards that will make it easy to understand your Google Analytics data.

Google Data Studio is Google's latest report and dashboard creation tool. Using a drag and drop interface reports can be created and running in minutes. Google Data Studio also makes it incredibly easy to share your reports with other users.

In this course we will show you how to easily create the following:

Connect to the Google Analytics data source

Understand the Google Data Studio interface

Create Scorecards displaying key information such as Sessions and Users

Create Time Series / Trend graphs displaying how Sessions and Users changes over time

How to setup different filters for your data

Display information using column, bar and pie charts

Create effective maps and geographical analysis

Create powerful interactive dashboards

This course is for anybody who wants to effectively analyze and understand their Google Analytics data.

Skills Course
$49