Excel some of the most popular and efficient features of microsoft excel are as follows: efficiently model and analyze almost any data. Correct data is located quickly. Create graphs of data in a single cell. Access to our spreadsheets from virtually anywhere. Supports collaborative work. Pivotcharts more interactive and dynamic. Ability to build larger and more complex spreadsheets. Publish and share through excel services. The next page details what's new in excel . In short, with excel we can create sophisticated data presentations easily and quickly.
We also have the ability to customize and automate any operation through the use of vba. With excel we have at our disposal a bi (business intelligence) platform of great added value. Excel is flexible and creative enough to tackle almost any business e commerce photo editing service need. Inesem business school advanced excel course 2016 (university degree with 5 ects credits) more information you can learn more by reading the business intelligence and dashboards articles . We are going to see tricks to use excel and thus get the most out of this application. Navigation tricks in excel switch between different excel files when we have different spreadsheets open, it is really annoying to switch between different files. This is important because sometimes working with the wrong sheet can mess up the whole project.
Using ctrl + tab you can switch between different files freely. This feature is also applicable to other files like different windows tabs in firefox. Quick navigation with ctrl + arrow button when you click ctrl + any arrow button on the keyboard, you can jump to the edge of the sheet in different directions. If you want to jump to the bottom line of the data, just press ctrl + down button. Open multiple excel files at once instead of opening files one by one when you have multiple files to handle. There is a handy way to open them all with one click. Select the files you want