Microsoft Office Archive

  • If you are an Office 365 subscriber, you have the option to opt in and become some of the first people to try out new features and functionality, every single month, across the various office applications. It is one of the beautiful things about having an Office 365 subscription, if you ask me!

If you use PowerPoint everyday, like I do, there are two new features that will blow your mind away! But they won't install automatically, at least, not yet. You have to become an Office Insider!

    Two Great New PowerPoint Features: Morph and Designer

    If you are an Office 365 subscriber, you have the option to opt in and become some of the first people to try out new features and functionality, every single month, across the various office applications. It is one of the beautiful things about having an Office 365 subscription, if you ask me! If you use PowerPoint everyday, like I do, there are two new features that will blow your mind away! But they won't install automatically, at least, not yet. You have to become an Office Insider!

    Continue Reading...

  • If you can't tell, I love making videos. So when I learned that Microsoft was developing a new tool that allowed anyone with PowerPoint to easily create and share their own interactive online videos, I was more than excited--I was goose-bumped ecstatic!

    Create Interactive Online Videos with Office Mix

    If you can't tell, I love making videos. So when I learned that Microsoft was developing a new tool that allowed anyone with PowerPoint to easily create and share their own interactive online videos, I was more than excited--I was goose-bumped ecstatic!

    Continue Reading...

  • I have many talents, but working with Illustrator (at the time of this post anyway) is not one of them. I am, however, awesome with PowerPoint, and drawing/editing shapes with PowerPoint. But sometimes, there is a shape or vector graphic from a popular stock photo site that I'd like to edit and use in PowerPoint. And editing the graphic in PowerPoint, (for me anyway), would be faster than editing the graphic in Illustrator--especially considering the file is going to end up in PowerPoint eventually anyway.

Well, lucky for us, there is an easy way to convert most illustrator graphics into editable PowerPoint shapes, or rather what is known as a "Microsoft Office Drawing Object."

    Convert an Illustrator Vector Graphic to a PowerPoint Shape

    I have many talents, but working with Illustrator (at the time of this post anyway) is not one of them. I am, however, awesome with PowerPoint, and drawing/editing shapes with PowerPoint. But sometimes, there is a shape or vector graphic from a popular stock photo site that I'd like to edit and use in PowerPoint. And editing the graphic in PowerPoint, (for me anyway), would be faster than editing the graphic in Illustrator--especially considering the file is going to end up in PowerPoint eventually anyway. Well, lucky for us, there is an easy way to convert most illustrator graphics into editable PowerPoint shapes, or rather what is known as a "Microsoft Office Drawing Object."

    Continue Reading...

  • Since this is a course on Sway, I thought I would start this blog inside a Sway and embed the Sway into this blog. Doesn't that just blow your mind away?

    Sway First Look Course from Pluralsight

    Since this is a course on Sway, I thought I would start this blog inside a Sway and embed the Sway into this blog. Doesn't that just blow your mind away?

    Continue Reading...

  • A little while back a colleague of mine asked me, "How do I calculate the total seconds in Excel?" What he had was a column of timestamps in the h:mm:ss format and he wanted to convert that timestamps to simply display the total seconds, which is actually quite easy to do in Excel depending on (1) how the data was entered, and (2) how the data is formatted. Watch this video to learn how...

    Calculate Total Elapsed Seconds in Microsoft Excel 2010

    A little while back a colleague of mine asked me, "How do I calculate the total seconds in Excel?" What he had was a column of timestamps in the h:mm:ss format and he wanted to convert that timestamps to simply display the total seconds, which is actually quite easy to do in Excel depending on (1) how the data was entered, and (2) how the data is formatted. Watch this video to learn how...

    Continue Reading...

  • Back in January, Alan Ackmann (yes, my husband) and I gave a webinar for the TrainSignal blog on The Top 10 Resume Tips for IT Pros. Following that same theme, we were asked to deliver a similar webinar, this time focused on cover letters for IT Professionals.

    Conquering the IT Cover Letter

    Back in January, Alan Ackmann (yes, my husband) and I gave a webinar for the TrainSignal blog on The Top 10 Resume Tips for IT Pros. Following that same theme, we were asked to deliver a similar webinar, this time focused on cover letters for IT Professionals.

    Continue Reading...

  • If you have ever been frustrated when trying to delete a record in Access and seeing the warning message "The record cannot be deleted or changed because table 'tblYourTableName' includes related records,' do not be dismayed. That warning message is actually a good thing, for referential integrity is protected your data from being orphaned. To side-step the warning message and to allow you and your database users to delete unwanted data, you might want to try to turn on a feature called "cascade delete."

    Microsoft Access Relationship: Cascade Delete

    If you have ever been frustrated when trying to delete a record in Access and seeing the warning message "The record cannot be deleted or changed because table 'tblYourTableName' includes related records,' do not be dismayed. That warning message is actually a good thing, for referential integrity is protected your data from being orphaned. To side-step the warning message and to allow you and your database users to delete unwanted data, you might want to try to turn on a feature called "cascade delete."

    Continue Reading...

  • In this training clip, I show students how to use wildcards inside an Access query to locate a customer by last name without knowing exactly how to spell the customer last name. Knowing how to use wildcards is very important when querying data in Access, as the use of a simple wildcard can save a lot of time hunting through records.

    Microsoft Access Wildcards

    In this training clip, I show students how to use wildcards inside an Access query to locate a customer by last name without knowing exactly how to spell the customer last name. Knowing how to use wildcards is very important when querying data in Access, as the use of a simple wildcard can save a lot of time hunting through records.

    Continue Reading...

  • This clip is one I created specifically for TrainSignal‘s YouTube Office channel to begin a new video series, the “PowerPoint FAQ” series, designed to answer some of the commonly asked questions […]

    PowerPoint FAQ: How do I animate SmartArt shapes individually?

    This clip is one I created specifically for TrainSignal‘s YouTube Office channel to begin a new video series, the “PowerPoint FAQ” series, designed to answer some of the commonly asked questions […]

    Continue Reading...

  • This clip is one I created specifically for TrainSignal‘s YouTube Office channel. This clip, along with several other clips in the “Access Database Basics” series, is designed to cover a very […]

    Access Database Basics-Primary Keys

    This clip is one I created specifically for TrainSignal‘s YouTube Office channel. This clip, along with several other clips in the “Access Database Basics” series, is designed to cover a very […]

    Continue Reading...

Page 3 of 512345