Find COVID-19 Resources to Keep Your Business Compliant and Your Employees Safe. View Products

 
Search

Advanced Skills for Excel Beginning Course

Brush-up on Useful Excel Skills

 

In this 3-course bundle, you’ll learn or brush-up-on critical Excel skills, including Pivot tables, VLOOKUP and SUMIF. This course specifically includes skills that are helpful when reporting on employment and payroll data.

 

Lesson 1: 10 Ways to Improve Excel Workbooks

Lesson 2: Reporting with Pivot Tables

Lesson 3: VLOOKUP and SUMIF Excel Functions  

 


*This product is non-refundable*

SKU: D1000
Free shipping
PRICE BREAKS - The more you buy, the more you save
Quantity
1+
5+
10+
Price
$249.00
$199.00
$149.00
$249.00
decrease increase

Join thousands of professionals who choose HRdirect® and Clear Law Institute for practical and engaging continuing education. Get 24/7 on your computer, tablet, or smartphone. Enjoy learning with courses provided by leading experts who are also engaging speakers. Learn at their own pace with a year’s access to these top rated courses.

 

Join thousands of professionals who choose HRdirect® and Clear Law Institute for practical and engaging continuing education. Get 24/7 on your computer, tablet, or smartphone. Enjoy learning with courses provided by leading experts who are also engaging speakers. Learn at their own pace with a year’s access to these top rated courses.

 

Webinar 1: 10 Ways to Improve Excel Workbooks

100 Minutes

In this webinar, you’ll learn about 10 simple ways to improve your Excel workbooks and make them easier to manage. Upon completion of this course, you will be able to:

  • Identify 10 simple techniques you can use to improve your Excel workbooks
  • Recognize and avoid potential errors
  • Utilize a function that builds Excel reports more efficiently than the SUM function
  • Integrate new worksheet rows into your reports and ensure they are automatically included in your formulas

Webinar 2: Reporting with Pivot Tables

100 Minutes

The PivotTable feature of Excel creates PivotTable reports that help you complete your reporting tasks faster. In this webinar, you’ll learn how to use the PivotTable feature of Excel and create reports without writing a single formula. Upon completion of this course, you’ll be able to:

  • Explain what PivotTable reports are and describe their benefits
  • Utilize Excel’s PivotTable feature
  • Create PivotTable reports quickly and confidently

Webinar 3: VLOOKUP and SUMIF Excel Functions   

100 Minutes

In this practical webinar, you’ll learn about two critical Excel functions, VLOOKUP and SUMIFS. VLOOKUP is the traditional and perhaps the most popular Excel lookup function, but SUMIFS, a relatively new function, is quickly gaining traction among Excel users. Upon successful completion of this course, you will be able to:

 

Identify the features of the VLOOKUP and SUMIFS Excel functions

Utilize the VLOOKUP function to return a related value

List the four arguments of the VLOOKUP function

Utilize the SUMIFS function to perform conditional summing

Recognize the arguments of the SUMIFS function

Compare and contrast VLOOKUP and SUMIFS

 

Write your own review
*
*
  • Bad
  • Excellent

test

Filters
Sort
display