Excel Training Kit: 6 Excellent Crash Courses on Microsoft Excel Available in USBs and CDs

Speaker

Instructors: Joe Weil, Mike Thomas
Product ID: 706463

Location
  • Duration: 8 Hrs
RECORDED TRAINING

 

$1,099.00 $2,198.00 (50%)SAVE: $1,099.00
Downloadable file is for usage in one location only. info Downloadable link along with the materials will be emailed within 2 business days
(For multiple locations contact Customer Care)

 

 

Customer Care

Fax: +1-650-362-2367

Email: [email protected]

Read Frequently Asked Questions

 

You can accomplish incredible things with the Excel spreadsheet application. It makes the job easier, and faster for a wide variety of professionals including those in HR, finance, management, sales, marketing and many more.

However, since many people are unaware of the advanced use of this powerful tool, they create new sheets every time instead of reusing or updating their already created sheets. Our training kit consists of 6 excellent crash courses to help you ensure that you’re creating spreadsheets that are efficient as possible.

By taking these courses, you will save hours of time in performing the same actions or tasks in spread sheets. You will explore excel hacks, structural tips, formatting tips, formula tips, forecasting tips, business intelligence tips, import of csv tips, and much more.

Order the Excel training kit today!

All Modules:

Module 1: Excel: Power Query - How to Import and Clean Data Quickly
Module 2: MS Excel: Advanced Pivot Tables for Superior Data Analytics
Module 3: Excel: Building a Reporting Tool with Pivot Tables and Charts
Module 4: Automating Excel: An Introduction to VBA
Module 5: How To Dynamically Model Cash Flow Projections For Rapid Changing Assumptions
Module 6: Automating Excel: An Introduction to VBA

Part 1 : Excel: Power Query - How to Import and Clean Data Quickly
Instructor: Mike Thomas

Areas Covered in the Webinar:

  • Importing data into Excel from sources such as text files, web pages and databases
  • Avoiding Excel’s "million-rows limitation” by connecting to external data sources
  • Updating the imported data (when the source data changes) with two clicks
  • Creating Pivot Tables from external data sources
  • Using the Query Editor to quickly clean and transform data to make it usable
  • Using the Query Editor to create calculated columns

Part 2 : MS Excel: Advanced Pivot Tables for Superior Data Analytics
Instructor: Joe Weil

Areas Covered in the Webinar:

  • Structuring Your Source Data
  • Rapidly Inserting Your First PivotTable
  • Navigating the Field List
  • Manipulating PivotTable Views
  • PivotTable Options Using Analyze and Design
  • Quickly Moving or Copying Pivot Tables
  • Automatically Managing Dynamic, Growing Source Data
  • Refreshing and Updating Data (Critical)
  • Number Formatting Including Custom Number Formats
  • Rapidly and Automatically Formatting Empty Cells To Avoid Problems

Part 3 : Excel: Building a Reporting Tool with Pivot Tables and Charts
Instructor: Mike Thomas

Areas Covered in the Webinar:

  • Use cases: Why and when you should use a Pivot Table
  • Your raw data - do’s and don’ts
  • Create a simple Pivot Table with a few mouse clicks
  • Different ways to summarize your data - total, count and percent
  • Apply formatting to a Pivot Table to make it easy to read and understand
  • Display Pivot Table data in alphabetical or numerical order
  • Represent the Pivot Table data as a chart/graph
  • How to update a Pivot Table when the source data changes

Part 4 : Automating Excel: An Introduction to VBA
Instructor: Mike Thomas

Areas Covered in the Webinar:

  • Getting familiar with the VBA Editor
  • Understanding VBA jargon such as procedures, modules, methods and properties
  • How to edit an existing macro
  • How to write a simple macro from scratch using VBA
  • Creating inline documentation
  • Using VBA to control what happens a file is opened or closed

Part 5 : How To Dynamically Model Cash Flow Projections For Rapid Changing Assumptions
Instructor: Joe Weil

Areas Covered in the Webinar:

  • Understanding the Statement of Cash Flows
    • Three Primary Sources and Uses of Cash
    • Cash Flow Planning: Cash Flow from Operations v. Free Cash Flow
    • Overview of the Corporate Treasury Function
  • Accrual vs. Cash Accounting: Cash Flow Timing
    • Understanding the Business Operating Cycle and Bridge Loans or “Gap” Financing
    • Service Industry v. Retail and Manufacturing
    • Sales, Receivables, Collections and Cash Flow Timing
    • Inventory, Payables, Disbursements and Cash Flow Timing
    • Expenses v. Cash Flow
  • Constructing a Basic Excel Cash Flow Template
    • Overview: Assumptions, Receipts, Disbursements, Net, Beginning Balance, Ending Balance
    • Connecting the Sales Forecast to Bad Debt and Collections and Cash Flow Timing via Cell References
    • Connecting the Expenses Forecast to Disbursements and Cash Flow Timing via Cell References
    • Incorporating Timing into Assumptions via Cell References
    • Simple Necessary Formulas
  • Constructing Excel Spinners for Professional Polish
    • Form Control and Excel Spin Button
    • Cell References to Tie the Spin Button to the Assumptions for the Cash Flow Statement
  • Communicating and Solving Forecasted Problems – Banker Communications
    • Charting Techniques for Easy Communication
    • Dealing with Seasonality Timings
    • Forecasting Borrowing Needs and Repayment
    • Integrating Spinners and Charts for a Professional Presentation

Part 6 : Automating Excel: An Introduction to VBA
Instructor: Mike Thomas

Areas Covered in the Webinar:

  • Getting familiar with the VBA Editor
  • Understanding VBA jargon such as procedures, modules, methods and properties
  • How to edit an existing macro
  • How to write a simple macro from scratch using VBA
  • Creating inline documentation
  • Using VBA to control what happens a file is opened or closed
Follow us :

 

 

Refund Policy

Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange. Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar please contact us at below email or by call mentioning your feedback for resolution of the matter. We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).

 

 

+1-888-717-2436

6201 America Center Drive Suite 240, San Jose, CA 95002, USA

Follow Us

facebook twitter linkedin youtube

 

Copyright © 2023 ComplianceOnline.com MetricStream
Our Policies: Terms of use | Privacy

PAYMENT METHOD: 100% Secure Transaction

payment method