Excel Intermediate

This class meets on the dates listed below and at the times listed below.

Event Dates: 10/25/2022, 10/26/2022

Event Start Time: 6:00 PM

Event End Time: 8:00 PM

Total Hours: 4

Event Cost: $400.00

Registration Deadline: 10/24/2022 11:59 PM

 


About the Course

This Class will allow you to create a very nice Worksheet in your Workbook. You will better understand the versatility of Excel in your daily needs for structuring your data in your working environment.

 

We also teach a more Advanced Class, should you proceed to create a more elaborate Workbook.


Course Outline

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


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.



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

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, LOUISIANA PIGMENT, and LYONDELLBASELL

 


Location

SEED Center RM 142
4310 Ryan St
Lake Charles, LA 70605
Click here for directions


Share This






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.