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

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

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

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.

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.

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.