For intermediate levels
Most suitable for people who work daily with Excel and need to create and manage simple tables and databases efficiently. This course, along with The Basics, provides most tools that Excel users need to perform daily tasks.
of this course is to provide students with more tools to manipulate data easily, such as naming ranges, using date/time and IF functions, linking sheets and books, standard database tools such as sorting and filtering, working with multiple sheets and creating 3D formulas.this course is to provide students with basic knowledge of Microsoft Excel to achieve standard daily tasks. At the end of this course they will be able to create new workbooks, enter and format data, perform basic calculations and set the spreadsheet up for printing.
Module 1: Named Ranges and Functions
Module 2: Basic Databases
Module 3: Linking and Protecting
Module 4: Arranging Large Data on the Screen
Module 5: Working with Sheets