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 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. 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 In order to get the most out of this class, you will need to feel comfortable: • Using Windows 8.1 • Using Excel 2013 and the "ribbon" • Switching between worksheets • Copying and Pasting • Using formulas in Excel • Using the right mouse button for context menus Throughout this course we will use several practice files. 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] Advanced excel 2013 bangla book (1) Apr. 28, 2015. • 19 likes • 7,527 views. Download Now. Download to read offline. 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 range. Specify that you're using "Column labels" and click OK. 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 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. 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 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