Excel - Level 3

Master advanced Excel functions and tools in this comprehensive course. From logical and statistical functions to financial and date functions, learn to manage data efficiently. Explore analytical features like Goal Seek and Solver, and enhance collaboration with macros and custom functions.

Advanced
18 and older
$295
Interactive Online Classroom
8 hours

Start Dates (10)

$295
8 hours

Mon, Apr 29th, 6am–2pm EDT

12 seats left

Book

Wed, May 1st, 6am–2pm EDT

12 seats left

Book

Fri, May 3rd, 6am–2pm EDT

12 seats left

Book

Mon, May 6th, 6am–2pm EDT

12 seats left

Book

Thu, May 9th, 6am–2pm EDT

12 seats left

Book

Showing 1 – 5 of 10

Save to WishList Give as a Gift

Description

What you'll learn in this excel class:

Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data.

Pre-requisite(s): Excel Level 2

Course Outline

Lesson 1 : Logical and statistical functions

Logical functions
Math and statistical functions

Lesson 2 : Financial and date functions

Financial functions
Date and time functions
Array formulas
Displaying and printing formulas

Lesson 3 : Advanced data management

Validating cell entries
Exploring database functions

Lesson 4 : Analytical tools

Goal Seek and Solver
The Analysis ToolPak
Scenarios

Lesson 5 : Outlining and subtotals

Outlining and consolidating data
Creating subtotals

Lesson 6 : Documenting and auditing

Auditing features
Comments in cells and workbooks
Protection
Workgroup collaboration

Lesson 7 : Macros and custom functions

Running and recording a macro
Working with VBA code
Creating functions

Lesson 8 : Appendix - Exporting and importing

----note: Appendix content is not covered in the one day course

Exporting and importing text files
Exporting and importing XML data
Getting external data

Lesson 9 : Appendix - Additional Features

----note: Appendix content is not covered in the one day course

Sharing workbooks as Web pages
Using hyperlinks
Sharing workbooks

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

Open Enrollment Desktop Applications Classes -- You may reschedule or cancel your enrollment in a Desktop Applications class at no charge with at least five (5) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel your registration you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Open Enrollment Technical Training Classes with Level TT1, TT2 or TT3 Tech Pricing -- You may reschedule or cancel your enrollment in a Technical Training Class with Level TT1, TT2 or TT3 Tech Pricing at no charge with at least ten (10) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Reviews of Classes at TLG Learning (1)

(5.0-star rating across 1 reviews)

See reviews for other classes at TLG Learning

Hide Reviews

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 2950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

TLG Learning

For over 20 years, TLG Learning has been trusted by premier companies and government agencies.

We provide complete learning solutions on Microsoft, F5 Networks, ITIL, Cisco, Citrix, CompTIA, VM Ware, Adobe, Project Management, Business Skills, and more.

During the past 3 years, 99% of over 10,000 TLG...

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™

Buy a Gift Card