Microsoft Excel – Creating and Editing Spreadsheets
Selecting information: Understanding the mouse cursors used within Excel, how to select cells, columns and rows and multiple ranges of information, how to select cells using the keyboard.
Copy and Paste: Drag and drop, cut, copy and paste in a worksheet and from one worksheet to another and even between different software programs.
Editing cells: Typing and entering information, editing existing information and entering the changes, using the status bar information, escaping out of cells. Changing column width and row height for single and multiple columns as well as making all the columns the same width and using AutoFit.
Database: Creating a simple database, understanding simple database structure (ideal knowledge for mail merge with Microsoft Word), Inserting and deleting columns, using Undo and redo options.
Autofill: Automatically fill numbers, dates, number patterns, days, months and years and much more. The fast way to insert sequential numbers and words. Understanding date formatting (this forms the basis for future calculations based on date format).
Training Video List
Section 1 Videos
Selecting information: Understanding the mouse cursors used within Excel, how to select cells, columns and rows and multiple ranges of information, how to select cells using the keyboard. Copy and Paste: Drag and drop, cut, copy and paste in a worksheet and from one worksheet to another and even between different software programs.
302101 – mouse pointers and active cell (Length – 2:25)
302102 – selecting cells, rows and columns (Length – 3:12)
302103 – select all and multiple ranges (Length – 3:46)
302104 – multiple columns and selecting text (Length – 2:40)
302105 – selecting text using the keyboard (Length – 3:29)
302106 – Drag and drop (Length – 2:51)
302107 – cut and paste (Length – 2:57)
302108 – copy and paste (Length – 3:31)
302109 – copy and paste between sheets (Length – 4:48)
302110 – copy and paste between programs (Length – 3:39)
Section 2 videos
Editing cells: Typing and entering information, editing existing information and entering the changes, using the status bar information, escaping out of cells. Changing column width and row height for single and multiple columns as well as making all the columns the same width and using AutoFit. Database: Creating a simple database, understanding simple database structure (ideal knowledge for mail merge with Microsoft Word), Inserting and deleting columns, using Undo and redo options.
302201 – entering information (Length – 5:48)
302202 – editing information (Length – 3:37)
302203 – Status bar in Excel (Length – 2:25)
302204 – Editing & ESC out of cells (Length – 3:10)
302205 – Column width and row height (Length – 2:22)
302206 – Width of several rows or columns (Length – 2:39)
302207 – AutoFit (Length – 3:16)
302208 – Creating a simple database (Length – 4:51)
302209 – more about databases (Length – 3:33)
302210 – insert and delete columns and rows (Length – 4:17)
302211 – Undo and Redo options (Length – 1:54)
Section 3 videos
Autofill: Automatically fill numbers, dates, number patterns, days, months and years and much more. The fast way to insert sequential numbers and words. Understanding date formatting (this forms the basis for future calculations based on date format),
302301 – Excel – Using AutoFill (Length – 3:10)
302302 – Excel – Autofill a series (Length – 2:29)
302303 – Excel – AutoFill dates (Length – 3:23)
302304 – Excel – AutoFill Shortcut menu (Length – 2:55)
302305 – Excel – AutoFill Days, Months, Years (Length – 3:13)
302306 – Excel – Date formatting (Length – 1:49)
302307 – Excel – increasing numbers using fill handle (Length – 3:17)
302308 – Excel – AutoFill exercises (Length – 2:22)
Back to Microsoft Excel Training Courses outline Enrol now
