Tutorial microsoft excel 2013 pdf. Double click on blank workbook. Click on the windows start button 2. A new worksheet will be added for the pivot table. Youll then be able to load excel using the icon on the desktop.
Click the start button 2. Launch excel 2013 click the file menu then options. Excel will automatically select the data for the pivot table. Launching excel 2013 excel can be started either by selecting the program from the windows start menu or if there is an existing excel shortcut available on your computer it can be double clicked to launch the program open excel by going through these steps.
Download microsoft excel 2013 tutorial a pdf training file under 12 pages for beginners. Page 1 of 14 ms excel advanced formulas 6172015mms microsoft excel 2013 advanced formulas commonly used excel formulas look up values in a list of data. Initially the spreadsheet will appear blank. Double click again on the training folder and choose phoenixxlsx 5.
All you need to do is download the training document open it and start learning excel for free. Automatically open files under folder in excel 2013. Lets say you want to look up an employees phone extension by using their badge number or the correct rate of a commission for a sales amount. Starting excel to start up the program.
The round office button is gone. Open excel start screen 1. Take advantage of this course called microsoft excel 2013 tutorial to improve your office skills and better understand excel. Select microsoft office 4.
In the options window click the advanced tab and scroll down to general section. Choose all programs then microsoft office 2013 followed by excel 2013 tip. Click on open other workbooks or you can use ctrl o then computer and browse 3. To create a shortcut on the desktop right click on excel 2013 then choose send to followed by desktop create shortcut.
Double click on the excel icon on your computers desktop or click on start all programs microsoft office and on excel 2013. This course is adapted to your level as well as all excel pdf courses to better enrich your knowledge. Excel will also automatically select new worksheet as the destination for the pivot table. Microsoft excel topics covered in this document 2013.
The lessons of this excel training are well detailed and well imaged to allow people who start excel to understand and follow it easily. To get to options like open save save as print etc click on file in the upper left corner. Select all programs 3. This tutorial is about the steps required to automaticallyopenexcelfiles under specified folder during the startup of excel 2013.
Become more will help you proficient with the excel application. The pivottable field list is located to the right.