Executive MBA Training in Excel

September 23, 2017…The Executive MBA students from the Terry College of Business will start off their 18-month EMBA program with a crash course in Excel with Chris Menard.

Executive MBA Training in Excel

Covered will be advanced filters, data validation, consolidating data, using array functions, over 20 business functions, and many other Excel features.

Chris Menard – Excel Training for EMBA students

Chris Menard - Microsoft Office Master Instructor

Chris Menard

Videos and instructions are provided from Chris Menard’s presentation on Saturday, September 23, 2017. This page will not go away so feel free to reference it in the future.

The Terry Executive Education Center is Terry College’s “home away from home” in the Buckhead district of Atlanta. 

 

Microsoft Excel topics include:

  • Creating a chart in Excel in two minutes.
  • Working with filters.
  • Creating advanced filters in Excel.
  • Using subtotals in Excel.
  • Creating a data validation in MS Excel.
TimeTopic
0900-1030Excel Essentials
1030-1045Break
1045-1215Excel Intermediate part 1
1215-1300Lunch - provided
1300-1430Excel Intermediate part 2
1430-1445Break
1445-1600Excel Advanced

Terry Executive Education Center

Conveniently located across from Lenox Square Mall, in the heart of Buckhead, with close proximity to MARTA, restaurants, and lodging is the Terry Executive Education Center. Features of the Terry Executive Education Center include:

  • WiFi cloud for wireless computer network access throughout the building’s 32,000 square feet, spanning three floors and filled with amenities.
  • Convenient classroom location, easily accessible by students enrolled in Terry’s Evening and Executive MBA programs.
  • Home of the Executive MBA program which is offered to mid to senior level managers. The EMBA program is ranked the top program in Georgia and 14th in the world by The Economist.

Google Map to Terry Executive Education Center

Table of Contents for Excel

Excel 1 – Essentials

Excel 2 – Intermediate

Teachable Course – Free Excel online course for 2017 EMBA students at the University of Georgia.

Excel 3 – Advanced

Chris Menard - YouTube for Word

Excel YouTube Video playlist

Excel – create a 3D Reference

Shown in the video are how to create a 3D reference in MS Excel.

Steps to make a 3D reference:

  1. Click the empty cell where you want to total the other worksheets.
  2. Click AutoSum.
  3. Click the first worksheet. Hold down Shift and click the last worksheet.
  4. Let go of Shift and now click the cell you want to add and press ENTER.
  5. AutoFill the cells across and select AutoFill Options.

Excel – Countif and Named Ranges

The Countif function is one of the most popular functions in Excel. It has two arguments. The cell range and the criteria. If you were trying to find out how many customers are in Atlanta, your function would be =Countif(range,”Atlanta”

If you wanted to know, how many customers are not in Atlanta, you would use =Countif(range,”<>Atlanta”

 

Password Protect Microsoft Office Files

Applies to: Excel, Word, and PowerPoint 2010, 2013, and 2016

  1. Click the File tab.
  2. Click Info.
  3. Click Protect Document, and then click Encrypt with Password.
  4. In the Encrypt Document box, type a password, and then click OK.
  5. In the Confirm Password box, type the password again, and then click OK.

MS Word – Odd and Even headers and footers

  1. Double-click the header or footer area (near the top or bottom of the page) to open the Header & Footer Tools.
  2. Select the Different Odd & Even Pages check box.
  3. Header and Footer options
  4. On one of the odd pages, click the header or footer area you want to change and add page numbers right aligned.
  5. On one of the even pages, click the header or footers area and make the page numbers left align.
  6. Close the header or footer to return to the document.

Excel - Keyboard Shortcuts

Download a one page PDF of Chris Menard’s favorite Excel keyboard shortcuts.

 

Word - Keyboard Shortcuts

Download a one page PDF of Chris Menard’s favorite Word keyboard shortcuts.

 

Excel – Create a data validation

  1. Select one or more cells to validate.
  2. On the Data tab, in the Data Tools group, click Data Validation.Data Validation is located in Data tab, Data Tools group
  3. On the Settings tab, in the Allow box, select List.Settings tab in Data Validation dialog box
  4. In the Source box, type your list values, separated by commas. For example:
    1. To limit an answer to two choices (“Do you have children?” for example), type Yes,No.
    2. To limit a vendor’s quality reputation to three ratings, type Low,Average,High.

MS Word – find and replace text

Keyboard Shortcuts:

  • CTRL + F is find.
  • CTRL + H is replace.
  1. On the Home tab, in the Editing group, choose Replace. Or press Ctrl+H on your keyboard.The Replace option is highlighted on the Home tab.
  2. In the Find what box, type the text that you want to search for and replace.
  3. In the Replace with box, type the replacement text.Find and replace text
  4. Choose Find Next, and then do one of the following:
    • To replace the highlighted text, click Replace.
    • To replace all instances of the text in your document, click Replace All.
    • To skip this instance of the text and proceed to the next instance, click Find Next.

 

 Excel Videos

 Word Videos

Outlook Tip from Chris - Reply-To-All

Do you need to send out an email to multiple recipients and want to make sure no one does a Reply-To-All? Just simply put them on the BCC line of the email. If anyone accidentally does a Reply-To-All, only you will get the reply…The More You Know

 

To turn on BCC, start a new mail message, click on the Options tab, and then click on BCC from Show Fields. Chris Menard

Free Online Excel Training for UGA Executive MBA students

If you attend training on 9/23/17, Chris Menard’s Excel online course is free. Use the form below to get a 100% off coupon.

Excel Intermediate Training class available online

Enjoy Chris Menard’s Excel level 2 class online. As part of attending the 2017 Executive MBA training on 9/23, you can receive a coupon for 100% off coupon for Chris Menard’s Excel 2 class using the form on the left. Please note, you must be a UGA EMBA student and attend the 9/23 Excel training class at the Terry College of Business in Buckhead.

Excel Intermediate Training - Chris Menard

You can follow along in the exercises, move around from unit to unit, and view the course as many times as you want. The course is $199, but you get it for free!

 

 

 

 

Pin It on Pinterest