Excel for Everyone (with Tutorial Video)
Everything you need to learn Excel is at your fingertips!
Compatible with Microsoft 365, Excel 2019, 2016 and 2013!
Book+Video (76 videos, 246 min.)+Example Application Files.
The aim of the Excel for Everyone book is to bring the beginners of Excel, the world's most popular worksheet program, to the advanced level in a short time, by surpassing the beginner and intermediate levels.
For this purpose, the topics in the book are explained in detail, step by step, and are handled in a way that can be learned with examples and experiments and applied easily in Excel. When you finish by absorbing the lectures and examples in this book, your view of Excel operations will be much different and the only limiting factor in the models and applications you will develop in Excel will be your imagination.
In addition, the topics and examples are supported by screenshot videos presented visually and audibly. All of the examples described in the book and the screenshot videos are available on the Excel for All book CD, which is included with the book.
• Understanding Worksheets
• Worksheet Elements
• Data Editing and Auditing Operations
• Text Functions
• Search and Reference Functions
• Financial Functions
• Simple (Nominal) and Compound Interest Rate Calculations
• Mathematical and Logical Functions
• Working with Graphics
• Recognizing Graphics
• Summarizing Data Using Pivot Tables
• Creating a PivotTable
• Data Tables
• Scenario Manager
• Solver
• Recording and Running a Macro
• Creating User Defined Function