302 Microsoft Excel – Creating and Editing Spreadsheets

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

 

The Australian Small Business Training and Support

Subscribe to our business blogCourses, Training and Support.

Get bookkeeping, marketing, operations, customer service, sales and finance knowledge via email. Keep up to date with new and emerging trends and technologies and get our free samples.

Enquiry Form

  • This field is for validation purposes and should be left unchanged.
Call Now Button
%d bloggers like this: