I completed simulations of Word, PowerPoint, and Excel. In these simulations I was tasked with various objectives, some things I've already done and others new.
How to Automate TOC - Click References > Table of Contents and then choose an Automatic Table of Contents style from the list.
How to Automate Citations - go to the 'References' tab on the ribbon and click on 'Insert Citation' and 'Add new source'. Select the 'Type of source' and fill in the boxes.
How to Use Page Breaks - Go to Insert > Page Break.
How to Use Animations - Select the object or text you want to animate. Select Animations and choose an animation. Select Effect Options and choose an effect.
How to Add Videos - Select Insert > Video > Video from device. Select the video you want and select Open to insert it in your slide
How to Add Notes - On the View menu, click Normal. > Select the thumbnail of the slide you want to add notes to. > The notes pane will appear beneath your slide. Click where it says Click to add notes and type whatever notes you'd like to add.
How to Auto Fill - Select cell(s) you want to fill. Drag Fill Handle.
How to Enter a SUM Function - Type "=SUM" into a cell
How to Apply a Chart - Click Design tab > Click chart style you want from the Chart Styles group
I learned a lot of new things about Word that I didn't know was possible and I learned how to properly work PowerPoint. I realized I only had a surface level understanding of those applications capabilities. Now I feel confident that I will be able to use Word and PowerPoint efficiently. I also learned how to use Excel. It always seemed like a hard skill to achieve but this module gave me confidence in using Excel.