Online Safety Community

Excel - Functionality, Power Query is a lot Faster

Event Details

Excel - Functionality, Power Query is a lot Faster

Time: September 22, 2017 from 10am to 11:30am
Location: Online
Street: 161 Mission Falls Lane, Suite 216
City/Town: Fremont
Website or Map: http://www.compliance4all.com…
Phone: 8004479407
Event Type: webinar
Organized By: Adam Fleaming
Latest Activity: on Monday

Export to Outlook or iCal (.ics)

Event Description

Overview:
If you've been frustrated by other limitations of pivot tables then Power Pivot
is for you. Simply put, Power Pivot takes pivot tables and data analysis to the
next level. If you're a fan of pivot tables, you'll love Power Pivot.

Areas Covered in the Session:
Importing data into Excel from external sources
Creating pivot tables from multiple sources
Creating relationships and data models
Introduction to DAX formulas
Cleaning and transforming data using Power Query
Combining data from Multiple Tables

Who Will Benefit:
Excel users who are familiar with PivotTable concepts,but need expanded techniques to analyze lists of data
Anyone needing to know how to create PivotTables from multiple sources, use Slicers, Timelines, Calculated Fields, and Conditional Formatting will benefit from this course

Speaker Profile:
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

Event Cost & Details:
One Dial-in One Attendee Price: US$150.00

Contact Detail:
Compliance4All DBA NetZealous,
Phone: +1-800-447-9407
Email: support@compliance4All.com

Comment Wall

Comment

RSVP for Excel - Functionality, Power Query is a lot Faster to add comments!

Join Online Safety Community

Attending (1)

Take our poll!

Take our poll!

Latest Activity

kate smith posted blog posts
3 hours ago
Adam Fleaming posted blog posts
5 hours ago
John Robinson posted a blog post

Training and Development is a highly developed and evolved, broad body of knowledge. Many employees place themselves at a disadvantage vis-à-vis their colleagues in the absence of the right professio…

Training and Development is a highly developed and evolved, broad body of knowledge. Many employees place themselves at a disadvantage vis-à-vis their colleagues in the absence of the right professional training and development. If employees have to consistently close gaps in their learning, they need to keep upgrading their knowledge and skills. They should also use training…See More
yesterday
Roger Steven posted a blog post

Ensuring compensation-focused compliance with Stark Law considerations

Stark Law compliance is now more than just a compliance issue. It has grown to become an Enterprise Risk Management matter, if the substantial awards and settlements in recent enforcement actions are anything to go by. For healthcare organizations that develop and implement provider contracts; managing their compliance and…See More
Tuesday

Forum

What is Class Structure in Pega?

Class contains the rule by way of which objects behave. outline rules such as houses, sports, flows, html paperwork, etc. to be had to different subordinate classes. lessons are organized into a…Continue

Started by Soujanya Naganuri on Monday.

How to Concatenate Two Tables in QlikView

Table combining and concatenationConcatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows of…Continue

Tags: datafields, developers, qlikview

Started by Soujanya Naganuri Jun 30.

SQL Server Windows Management Instrumentation Tasks

Hello,SSIS includes two special tasks that enable you to query system information and monitor system events: the WMI Data Reader Task and the WMI Event Watcher Task. These tasks are especially useful…Continue

Tags: Task, WMI, Server, SQL

Started by Madison Quinn Jun 20.

difference between NEBOSH and IOSH

NEBOSH “National Examination Board in Occupational Health and Safety”IOSH “Institution…Continue

Tags: kerala, IGC, NEBOSH

Started by mani May 31.

What's your favorite motivational/safety quote? 98 Replies

Favorite Motivational Quote: If you want something, you'll find a way - If not, you'll find an excuse.Favorite Safety Quote: Don't learn safety by accident!Continue

Started by Michelle Sears. Last reply by David R Snell Apr 26.

Badge

Loading…

© 2017   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service