ICTICT308 ICTSAS410 IT Skills 1

Advanced Applications - Excel Before we continue with Advanced Excel, does anyone need me to go through the Basics of Excel? Have you used Excel before? Do you understand Cells and Cell ranges? Do you know how to enter a basic formula or Function? Do you understand Relative and Absolute cell addresses in formulas? Can you apply styling to make it look pretty? If you can answer YES to the above questions, then you are all set for advanced Excel (we will take it slowly) Excel Charts Let's start our Advanced Excel lesson with Charts! This is a simple spreadsheet that compares the library statistics from the door counter for branches of South East TAFE libraries. Start by making it look a bit prettier Heading I made the font larger Added some shading Did a merge and centre Table Added borders Made the column headings bold Centred the headings Create the Chart Start by selecting the area of the graph that you want to chart A3:M8 Go to the Insert Ribbo

  Animations Animations are easy to use in PowerPoint, but there are a few tricks that you can use to make your presentation a little bit more interesting. NOTE: Don't get too carried away. Less is More is my motto when it comes to PowerPoint and animations. Simple Animations I am not going to spend too much time here as I will assume that you know how to apply some basic animations to your presentation. You can animate any item on a slide and have full control about how the item is animated. The below example is animation of a bullet list. When applying animations, you can choose the way an item comes onto the screen (Entrance/Green), how it behaves while on the screen (emphasis/Amber), and how it leaves the screen (exit/red). Let's see how this works with a chart. Using Hyperlinks Hyperlinks can be used to control the order in which the slides appear or to enhance or provide more information about a topic on a slide Here is an example using hyperlinks and images. I created a

PowerPoint is definitely the easiest of the Office Applications to master. I have called this "Advanced PowerPoint", but there really isn't anything too difficult in PowerPoint. I am assuming that you all know a bit about PowerPoint and how to create a presentation and apply a theme to make a plain presentation look really swish, so today I will show you how to create your own theme. ******************************************************* Please let me know if anyone needs a refresher on using PowerPoint ******************************************************* Creating a Template/Theme Start by loading PowerPoint using a Blank Presentation. To be able to create or change a Theme, you need to change the view to Slide Master. You can access this from the View tab. Your presentation area will now contain the "Master" versions of all of your slides. Once you are in Master Slide View, you can customise and create your own Template. Many organisati