Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Excel Charts and Pivot Tables

EDUTAINMENT COURSE

Excel Charts and Pivot Tables

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

Can you create a chart or run a report in Excel for Windows? Can you make a dashboard? In this series,  learn how to create charts,   PivotTables,   and PivotCharts.   In this Daniel and Vonne kick off the Excel Charts and Pivot tables series by building your foundational knowledge in regards to Charts.   Here they will identify the parts of a Chart,   define terms used,   and look at the contextual tabs you'll use when working with Charts.

Objectives
  1. Interpreting a Data Dictionary.
  2. Creating a PivotTable.
  3. Manipulating PivotTable Fields.
  4. Using Slicers.
Prerequisites
  • Navigate an Excel spreadsheet
  • Create basic formulas
  • Sort and filter data
  • Work with tables
  • Manage named ranges
Target Audience
  • Individual
  • Accountants
  • Auditor
  • Financial analyst
Instructor: ITProTV

ITProTV delivers the IT instruction that you need to advance or launch your IT career in a fun and creative way. With attractive studios and an interactive, talk-show style format, you'll watch more and learn more. From CompTIA, Cisco, and Microsoft to Security and Cloud Fundamentals, you can learn it all. Dive deep into one or master many with the friendly faces of IT training.

  1. CHARTS
7
Start
Create Charts From Noncontiguous Data
8
Start
Create A Pie Chart
9
Start
Sparklines And Timelines
10
Start
Filled Map Charts
  1. PIVOT TABLES AND PIVOT CHARTS
11
Start
Create A Basic Pivot Table
12
Start
Create A Basic Pivot Chart
EDUTAINMENT COURSE
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59 USD 19 68% OFF
  • 03:38:00
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top