It would be impossible to do without this precious tool that is Excel When you work in a company, whether private or public, if there is one tool that no one can do without, it is Excel. The power and simplicity of the spreadsheet concept are well established.
Cells on one side, the formulas linking them, and that’s the beginning of modeling, of reporting. These modeling phases can be advanced and dominate as long as possible the beast rather than letting it dominate us, especially when we know all the riches that this spreadsheet can offer.
Further reading : How to Recognize CBD?
To practice Excel in a practical and concrete way, you have different options and various websites depending on your level.
You may also like : How to Effectively Plan Your Next Road Trip?
Microsoft Help
The first option is to use Excel’s online help on the Microsoft website directly when issues arise. Reading the documentation of a tool is the first thing to do before taking complex deviations to address a problem when it arises.
You can access this help section directly in Excel by clicking on this link or going through Excel and pressing the F1 key for the online help provided by the Seattle company. Having the reflex to RTFM, you will be surprised by what you can achieve with this attitude.
Mr. Excel
For everyday Excel users, a little discovery of new features never hurts. When using it, it’s easy to fall into a comfort routine with the tool when perhaps 80% of the features are unknown to you and could be useful from time to time.
monsieurexcel is a site hosted by Hervé Thiriez, a professor of advanced modeling at HEC. He regularly publishes on his site illustrated use cases with often very helpful and unknown suggestions to his readers. A must-visit urgently if you don’t know the site, and for those who do, an essential subscription to your RSS feed.
The articles are bold and well-documented. Don’t hesitate to take a tour!
Excel-Pratique
excel-pratique also offers you training on Excel. The approach is very educational, and there is clearly one for all levels, from beginner to expert trying to enrich their knowledge in this ideal tool for modeling.
The links provided to navigate the site will allow you to quickly access the information you are looking for. Many sheets are available online so you can progress at your own pace on Excel. The secrets of Researchv will no longer hold any secrets for you!
Here is a selection of specific products on Excel before going further. Essential reading!
- Accounting management with excel
- Convincing with effective charts: in excel, powerpoint
- Excel Introduction 2013-2016
- VBA Programming for Excel 2010, 2013, and 2016 for large format dummies
- Become an Excel expert: advanced features, macros, and VBA language
- Marketing analysis and reporting with Excel
- Full pocket functions Excel 2013
- Financial modeling with excel – from analysis to decision making
- Dashboard and budget with excel: focus – 61 worksheets – 61 personalized consulting – 61 practical cases – 100 illustrations
- Practical work with excel 2016 – Insertion and formatting, formulas, and data exploitation
- Macro and VBA language – learning to program in Excel
- Dashboard essentials: complete method and implementation with Microsoft Excel
- The search bible excel
developpez.com
For those particularly interested in the programming elements offered by Excel, you will find a section on Excel and VB programming on developpez.com. A section of the forum allows you to navigate based on the problems encountered by other users.
This site is well known among IT specialists for other languages, and it will certainly serve you in case of advanced questions about macros. To particularly put in the hands of advanced Excel users, beginners, pass the path, you might get discouraged too quickly.
admexcel.com
Isn’t that true? Be careful about appearances; if the look of the site is a bit pre-Web 2.0, its content turns out to be very interesting if you pay attention to it, especially for beginners in Excel. However, experts will be able to learn a thing or two that will complement their Excel knowledge.
You will find on admexcel many tips and tricks, videos, but also many good ideas for calculation formulas.
Many exercises still mention the franc, but that is not the main point. Beginners, this site is for you!
The last solution to work on Excel is also to regularly check reportingbusiness.fr or to subscribe by email to receive regular tips to improve and discover new things about Excel.
And you, what site do you use to improve your knowledge on OverExcel?
Be careful about appearances; if the look of the site is a bit pre-Web 2.0, its content turns out to be very interesting if you pay attention to it, especially for beginners in Excel. However, experts will be able to learn a thing or two that will complement their Excel knowledge.
You will find on admexcel many tips and tricks, videos, but also many good ideas for calculation formulas.
Many exercises still mention the franc, but that is not the main point. Beginners, this site is for you!
The last solution to work on Excel is also to regularly check reportingbusiness.fr or to subscribe by email to receive regular tips to improve and discover new things about Excel.
And you, what site do you use to improve your knowledge
Tag: train on