Microsoft Excel Practical Formulae
This book covers a practical range of basic through to advanced Excel formulae. We cover basic data analysis functions such as SUM, COUNT and IF, and then move to intermediate criteria-based and data tidy functions such as VLOOKUP, CONCATENATE and IFERROR. Next onto advanced data analysis with SUMIF, SUMIFS and INDEX/MATCH and finally onto dynamic functions such as INDIRECT and OFFSET. It covers a huge range of Excel functions and formulae.
Microsoft Excel Charts and Pivots
This book covers some really exciting ways to work with Excel. We talk about how to improve a basic report using powerful analysis and visualisation tools. The main areas we cover are Excel charts and Excel pivot tables; how to build both from scratch, best practice tips, dynamic charts, pivot charts and slicers. We’ll also look at in-cell visualisation; sparklines and heatmaps, dashboards and infographics.
Microsoft Excel Basic Macros
I want to give you some Excel VBA basics which will help you read and use VBA code. VBA is a powerful and complex environment but I want to give you the tools and confidence to do basic coding to help you automate tasks. I will give you examples of how to create and run simple but useful code which you can implement immediately; you need no prior knowledge of programming, just an understanding of Excel. Leap-frog ahead of your co-workers with some automated Excel macros.
That’s three information-packed Excel training ebooks; with diagrams and examples to help you along the way.
Still not sure? Take a look inside to see the first few pages; I’ve structured the contents pages to give you a really good feel for what’s inside each ebook. If it looks right for you, then please buy and enjoy!
This book covers a practical range of basic through to advanced Excel formulae. We cover basic data analysis functions such as SUM, COUNT and IF, and then move to intermediate criteria-based and data tidy functions such as VLOOKUP, CONCATENATE and IFERROR. Next onto advanced data analysis with SUMIF, SUMIFS and INDEX/MATCH and finally onto dynamic functions such as INDIRECT and OFFSET. It covers a huge range of Excel functions and formulae.
Microsoft Excel Charts and Pivots
This book covers some really exciting ways to work with Excel. We talk about how to improve a basic report using powerful analysis and visualisation tools. The main areas we cover are Excel charts and Excel pivot tables; how to build both from scratch, best practice tips, dynamic charts, pivot charts and slicers. We’ll also look at in-cell visualisation; sparklines and heatmaps, dashboards and infographics.
Microsoft Excel Basic Macros
I want to give you some Excel VBA basics which will help you read and use VBA code. VBA is a powerful and complex environment but I want to give you the tools and confidence to do basic coding to help you automate tasks. I will give you examples of how to create and run simple but useful code which you can implement immediately; you need no prior knowledge of programming, just an understanding of Excel. Leap-frog ahead of your co-workers with some automated Excel macros.
That’s three information-packed Excel training ebooks; with diagrams and examples to help you along the way.
Still not sure? Take a look inside to see the first few pages; I’ve structured the contents pages to give you a really good feel for what’s inside each ebook. If it looks right for you, then please buy and enjoy!
