When it comes to numbers, such as creating sales reports or compiling statistics, a spreadsheet software such as Excel is an essential ally. In fact, mastering the advanced functions of this software will allow you to efficiently process large amounts of data, perform complex calculations, and automate repetitive tasks, among others. Both theoretical and practical, this course will allow you to perfect your knowledge of Excel 2019. 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 - Customizing Excel

Chapter 2 - Using Names

Chapter 3 - Working with Multiple Worksheets

Chapter 4 - Working with Multiple Workbooks

Chapter 5 - Working with Outlines and Consolidation

Chapter 6 - Managing Data Using Tables

Chapter 7 - Using Filters

Chapter 8 - Using Pivot Tables

Chapter 9 - Using Power Query

Chapter 10 - Using Functions

Chapter 11 - Using What-If Analysis Tools

Chapter 12 - Using Data Validation

Chapter 13 - Using Styles, Themes, and Templates

Chapter 14 - Automating Tasks with Macros

Chapter 15 - Inserting Text Boxes, Shapes, and Pictures

Chapter 16 - Integrating Excel Data into Word Documents and PowerPoint Slides

Chapter 17 - Collaborating on Workbooks