2 Quick Tips

by Intellezy

Using the Slide Master in PowerPoint

Have you ever needed to place a logo on every slide in your PowerPoint presentation?  Or need to change the font size and color of all your slide titles?  Or what about adding the same animation build to every bulleted list in your presentation?

Did you know that there is a place where you can set these changes up once and have them reflect across your whole presentation?

It’s called the slide master, and every admin should know how to use the slide master inside and out.  When you make changes on the master elements, such as the slide title or bulleted list placeholders, all of your slides reflect the new adjustment.

To learn even more about the slide master and see it in action, click here:

iaap-powerpoint-quick-tip-video

https://www.youtube.com/watch?v=0J0WKRiFlqA&t=16s

 

Using Flash Fill in Excel

Flash Fill is one of the most popular new features that was added to Excel back in the 2013 release. It will fill in cells for you automatically based on a pattern. So if you have first names in column A, and last names in column B, you can quickly fill column C with first and last names, or last names and then first names with a comma in between. Just supply the pattern for Excel, and it will do the rest.

And there is a handy shortcut key for Flash Fill. Simply highlight the cells containing the pattern as well as the empty cells you would like filled, and then press Ctrl + E. It’s that easy! Excel will fill in the cells with Flash Fill

Click here to watch Flash Fill, as well as Autofill, another great Excel feature, in action:

iaap-excel-quick-tip-video

https://www.youtube.com/watch?v=2vLaAX47OoY&t=6s


IAAP works with the best trainers in the industry to ensure you have relevant, engaging, practical content at your fingertips. This blog is written by a speaker with a program in the IAAP Approved Programs database. Search by name or keyword to find their contact information and book them for your Branch or Region event. 

If you’d like to attend one of these events, you can find one in your area here.


Website | Facebook|Twitter | LinkedIn| YouTube

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s