• Enrollment system is currently unavailable. We apologize for the inconvenience. Please try again later.

Excel: Advanced Tools and Techniques

Become an Excel power user and increase your efficiency and expertise in this key business application. Discover how to consolidate data across workbooks, control the type of data to be entered in a specific cell or range of cells, and create drop-down lists. Increase your knowledge by understanding how to use the advanced functions with emphasis on the most useful for all types of fields. Get familiar with Excel’s powerful pivot table tool to analyze, summarize, and present data in reports and pivot charts, while using slicers as the dashboard for the displayed data. Learn to apply conditional formatting to your data so that you can instantly understand the trends in it. Save time by recording and running macros to automate tasks that you perform repetitively. Learn how to protect data in a worksheet, and much more.

More details

You'll Walk Away with

  • An understanding of how to find and use advanced Excel functions
  • The skills to automate repetitive tasks by creating macros that run tasks with just one click
  • Familiarity with all aspects of manipulating, moving, and analyzing data in pivot tables, pivot charts, and slicer dashboards to produce various essential reports
  • The ability to consolidate data across workbooks, control the type of data to be entered in a cell or a range of cells, and create drop-down lists using the data validation tool

Ideal for

  • Professionals from entry to senior level in any industry
  • Those who already have formal intermediate Excel training
  • Those who know how to manually write the basic functions and to use the auto functions, the fill handle, fill handle options, and cell naming

2 sections

  • Summer 2018
    • Section

      001
    • Semester

      Summer 2018
    • Date

      Jul 19 - Aug 9
    • Day

      Thursday
    • Time

      6:30PM-8:30PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      4
    • Faculty

      St. Mark, Daisy
    • Location

      Midtown Center
    • Section

      002
    • Semester

      Summer 2018
    • Date

      Aug 8 - Aug 8
    • Day

      Wednesday
    • Time

      9:00AM-5:00PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      1
    • Faculty

      St. Mark, Daisy
    • Location

      Midtown Center
Toggle

Closed

    • Section

      3
    • Semester

      Spring 2018
    • Date

      Mar 7 - Mar 7
    • Day

      Wednesday
    • Time

      9:00AM-5:00PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      1
    • Faculty

      Diperna, Mary
    • Location

      Midtown Center
    Tuition $325
    • Section

      4
    • Semester

      Spring 2018
    • Date

      Apr 5 - Apr 26
    • Day

      Thursday
    • Time

      6:30PM-8:30PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      4
    • Faculty

      St. Mark, Daisy
    • Location

      Midtown Center
    Tuition $325
    • Section

      5
    • Semester

      Spring 2018
    • Date

      Apr 25 - Apr 25
    • Day

      Wednesday
    • Time

      9:00AM-5:00PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      1
    • Faculty

      St. Mark, Daisy
    • Location

      Midtown Center
    Tuition $325