Professional Course

Intermediate Excel Financial Reporting

1 hour
149 USD
Next course start
Start anytime See details
Self-paced Online
1 hour
149 USD
Next course start
Start anytime See details
Self-paced Online
This provider usually responds within 48 hours 👍

Course description

Intermediate Excel Financial Reporting

Streamline financial reporting and analysis by using Excels limitless features.

The emphasis of this intermediate Excel class will provide timesaving techniques that will allow you to utilize the builtin features of Excel for analysis of data and perfection of reports. Learn the most commonly used functions and tools for successful reporting. Microsoft Excel skills are invaluable for a business. Whether creating reports or analyzing data, Microsoft Excel makes managing and tracking a breeze. Increase your productivity and effectiveness as a professional.

Do you work at this company and want to update this page?

Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

Upcoming start dates

1 start date available

Start anytime

  • Self-paced Online
  • Online

Who should attend?

This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, sales and marketing professionals, directors, and accountants.

Training content

Tips and Review

  • Customizing Lists
  • Utilizing Filters and Data Validation
  • Quick Formatting Tricks

Creating and Working With Multiple-Sheet Files

  • Creating a Multi-Sheet Workbook
  • Writing a 3-D Formula for Calculations
  • Formatting Multiple Sheets Simultaneously
  • Creating Links Between Workbooks

Excel Formulas

  • Nested Subtotals
  • Using IF Functions (Conditional Statements)
  • VLOOKUP Formulas and Arrays
  • Understanding PivotTables and PivotCharts

Using Text Functions

  • Using the Text to Columns Feature
  • Using the Concatenate Function
  • Using the TRIM Function
  • Using the Upper, Lower, and Proper Text Functions
  • Using the Paste Values and Paste Specials Feature

Charting Data in Excel

  • Creating Combination and Specialty Charts
  • Changing Chart Options

Certification / Credits


Learning Objectives

  • You will be able to identify how to create combination and specialty charts.
  • You will be able to recognize the most commonly used functions and tools for successful reporting.
  • You will be able to explain how to utilize filters and data validation.
  • You will be able to review the best practices for reporting in Microsoft Excel.

Contact this provider

Contact course provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Lorman Education Services
Lorman Education Services
2510 Alpine Road
54702 Eau Claire Wisconsin

Lorman Education Services - Live and On-Demand Courses

Lorman Education Services is a leading provider of online professional development and corporate training for organizations and individual professionals. For more than 30 years, Lorman has delivered relevant, high-quality, professional-level courses that cover a broad range of business and technical...

Read more and show all training delivered by this supplier