Ultimate Excel Tutorial for Beginner and Intermediate Users

Excel guide for excel full of examples covering all the key function with both practice exercises and answers. It is extensive and exhaustive.

Ideal for beginner and intermediate consultants, executives and operations managers.The guide is designed to be as simple as possible to use, consisting of three main sections.There are three sections on how to effectively use Excel, covering Functions, Data handling and Visuals. This is organized so that it can be consumed and understood easily.

Each of these sections covers a number of different techniques. For each technique there is an introduction, an explanation of the techniques' use and an example exercise.In detail the excel functions and tools covered are as follows: Dollaring, Data formatting, IF, SUMIF, VLOOKUP, HLOOKUP, COUNT, COUNTIF, IFERROR, RANK, INDEX, MATCH, sorting, filtering, conditional formatting, grouping, pivot tables, data validation, freezing panes

Each tab covers a function and provides both examples, exercises and answersIt's an excellent guide, memory refresher and tutorial.Also comes with user-friendly format and navigation. The navigation bar at the top of the screen is your main way of exploring the guide. On the right there are two buttons. The blue button will take you to an overview page, from where you can jump to any page in.