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: 4/20/2023 11:59 PM

Excel is the industry leading spreadsheet software program. Yet most people are not using Excel to its fullest potential. In this class, you will better understand and appreciate the versatility of Excel and how to use it more robustly as a date management tool.

Excel Basics:

· 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

Excel Charts:

· Creating and modifying design, layout and format

Data Management Tools:

· Deleting Rows and Columns

· Inserting Rows and Columns

· Simple Formulas

· Formatting Cells and Ranges

· Naming Ranges

· GoTo and AutoCorrect under Find and Replace

· Ctrl + Action Shortcuts

· Dependents and Precedents

· Three Ways to Edit Cells Quickly

· Set up Print Preview

· Set up Print Area to Print Only

· Copy and Paste Correctly

· Type Titles at Top of each Page

· Splitting the Panes

· Absolute Reference

· Print Gridlines

· Wrap Text in Cells

· Set Printing to Landscape or Portrait Format

· AutoSum, MAX, MIN, AVERAGE

· Adjust Row & Columns Height or Width

· Checking Totals on Status Bar

· GoTo Data Range you work on daily

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.