Microsoft Excel Level 3
- Advanced
- 14 and older
- $350
- 230 W Monroe St, Chicago, IL
- 7 hours & 30 minutes
Apr 22nd
9am–3:45pm CDT
Discover Classes. Earn Rewards.
Microsoft Excel Level 3 is unfortunately unavailable
Thankfully we have 13 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
Excel Introduction
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Learn the basics of creating spreadsheets in Excel, from entering data and formulas to formatting and printing workbooks. Perfect for individuals whose job responsibilities include creating and inputting basic spreadsheets. Enhance your Excel skills with this comprehensive course.
$295
2 Seats Left
Apr 24th
9am–3:45pm CDT
$295
2 Seats Left
Apr 30th
9am–3:45pm CDT
$295
2 Seats Left
May 2nd
9am–3:45pm CDT
$295
2 Seats Left
May 10th
9am–3:45pm CDT
$295
2 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, Apr 22nd, 9am–3:45pm CDT
(6 hours & 45 minutes)
Other dates (4)
Excel Advanced
Computer Training Source, Inc. @ 1821 Walden Office Sq, Schaumburg, IL
Master advanced Excel formulas, VLOOKUP, IF functions, data validation, macros, and more at Computer Training Source, Inc. Expand your Excel skills and become proficient in advanced data management and analysis tools. Gain the expertise to create custom functions and automate tasks with macros.
Apr 17th
9am–4pm CDT
$499
6 Seats Left
May 2nd
9am–4pm CDT
$499
6 Seats Left
May 9th
9am–4pm CDT
$499
6 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Wed, Apr 17th, 9am–4pm CDT
(7 hours)
Other dates (2)
Excel Introduction
Computer Training Source, Inc. @ 1821 Walden Office Sq, Schaumburg, IL
Unlock the full potential of Microsoft Excel with this comprehensive course. Learn how to navigate the user interface, perform calculations, modify and format worksheets, and efficiently print workbooks. Gain essential skills for managing multiple worksheets and workbooks effectively.
Apr 30th
9am–4pm CDT
$399
6 Seats Left
May 7th
9am–4pm CDT
$399
6 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Tue, Apr 30th, 9am–4pm CDT
(7 hours)
Other dates (1)
Excel Database Features and PivotTables
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Master the essential Excel database features and unlock the power of PivotTables in this highly sought-after course. Discover how to manage and analyze data effectively, create tables, and enhance your data analysis skills. Don't miss out - secure your spot now!
Apr 22nd
9am–3:45pm CDT
$295
2 Seats Left
Apr 30th
9am–3:45pm CDT
$295
2 Seats Left
May 16th
9am–3:45pm CDT
$295
2 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, Apr 22nd, 9am–3:45pm CDT
(6 hours & 45 minutes)
Other dates (2)
Excel Workbooks, Formulas and Functions (365/2019/2016)
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Master the essentials of managing large worksheets, creating models, and working with financial, date, and logical functions in Excel. Ideal for individuals responsible for creating and managing complex spreadsheets. Enhance your skills and boost your productivity with this comprehensive course.
Apr 23rd
9am–3:45pm CDT
$295
2 Seats Left
May 1st
9am–3:45pm CDT
$295
2 Seats Left
May 17th
9am–3:45pm CDT
$295
2 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Tue, Apr 23rd, 9am–3:45pm CDT
(6 hours & 45 minutes)
Other dates (2)
Sold Out
Start Dates (0)
- $350
- 7 hours & 30 minutes
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this excel class:
This hands-on class is suitable for Excel 2013 and 2016, 2019 & 365 users.
On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.
Live face-to-face instructor. No minimum class size - all classes guaranteed to run!
Prerequisite:
You should have completed our intermediate class or have the equivalent experience prior to attending this course.
Course Outline
Logical and Lookup Functions
On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.
Live face-to-face instructor. No minimum class size - all classes guaranteed to run!
Prerequisite:
You should have completed our intermediate class or have the equivalent experience prior to attending this course.
Course Outline
Logical and Lookup Functions
- The IF Function
- Conditional Calculations
- Using SUMIF
- VLOOKUPS and HLOOKUPS
- Range LOOKUPS
- Auditing and Error Trapping
- Formula Options
- Array Functions
- Using TRANSPOSE
- Date and Time Functions
- TODAY
- NOW
- DATE - Date Calculations
- Text Functions
- Using CONCATENATE and TRIM
- Using UPPER, LOWER and PROPER
- Extracting Text - Statistical Functions
- Using MIN and MAX
- Using COUNT, COUNTA and COUNTBLANK - Financial Functions
- Using FV
- Using PMT
- The Power Pivot Data Model
- Importing Data
- Using Power Pivot
- Exporting Data
- What-if Analysis
- Scenarios
- Using Goal Seek
- The Analysis Toolpak
- Recording Macros
- Running Macros
- Running Macros when Workbook is Open or Closed
- Using Forms to Record Input
Refund Policy
All cancellations and rescheduling requests must be made in writing and emailed to [email protected]
- Rescheduling requests made 9 business days before the commencement of the training are free.
- Rescheduling that takes place within 9 business days of the commencement of the training will incur a $150 administration fee.
- We do not charge for student substitutions at any time.
We are unable to offer refunds for cancellations.
While we make every effort to deliver classes as scheduled, we reserve the right to reschedule previously confirmed classes for a variety of reasons including but not exclusively, the illness of the Trainer. In such cases, we will endeavor to inform the Client as soon as possible of the new training dates. We are not liable for any additional expenses incurred as a result of rescheduling training.
We are not able to offer refunds for no-shows or uncompleted courses.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.
Reviews of Classes at Training Connection (158)
Similar Classes
People who viewed this class also viewed the following classes
CourseHorse Gift Card
Benefits of Booking Through CourseHorse
- Booking is safe. When you book with us your details are protected by a secure connection.
- Lowest price guaranteed. Classes on CourseHorse are never marked up.
- This class will earn you 3500 points. Points give you money off your next class!
Training Connection
Training Connection LLC is a computer and business skills training company.
Our Training Philosophy
Our main focus is to provide exceptional computer desktop and business skills training. We strive to achieve this by following a 5 cornerstone approach:
1. Our Instructors
Without a doubt our most valuable...
Read more about Training Connection
This school has been carefully vetted by CourseHorse and is a verified Chicago educator.
Training Connection
The Loop, Downtown/Loop
230 W Monroe St Ste 610
Btwn S Franklin & Wells Streets
Chicago, Illinois 60606 The Loop, Downtown/Loop
230 W Monroe St Ste 610
Btwn S Franklin & Wells Streets
Chicago, Illinois 60606
Trains CTA - Blue and Red Lines - Monroe Station Walk approximately 4 blocks west on Monroe Street to Franklin Street. CTA - Orange, Pink, Purple and Brown Lines - Quincy station Walk approximately 1.5 blocks north on Wells Street, turn left (west) on Monroe Street, and go to corner of Franklin Street. CTA - Green Line Swap at Clark for Blue line or Roosevelt for Orange line. Metra - Union Station Walk 3 blocks east on West Adams (crossing river). Turn left (North) on Franklin and walk 1 block to Monroe Street.
Give This Course as a Gift Card
- Thousands of classes
- No expiration
- Unique and memorable gifts for any occasion
- Personalized
- Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
- Instant delivery
- Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Book this Class as a Group Event
Booking this class for a group? Find great private group events
Or see all Excel Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Microsoft Office
Made in NYC
© CourseHorse, Inc. 2024 Loading...