Excel Essentials

By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable. <strong>Getting Started</strong> The first lesson covers logging into Office 365 and Excel Online as well as how to navigate in the app. Students learn how to open, save, share and print workbooks and how to use some help tools. <strong>Working with Data</strong> The basics of Excel formulas and functions and the introduction of some tools and techniques to use when working with formulas. We cover how to modify rows/columns and how to sort & filter data. <strong>Formatting a Worksheet</strong> Students learn how to format text and cells, align cell contents, use find and select tools. <strong>Adding Pictures and Shapes</strong> Students learn how to insert and modify pictures and shapes. <strong>Charts</strong> Students will learn how to insert charts and perform some basic tasks with them. <strong>Finalizing Workbooks</strong> Students learn about comments and managing multiple worksheets. Fees and dates are negotiable for on-site courses, public course dates and fees can be provided on request. <strong>What it covers:</strong> <ul> <li>Getting Started</li> <li>Working with Data</li> <li>Formatting a Worksheet</li> <li>Adding Pictures & Shapes</li> <li>Charts</li> <li>Managing Multiple Worksheets</li> </ul> <a class="fasc-button fasc-size-medium fasc-type-popout fasc-rounded-medium fasc-ico-before dashicons-format-aside" style="background-color: #3b8bcd; color: #ffffff;" href="https://theprovengroup.com.au/wp-content/uploads/2021/12/tpg-excel-essentials.pdf">Download Course Brochure</a>