For full functionality of this site it is necessary to enable JavaScript. Here are the instructions how to enable JavaScript in your web browser.

Excel as a BI Tool

Tom Fragale is Keynote Speaker at Ijona Skills. He is a computer professional with over 30 years of professional experience. He has extensive experience in consulting and providing custom software solutions. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as........

Read More

Overview

If you work with data, you're likely already familiar with common frustrations with Microsoft Excel like size limitations and manually entering data from multiple sources. Luckily there are two Microsoft tools- Power Pivot and Power Query-that solve ALL of these issues, right inside Excel. No Access databases or IT department ........

Why should you attend?

Power Query and Power Pivot complement each other. Power Query is the recommended experience for discovering, connecting to, and importing data. Power Pivot is great for modeling the data you've imported.

Power Pivot helps you overcome Excel's limitations when it comes to working with massive datasets. Using the add-in you can import over 1 million row datasets, from virtually any source. However, that's not all. Power Pivot is also really handy for creating pivot tables from multiple datasets. You'll not have to bother with lookup, and you can forget about multiple consolidation ranges.

Power Query can save you a lot of time when working with imported data. Often, when data is imported from external sources, it needs work on it, before it can be used. Unnecessary rows and columns may need to be removed, blank spaces may need to be deleted, and data may have to be merged or split. All of this can be done on Excel, but with Power Query, things move a lot faster. It can also handle much more data, and you can save query definitions on it to increase ease of usage in the future.

Areas Covered in the Session:

  • Creating and managing Pivot Tables.
  • Changing the calculation type
  • Adding additional calculations
  • Creating custom calculations
  • Multilayer reports
  • Creating Daily, Monthly, quarterly and yearly summaries
  • Adding A pivot chart
  • Adding Slicers
  • Adding timelines

Who can Benefit:

  • Business owners 
  • CEO's / CFO's / CTO's
  • Managers of all levels
  • Administrators
  • Salespeople
  • Trainers
  • Bankers
  • Anybody who uses Excel on a regular basis, and want to be more efficient and productive

Webinar Id: ISSETF005

Duration: 75 mins

Ratings:
No reviews yet!!

   

Refund Policy

Webinars of Tom Fragale
Introduction to MS Power BI for Dashboards
Presenter: Tom Fragale

View Anytime
Price: $167
Status: Archived

Excel Dashboard for the Financial Professio...
Presenter: Tom Fragale

View Anytime
Price: $167
Status: Archived

Webinars of Soft Skills
Boost Your Leadership IQ: How to Successful...
Presenter: Mark Hordes

View Anytime
Price: $167
Status: Archived

Zap! You're a manager: getting off on the r...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $167
Status: Archived


top