Advanced Microsoft Excel

This class meets twice.

Event Dates: 6/14/2022, 6/16/2022

Event Start Time: 6:00 PM

Event End Time: 8:00 PM

Hours: 4

Event Cost: $450.00 


Register

You may register online if you are paying with Visa, MasterCard, Discover, or Purchase Order.

  • To register and pay any other way, please contact Amanda Hext, 337.562.4592, ahext@mcneese.edu

IMPORTANT: You must register and pay by: 6/13/2022 12:00 PM


About the Course

This course provides expert instruction and hands-on exercises that will help you easily master analysis tools, PivotTables, conditional formatting, and other advanced features.


Course Outline

Intermediate Topics Covered Briefly:

 

· Review of basic formulas

· Basic “IF” Formulas

· Filling a series

· Copying and pasting formulas

· Cell comments

· Freezing panes

· Locking Cells, Protecting Worksheets and Workbooks

· Sorting and Filtering Data

· Grouping data – Naming a Range

· Conditional formatting

· Pivot Tables

 

Excel Charts:

 

· Creating and modifying design, layout and format

 

Data Management Tools:

 

· Conditional, Formatting, Sparklines

· Removing Duplicates

· Macros

· Collaboration Tools

 

Excel Advanced Training Topics:

 

· ISBLANK Function

· COUNTBLANK Function

· ARRAYS

 

Look Ups and Other Functions:

 

· HLookup and VLookup

· SUMIF Function

· Longest Text in Range

· SUMIF – Adding Certain Criteria

· SUMIF – Adding Using 2 Criteria

· SUMIF – Multiple Criteria

· SUMIF – Excluding Data

· SUMIF – Formula of Negative Values

· SUMIF – Formula of Different Range

· SUMIFS – Formula for Multiple Criteria

· SUMIF – Formula Value Text Compare

· Calculate Total Wages using ARRAY

· PERCENT ARRAY Formula

· Formula to Calculate Grades

· Formula for Calculating Cumulative

· Calculating Days of the Week

· Calculating number of weekdays from a date

· Calculating months between 2 dates

 

Introduction to Macros:

 

· Developer Tools

· Saving Macros

· Absolute vs Relative Macros

· Recording Macros

· Creating Macro buttons


About the Instructor

We know that learning is easier when you have an excellent teacher. Carl Louviere has over 20 years experience and is passionate about the subjects he teaches.  He brings his enthusiasm into the online and on-site training sessions and virtual courses. Each year, when Microsoft introduces a new version, he adds the new features to his YouTube channel at youtube.com/askmrcarl.



Refund Policy

Refunds will not be issued for this course after the registration deadline. In the event that you cannot attend, you are welcome to send another person as a replacement at no charge. In addition, you may transfer your registration payment to a future course at no cost as long as you use it within the next 12-month period. For example, if you pay for a course in July that you do not attend, you have until July 31st of the following year to transfer the payment. Furthermore, if the cost of the future course increases, you will be required to pay the difference.


Disclaimer

The McNeese State University will always make the best effort to avoid cancelling a course. This course, like any other, can be cancelled for a variety of reasons. Please be aware of this possibility when making travel and hotel arrangements.


LAI/MEP Subsidy Eligible

LAI/MEP companies (see list below) can get a discount on this course. Found out how.

 

Contact Amanda Hext, (337) 562-4592, ahext@mcneese.edu

 

CHENIERE, CITGO, GRACE DIVISION, LEVINGSTON, LOUISIANA PIGMENT, LYONDELLBASELL, and RECON

 


Payment Options
  • Pay online with Visa, MasterCard, Discover, or Purchase Order by clicking the Register Now button
  • To register and pay any other way, please contact Amanda Hext, 337.562.4592, ahext@mcneese.edu
  • Billing and receiving address:

McNeese State University

Institute for Industry-Education Collaboration

Box 91834

Lake Charles, LA 70609


Location

SEED Center RM 141
4310 Ryan Street
Lake Charles, LA 70605
Click here for directions


Contact Us
For more information, contact:
Amanda Hext
(337) 562-4592
ahext@mcneese.edu

Share This