FORGOT YOUR DETAILS?

Excel Power View for Advanced Users

Live Online Learning (1 Hour)

This Excel Power View for Advanced Users online training is designed for people who are confident with creating Excel Power View reports, and want to take their knowledge to the next level and unlock new functionality.

This expert-led session will teach you how to manage the tables within your report and manipulate data much more effectively.

This Excel Power View for Advanced Users training is suitable for users of Excel 2013 and 2016.

What Will I Learn?

How to sort tables and charts - Start sorting your Excel Power View table or chart using a chosen field, and change the sort order from ascending to descending.

How to master the Sort by Column command - Learn how to change the sort order of a field using another field.

How to interact with a report - Add interactivity by creating filters for your report, as you convert a field into a slicer.

How to apply interactive filtering - Apply filter criteria to your tables or charts, and learn to apply filters to the whole report.

How to modify your Power View report using themes - Change the look and feel of the report using themes, and setting background images.

Requirements

You should have a good understanding of Excel, and have attended the Excel Power View for Beginners session. You should also have a good experience of using Power Pivots and Power Charts, or have attended the How to Use Excel Power Pivots session.

What Are Live Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.

Cost:

£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e: info@escalla.co.uk

Course Content

  • How to sort the table or chart using a chosen field
  • How to change the sort order from ascending to descending
  • How to change the sort order of a field using another field
  • How to convert a field into a slicer, to filter the report
  • How to apply filter criteria of a table or chart
  • How to apply a filter to the whole report
  • How to change the look and feel of the report using themes
  • How to set background images
TOP