Both theoretical and practical, this course will allow you to perfect your knowledge of Excel 2019, thus deepening your knowledge of data processing. You will learn how to illustrate data using graphics and charts, and to work more efficiently using templates and macros. Our comprehensive Logitell approach guides students through progressively increasing skill sets using real-world exercises and extensive practice, promoting independent learning. As a Canadian company, we are committed to providing high-quality resources tailored to the unique needs of the Canadian education market. Logitell resources offer an outstanding value, with pricing notably lower than our competitors, allowing educators to provide students with quality materials within budgetary constraints.

Table des matières

Chapter 1 - Working with Multiple Worksheets

Chapter 2 - Using Date and Time Functions

Chapter 3 - Using Logical Functions

Chapter 4 - Using Lookup and Reference Functions, and Financial Functions

Chapter 5 - Managing Data Using Tables

Chapter 6 - Using Filters

Chapter 7 - Creating and Modifying Charts

Chapter 8 - Formatting Charts

Chapter 9 - Creating a SmartArt graphic

Chapter 10 - Using and Creating Templates

Chapter 11 - Using Data Validation

Chapter 12 - Automating Tasks with Macros

Chapter 13 - Collaborating on Workbooks

Chapter 14 - Importing and Exporting Data