keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different kinds of data. 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 Forrest Training Pty Ltd - ABN 66 065 219 258 - Level 7, 83 York Street, Sydney NSW 2000 p: 02 9262 2284 | f: 02 9262 2286 | e: forrest@forresttraining.com.au | forresttraining.com.au Excel 2013/2016 Advanced Course Information Excel 2013/2016 Advanced Course Content Target Audience & Purpose Excel Advanced is for people who can already change > For Excel 2007+ use the formatting tools on the Home tab of the ribbon or for Excel 2003 use the formatting icons on the toolbar. Move, insert and copy columns, rows and cells using the Mouse + SHIFT or CTRL. 40. Move column, row or cells: Select the range of cells, column(s) or row(s) > hover your Word 2013 Advanced 5 THE INSERT TAB The Insert Tab allows you to insert items and illustrations into your document that go beyond plain text. In Word Essentials we focused primarily on the Illustrations Group within this tab. In Advanced we will go more in-depth with screenshots, hyperlinks, text boxes, quick parts, and drop caps. SCREENSHOT An easy to follow tutorial outlining everything you need to know on Excel to gain the skills to enhance your resume. Designed for the absolute beginner. Lear Bring your basic knowledge of Excel 2013 or previous software versions to this class and learn how to reach the next level of database tracking and reporting. Contents and Overview Through 52 lectures and over 12.5 hours of content, this course will take you through learning how to use functions in everyday work environments. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. 1. An Excel file is called a Workbook. - Default title is Book1 2. Ribbon broken into Tabs (Home, Insert, Page Layout…) - Tabs broken into groups (Clipboard, Font, Alignment) 3. Advanced excel 2013 bangla book (1) Apr. 28, 2015. • 19 likes • 7,527 views. Download Now. Download to read offline. Click on the Start button, choose All Programs then Microsoft Office 2013 and Excel 2013 2. Click on Open Other Workbooks (or you can use ) then Computer and [Browse] 3. Click on My Computer then double click on Data (D:) 4. Double click again on the Training folder and choose phoenix.xlsx 5. Press for [Open] Tutorial Summary. Excel 2013 is a version of Excel developed by Microsoft that runs on the Windows platform. This Excel 2013 tutorial covered the basic concepts of spreadsheets such as: Cells. Rows. Columns. And then expanded on the more advanced Excel topics such as: Sheets. Hyperlinks. Excel 2013 comes with several add-in programs that let you do some advanced data analysis. There are common Excel add-ins, such as the Analysis ToolPak or the Solver add-in. Enabling add-ins adds them to the ribbon. Just select them in the Managebox on the Add-instab of the Excel Optionsdialog box (click File> Options> Add-ins), and then click Go. In this example, imagine you have a list of values like the one at right, with the label "Year99" at the top of the column. Select the range (including the label) and choose Insert, Name, Label to open the "Label Ranges" dialog. Excel fills in the label ran