Why MS Excel Pivot Tables?

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

Obtain a certificate in several of the most practical courses in the industry at School of IT. Thus the available programming programmes include Access, word, PowerPoint, Excel, Publisher and the Microsoft Office Specialist Certification (MOS).

The Pivot Table Courses South Africa Overview

At School of IT, excel consists of several valuable knowledge sets and skills. In turn this is because the process of creating spreadshets requires expertise in many different skills. Including knowledge of the Microsoft application. Not to mention the application, presentation skills and the fact you will learn logic (Functions and formulas – Excel). At School Of IT our Excel courses range from an introduction to excel to more advanced Excel.

Who should attend the course?

Whether you are new to Office (Excel, Access, PowerPoint, word, Publisher) or need more advance office training. In turn The introduction to Microsoft Office Courses will provide you the best beginner skills. Moreover it will provide you with logic and the knowledge to start using excel after completing the course.

Part-Time

Fast forward your career in the industry with a part-time course at School Of IT. In turn Part-time courses allow working professionals to transition into a new skill set while working. Moreover at School Of IT we are agile and customize a course to the individual.

Full Time

Ready to start being competent in Office (Excel,Access, PowerPoint, word, Publisher)? Learn the Office Suite as a full time student at School Of IT. Thus adding value.

High School

Prepare for the future while you’re still in high school. Thus giving you the skills and knowledge to pursue your dreams!

Corporate

Learn and up skill yourself or your company while you’re working.

More about Pivot Table Courses South Africa

All in all our Pivot Table Training Courses in South Africa are aimed at developing your skills. Thus giving you valuable insight into various functionality. In turn this empowers you to make decisions about your career and valuable future.

At School Of IT we specialize in Software Programmes and the course that prepare you for the world of work. Thus acts as a very effective skill to further your studies in any of our Microsoft Certifications. In turn you will develop the knowledge and skills for work environment.

About the Pivot Table Courses South Africa

At School Of IT you can become a Microsoft Office Specialist(MOS) or a Excel, Access, word, PowerPoint, Publisher Expert. Therefore with our certificate in Office. In turn you are well ahead in Office(Excel, Access, PowerPoint, word, Publisher) and companies will recognize you as a skilled and competent person. Thus what each student learns is valuable and thus adds value to your life. In turn a long career growth. Thus sign up today for outstanding training!

All in all we provide one on one training and as a result students gain industry knowledge. Thus this is what separates you and us from the rest.

Have the option to become the Microsoft Office Specialist(MOS). In turn it focuses mainly on using word, Excel, Access, PowerPoint and Outlook. All in all it can set your skills apart thanks to the validation that the Microsoft Office Specialist Certification(MOS) provides.

Why The Excel Courses?

Microsoft Office suite is probably the most widely-used all over the world. Not to mention it is the one software that is used the most. All in all the workplace requires a proficiency in Microsoft Office. Most often Excel and PowerPoint even a basic understanding of word. I.e to create a spreadsheat.

Microsoft Pivot Table Course

• Making data work more efficiently
  Maximising the options of the Pivot Table
• Contents of the Pivot table.
  Define what you need to know
  Different views of data.
  Layout of the Pivot Table
  Pivot table results.
• Working on the Pivot table
  Adding a new field
  Formatting numbers
  Rearranging the layout
  Refresh
  Removing a field
  Renaming fields
  Results
  Sorting, and re-arranging Auto show
• Creating a quarterly Group
  Displaying subtotals
  Formatting a report.
  Formatting a slicer.
  Grouping data manually
  Hide or display totals
  Using a slicer.
• Advanced options
  Create customised calculations.
  Create a Second Data Field.
  Displaying Numerical Data as a Percentage
  Functions in Custom Calculation
  Summarising Data
• Advanced Pivot Table Calculations
  Creating a Calculated Field.
  Creating a Calculated Item
  Using Formulas
  Using the Get Pivot Table function
  Using Pivot Table Data outside the report.
  Turn off the Get Pivot Data function
• Create a Pivot Chart Report.
• Publishing Pivot Table Reports to the Web
• Using multiple ranges as Source Data

Excel Courses: Level 1

• Not to mention creating a basic worksheet.
• Overall identify the user interface and customize the interface.
• Work with cells and enter data in an workbook.
• Create basic formulas.
• All in all calculate using functions.
• In turn copy formulas and functions.
• Overall manipulate worksheet data and modify worksheet elements.
• Search worksheet data and modify Rows and columns.
• Modify and work with fonts.
• Spell check a worksheet.
• Overall apply number formats.
• In turn add borders and color to cells.
• Align cell Contents.
• Not to mention apply cell Styles.
• All in all set page breaks and page layout options.

Excel Course: Level 2

• Apply cell and range names.
• Overall Calculate data across worksheets.
• In turn use Specialized Functions and analyze data with logical functions.
• Create and modify tables including sort or filter worksheet or table data.
• In addition use functions to calculate data in a worksheet.
• Presenting data using charts and graphics.
• Not to mention create a pivot table report.
• Filter data using slicers.
• Insert and modify pictures and clip art.
• Modify and draw shapes.
• Thus illustrate workflow using smart art graphics.
• Overall use the layer and group graphic objects.

Excel Courses: Level 3

• Create a macro and edit a macro.
• Apply conditional formatting.
• Add data validation criteria.
• Trace cells and troubleshoot errors in formulas.
• In addition watch and evaluate formulas.
• Create a data list outline.
• Create a trend line.
• Including creating sparklines and create scenarios.
• Perform analysis and statistical analysis.
• Overall create a workspace.

See the full list of Microsoft Office Courses

Microsoft Excel

Would you like to learn Microsoft Office Software packages?