Microsoft Excel offers the creation and management of tables with hundreds of functions carried out by sophisticated calculations and analysis. Using conditional formatting,charts visualizing the data obtained. For larger amount of data enables using pivot tables and PowerPivot tools to compare the data in context and summary results displayed to the user. Let ITLektor show you the mysteries of this powerful application.
Many tips and tricks, which I met in practice, giving to readers free of charge in my useful videos. See with your own eyes how to deal with situations that are perhaps your daily basis. To view a list of all video tutorials just go to the video category.
If you find that you are missing some knowledge, there is no easier way than to be trained. If you choose the path of “self-learning”, some procedures you will learn can take more time or perhaps not quite correct. You can always use the articles on this site for inspiration or consult the ITLektor.
Mostly searched
Flash fill
Conditional formatting
Newest Excel posts
- (Čeština) E-learning Excel – Pro pokročilé
Sorry, this entry is only available in Czech. - (Čeština) E-learning Excel – Pro středně pokročilé
Sorry, this entry is only available in Czech. - (Čeština) E-learning Excel – Podmíněné nástroje a funkce
Sorry, this entry is only available in Czech. - (Čeština) E-learning Excel – Velké tabulky
Sorry, this entry is only available in Czech. - (Čeština) E-learning Excel – Formátování tabulek
Sorry, this entry is only available in Czech. - (Čeština) E-learning Excel pro začátečníky
Sorry, this entry is only available in Czech. - 50. Videotutorial – Deal with Pivot Tables 10 – More tweaks
The last part of tutorials Deal with Pivot Tables represents tweaks that do not fit into previous episodes and it is worth to know them. Learn eg. how to fill the empty cells with zero value, to generate the detailed in-depth analysis ... - 49. Videotutorial – Deal with Pivot Tables 9 – Multiple consolidation ranges
Another episode of tutorials Deal with Pivot Tables continues with the topic how to consolidate multiple source table into one Pivot. It can be achieved using PivotTable and PivotChart wizard, which remained in Excel from older versions. If this guide has helped you, become ... - 48. Videotutorial – Deal with Pivot Tables 8 – Pivot chart
Another episode of tutorials Deal with Pivot Tables continues with the creation and capabilities of PivotChart. You’ll learn a few handy tricks and you will see a pie chart of pie. If this guide has helped you, become a fan on Facebook and recommend ... - 47. Videotutorial – Deal with Pivot Tables 7 – Filters, Slicers, Timelines
Another episode of tutorials Deal with Pivot Tables continues with the topic Filters, Slicers and Timelines. You will see how to filter simple conditions, find top values and especially use Slicers and Timelines to find what you are looking for. You can even ...
Trainer Bc. Petr Vadlejch since 2007 specializes in trainings of Microsoft Office Applications and is a certified specialist in Microsoft Office.
