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.
Chris Menard – Excel Training for EMBA students
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.
|1045-1215||Excel Intermediate part 1|
|1215-1300||Lunch - provided|
|1300-1430||Excel Intermediate part 2|
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
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:
- Click the empty cell where you want to total the other worksheets.
- Click AutoSum.
- Click the first worksheet. Hold down Shift and click the last worksheet.
- Let go of Shift and now click the cell you want to add and press ENTER.
- 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
- Click the File tab.
- Click Info.
- Click Protect Document, and then click Encrypt with Password.
- In the Encrypt Document box, type a password, and then click OK.
- In the Confirm Password box, type the password again, and then click OK.
MS Word – Odd and Even headers and footers
- Double-click the header or footer area (near the top or bottom of the page) to open the Header & Footer Tools.
- Select the Different Odd & Even Pages check box.
- Header and Footer options
- On one of the odd pages, click the header or footer area you want to change and add page numbers right aligned.
- On one of the even pages, click the header or footers area and make the page numbers left align.
- Close the header or footer to return to the document.
Excel – Create a data validation
- Select one or more cells to validate.
- On the Data tab, in the Data Tools group, click Data Validation.
- On the Settings tab, in the Allow box, select List.
- In the Source box, type your list values, separated by commas. For example:
- To limit an answer to two choices (“Do you have children?” for example), type Yes,No.
- To limit a vendor’s quality reputation to three ratings, type Low,Average,High.
MS Word – find and replace text
- CTRL + F is find.
- CTRL + H is replace.
- On the Home tab, in the Editing group, choose Replace. Or press Ctrl+H on your keyboard.
- In the Find what box, type the text that you want to search for and replace.
- In the Replace with box, type the replacement text.
- 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.
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
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.
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!