ICTICT308 ICTSAS410 IT Skills 1

Working with Multiple Sheets – 3D Excel is great if you need to have a number of workbooks that are formatted the same - An example could be an organisation with multiple sites or branches or an organisation with multiple departments. Our Class Example South East TAFE library services has 5 branches in and around the south-east of Melbourne and the Mornington Peninsula. They are located in Dandenong, Pakenham, Cranbourne, Frankston, and Berwick. We need to create a budget for the next 12 months for each branch. Open Excel and put the names of each branch on the sheet tabs - either double-click or right-click and choose Rename. You can add new sheets by clicking on the little + button at the bottom left of the screen, next to the last sheet. We also need a sheet in front to summarise and total the Branches. Click on the Add New Sheet button and type in All Campuses as the sheet name. You can drag this sheet to the front by clicking on the TAB and dragging it to the fr...

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...