LANTEC Logo
BACK
LANTEC | Course: Custom Excel Level 2 for Rain Bird

Custom Excel Level 2 for Rain Bird

$150.00
1/2 days
Audience
Share
Print

 

Description:

 Excel Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex,realistic data in Microsoft Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

This course is a custom course for Rain Bird employees only 

Class Times:

August 12 & September 30: 1:00 PM - 5:00 PM Central Time 

September 9 & September 30 - 8:00AM - 12:00PM Central Time

Outline:

Chapter 1: Managing workbooks 

  • Module A: Managing worksheets
  • Module B: Customizing Excel

    • Chapter 2: Named ranges

  • Module A: Using names in formulas

    • Chapter 3: Tables

  • Module A: Sorting
  • Module B: Filtering tables
  • Module C: Structured references
  • Module D: Validation
  • Module E: Transposing data

    • Chapter 4: Summarizing data

  • Module A: Consolidation
  • Module B: Subtotals

    • Chapter 5: PivotTables

  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: PivotCharts


    • Scheduled Courses

    Aug 12, 2024
    vILT (Virtual)
    Enroll
    Sep 09, 2024
    vILT (Virtual)
    Enroll
    Sep 30, 2024
    vILT (Virtual)
    Enroll
    Sep 30, 2024
    vILT (Virtual)
    Enroll

    Need to Request This Course On a Different Day?

    LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
    Want to schedule it?


    "He was fabulous! So patient, thorough, and spoke at a great speed."