Microsoft Excel, Intermediate

Wed Dec 11 2024 at 08:30 am to Thu Dec 12 2024 at 04:30 pm UTC-05:00

Employers Network | Spartanburg

Employers Network
Publisher/HostEmployers Network
Microsoft Excel, Intermediate
Advertisement
This class covers skills and information needed to create complex worksheets and to effectively analyze, extract and present information.
About this Event

It is designed for anyone who already has a strong foundational knowledge of Excel and wishes to develop greater proficiency and mastery. Emphasis will be given to the use of advanced functions and PivotTables.

Class format will provide time for the instructor to recommend best practices, explain new concepts, introduce shortcuts, and answer questions. Participants will have time to apply new skills to real world scenarios.


Topics include:

Prerequisite: Excel Fundamentals or equivalent knowledge

• Using defined names to map data & simplify formulas/functions

• Identifying & utilizing specialized functions on an as-needed basis

• Decoding complex function syntax & arguments

• Using logical functions to embed decision making into calculations

• Transitioning from standard to conditional summary functions

• Using functions to pass argument information via nesting

• Calculating data and time information in Excel

• Manipulating text strings with formulas/functions

• Sorting, filtering and subtotaling datasets

• Converting ordinary data ranges to Table Objects

• Using the Table Object functionality to quickly transform data

• Leveraging dynamic ranges to minimize ongoing maintenance

• Using formula-based conditional formatting to highlight related data

• Selecting, creating, modifying and formatting charts

• Creating dual-axis combo charts with forecasting & trend lines

• Determining when to Use Table Objects vs. Pivot Tables

• Summarizing large datasets with PivotTables and PivotCharts

• Analyzing and refining PivotTable reports

• Switching between cross tabulation and nested outline reports

• Redefining how summary values are calculated & displayed

• Creating interactive filters with Slicers & Timelines

• Extracting PivotTable supporting data on the fly


Event Photos
Advertisement

Event Venue & Nearby Stays

Employers Network, 1004 South Pine Street, Spartanburg, United States

Tickets

USD 616.00 to USD 836.00

Sharing is Caring:

More Events in Spartanburg

Microsoft Excel, Fundamentals
Tue Dec 10 2024 at 08:30 am Microsoft Excel, Fundamentals

1004 South Pine Street, Spartanburg, SC, United States, South Carolina 29302

Microsoft Excel, Fundamentals
Tue Dec 10 2024 at 08:30 am Microsoft Excel, Fundamentals

1004 S Pine St

THE FAIRWAY CASH GUARANTEE - SPARTANBURG
Tue Dec 10 2024 at 10:00 am THE FAIRWAY CASH GUARANTEE - SPARTANBURG

SPARTANBURG - 320 E Main St, Suite 301

BUY BEFORE YOU SELL - SPARTANBURG
Tue Dec 10 2024 at 11:00 am BUY BEFORE YOU SELL - SPARTANBURG

SPARTANBURG - 320 E Main St, Suite 301

Art Therapy
Tue Dec 10 2024 at 06:00 pm Art Therapy

Gibbs Cancer Center – Spartanburg

2024 SPARTANBURG CHRISTMAS PARADE
Tue Dec 10 2024 at 06:30 pm 2024 SPARTANBURG CHRISTMAS PARADE

Downtown Spartanburg

Hassle-Free Mealtimes with Children - Parenting Workshop
Wed Dec 11 2024 at 10:00 am Hassle-Free Mealtimes with Children - Parenting Workshop

Hope Center for Children

Cardinal Door Hanger Paint & Pints
Wed Dec 11 2024 at 06:30 pm Cardinal Door Hanger Paint & Pints

Rockers Brewing Co. & Restaurant

BUY BEFORE YOU SELL - HUB CITY
Thu Dec 12 2024 at 10:00 am BUY BEFORE YOU SELL - HUB CITY

SPARTANBURG - 320 E Main St, Suite 301

THE FAIRWAY CASH GUARANTEE - HUB CITY
Thu Dec 12 2024 at 11:00 am THE FAIRWAY CASH GUARANTEE - HUB CITY

SPARTANBURG - 320 E Main St, Suite 301

In the Mix
Thu Dec 12 2024 at 05:30 pm In the Mix

Denny's Corporate Headquarters - 17th Floor

SYP & Santa
Thu Dec 12 2024 at 05:30 pm SYP & Santa

AC Hotel Spartanburg

Spartanburg is Happening!

Never miss your favorite happenings again!

Explore Spartanburg Events