logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel Bits & Bytes: Intermediate Part 2

SS Course: 3000500

Course Overview

TOP

During this one-hour live webinar session, our top-rated instructor will demonstrate intermediate Excel tasks. Students are encouraged to ask questions in the chat window at any time during the demonstration.

This is a demonstration style webinar and Q&A Session only, no software/files required.

                                                                  

Scheduled Classes

TOP
05/22/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)
08/07/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP

During this live demonstration you will learn to:

  • Create custom lists
  • Create & Use named ranges
  • Link Information
  • Use conditional formatting
  • Protect specific cells
  • Perform quick analysis

Outline

TOP
Viewing outline for:
  • Creating Lists
    • Custom Lists
    • Drop Down Lists
  • Creating and using Named ranges
  • Linking information
    • URLs
    • Files
  • Using conditional formatting
    • Rules
    • Data bars
    • Colors
  • Protecting specific cells
  • Performing Quick analysis
    • Totals
    • Charts

Prerequisites

TOP

None

    Who Should Attend

    TOP

    Students familiar with Excel, who wish to enhance their skills.

    Next Step Courses

    TOP

    Other Bits & Bytes sessions and Microsoft Office courses.