Microsoft Excel Ninjas – Level 2

08 Dec
  • 8th December 2017
    9:30 am - 4:30 pm
Shropshire Chamber of Commerce

Building skills to speed up navigation around your spreadsheet you’ll learn how to manipulate multiple files and worksheets, create 3D formulas, link cells and so much more! To help you become an Excel Ninja on this course we cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links. We also look at […]

Building skills to speed up navigation around your spreadsheet you’ll learn how to manipulate multiple files and worksheets, create 3D formulas, link cells and so much more! To help you become an Excel Ninja on this course we cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links. We also look at special number formats to speed up data entry, ways to collapse large workbooks to see the totals you need and advanced charting – making amazing tables in one click with the secret built in formula! You’ll learn how to speed up navigation around your spreadsheet and use range names in formula; using the auditing features will allow you to check your work and protect your spreadsheet. We take a look at useful built in templates and how you can use them and finish with a first look at Pivot Tables and Charts. Who Should Attend? This course is specifically designed for office staff/managers with some previous knowledge of Excel, and is designed to take you to the next level. Mistakes can be reduced if you use the tools that come with Excel and check your work. This course will cover essential time-saving features and will look in detail at: Using multiple worksheets and workbooks We’ll show you how to use multiple workbooks and link them to save replication and keep data up to date. You’ll also learn the magic of 3-D formulas. Advanced formatting How to save time using special number formats and working with functions to format text. Outlining and subtotals Learn the amazing benefits of using Outlining on large lists of data and how to consolidate data to see totals by category and how to quickly and easily create subtotals. Cell and range names See the advantages of creating and using range names in your spreadsheets and how to manage them. Tables You’ll get the upper hand by knowing how to create a table in one click so you can easily sort and filter your data. Advanced charting Take your charting skills to a professional level by lea