Good Morning John
How are you doing? I hope all is well.
I've been posting Excel tutorial videos on LinkedIn.
A few weeks ago, a viewer asked a question: Is it possible to add to use Excel to create organizational charts? My answer is yes, by using SmartArt.
Step 1 - Get rid of the gridlines
While this step is optional, I find the organizational charts look a lot better on a blank screen. Click the Page Layout tab on your ribbon. In the Sheet Options group, uncheck View.
Step 2 - Insert SmartArt Click the Insert tab in the ribbon. In the Illustrations group, click SmartArt. In your SmartArt Categories, choose Hierarchy. Click an organizational chart to see a preview on the left side of your screen. Click OK when you find one that meets your needs.
Are you a visual learner?
Click here for a 3-minute video that walks you through the process and includes steps to modify the organizational chart.
If you'd like to learn even more, check out our Excel classes: Excel Functions: https://excel-function-step-by-step.eventbrite.com Effortless VLOOKUP Functions: https://excel-vlookup-ultimate-course.eventbrite.com Painless Pivot Tables: https://pivot-table-how-to.eventbrite.com Power Query: https://power-query-excel-training.eventbrite.com/ Power BI: https://power-bi-training.eventbrite.com
What People Say:
Here’s what people say about my training.
This isn't the first time I've attended a Pivot Tables course. But this is the first time I feel confident that I put what I've learned to use. Attendee - Pivot Table Training - IAAP Conference
Everything from explaining unfamiliar material to simplifying information to relay to class; she is excellent. Coca-Cola Company
The instructor was interesting and upbeat during training. A great deal of knowledge and assistance was provided … allowed time for candid questions and real-life work/application questions. Zodiac Aerospace
Course and went the extra mile to give me additional information and shortcuts that the books didn't cover.
Would you like for us to offer Excel courses to your organization?
For the past 19 years, we’ve offered training to some of Atlanta’s leading organizations. Organizations we've impacted include: City of Atlanta, Coca-Cola Company, Novelis, and Emory University.
We'd love to have a conversation: please call 770.498.7333 or click here to schedule a conversation at a time that works for you.
Have a great week! Warmly,
PS -
Upskilling your workforce is not just an immediate issue; according to this McKinsey & Company study, it is the key to emerging stronger after the COVID-19 crisis.
Jackie Kiadii, CEO
Microsoft Certified Trainer
Microsoft Certified Expert - Excel
Phoenix Computer Consultants, LLC
t. 770-498-7333
e. [email protected]
w. www.probiztechnology.com
a. 1100 Peachtree Street Suite 200 Atlanta, GA 30309
l. http//www.linkedin.com/in/jkiadii
|
|
What We Do:
Since 2001, Phoenix Computer Consultants LLC has provided Excel and other Microsoft Office training to thousands of business professionals. |
|
|
|
