LANTEC Logo
Lantec | Course: Excel Advanced

Excel Level 3

$245.00
1 days
Audience
Prerequisites

Description:

Excel Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. The three levels of our Excel courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel. Objective coverage is marked throughout the course.

Outline:

Chapter 1: Logical and Lookup Functions

  • Module A: Decision-making functions
  • Module B: Lookup and reference functions

Chapter 2: Advanced Formula

  • Module A: Auditing and error-trapping
  • Module B: Formula options
  • Module C: Arrays

Chapter 3: Special functions

  • Module A: Date and time functions
  • Module B: Text functions
  • Module C: Other functions

Chapter 4: Importing and Exporting

  • Module A: The Power Pivot Data Model
  • Module B: Exporting data

Chapter 5: Analysis

  • Module A: What-if analysis
  • Module B: The Analysis Toolpak

Chapter 6: Macros and Forms

  • Module A: Recording macros
  • Module B: Running macros
  • Module C: Forms

Appendix A: Internationalization and Accessibility

  • Preparing workbooks for internationalization and accessibility

Scheduled Courses

Jun 25, 2024
Jun 27, 2024
Jul 26, 2024
Jul 30, 2024
Aug 09, 2024
Sep 11, 2024
Oct 29, 2024
Oct 31, 2024
Nov 06, 2024
Nov 21, 2024
Dec 16, 2024

Need to Request This Course On a Different Day?

LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Want to schedule it?


Lisa Tooke, Westlake Chemical

"I really appreciate Ryan's delivery of material, pace of instruction, patience answering questions, attentiveness to the audience's interest or disinterest in side questions! Good balance!"