I strongly believe that this MS excel course will really be worth watching for you & I am sure that you will be very happy to choose this. Conditional Formatting, Sort & Filter Options Info, Text, Date, & Reference Functionsġ4. Inserting Charts, Tables, Comments & Hyperlinkġ2. AutoFill, Paste Special Options & Excel Errorsġ1. Absolute & Relative References and Excel Cell Nameĥ. This course is divided into the following different sections:ģ. Also, the MS excel shortcut keys file is attached. This course is designed in Microsoft Excel 2016 version but you can easily learn in almost any older or latest version of MS Excel.Įxcel sample files or excel practice worksheets are attached that you can & practice on. Just to facilitate the bners, some basic or entry-level topics are also included but you can skip those if you already have the basic knowledge. This course is designed by assuming that you have very basic knowledge of excel or you are totally bner & started using MS Excel the very first. If your interest lies in any of the above-mentioned areas or any other field where Excel is used then this MS Excel training course really going to help in your work.Įxcluding the preview video, this Microsoft Excel course has a total of 42 video lectures with a total length of almost 4.5 hours. This MS Excel course is Bner to Intermediate Level training especially for eeers, auditors, record keepers, data analysts, data entry operators, students, teachers, or researchers, or for anyone who just wants to learn MS Excel. After you have found both the column and the row trace an invisible line from each to the cell where they intersect and click there if you wish to enter data.Microsoft Excel is one of the most used products of Microsoft office & used for data entry, data analysis, data presentation, or calculation.
Your spreadsheet vocabulary to make using Excel that much easier. Nearly every part of the spreadsheet has its own term and it is quite useful to know When you start up Excel, you should be greeted with a blank spreadsheet like the one we have below. The spreadsheet (or worksheet) contains or will contain all the data that you enter. To the Excel program you are running at home or in the office. Have included several diagrams of actual Excel spreadsheets, which we encourage you to compare Some vocabulary so that you can understand the following lessons of Tizag's Excel Tutorial. This lesson will teach you about the different elements that make up a spreadsheet, including