|
Word - for beginners RIGHT-click on the files below and save them to your computer. Fonts - optional - practice changing fonts Cut and Paste - optional - practice using cut and paste My Amazing Grocery List - optional - practice bullets and numbers
First Winter in Canada- formatted - your completed version should look like this file
FAQ - formatted - your completed version should look like this file
Invoice - work on it in class - show your completed version to Tyler
January 8 Table 1 - work on it in class - show your completed version to Tyler For Table 1, set your Table's cell margins to 0.04" on top, bottom, left and right margins:
Table 4 - work on it in class - show your completed version to Tyler
January 9 Food Articles - open this file and make changes to it using the Instructions below Instructions - Food Articles Assignment - show your completed file to Tyler Food Articles - your finished document should look like this one
British Airways Brand Guidelines (Style Guide) History of Canada - Practice line spacing, page numbers, inserting graphics, custom styles, table of contents - History of Canada instructions
How to use tabs and indents in Word Practice file - indents and tabs Practice file - set a tab to make a Table of Contents
January 14 How to Start Page Numbers Anywhere in a Word Document
Watch the video - adding page numbers - 5:16
January 15 History of Alberta - unformatted History of Alberta - instructions History of Alberta - make your document look like this one
January 16 Fillable Form - Personal Info - work on it in class - show your completed version to Tyler Investor Information Request Form - create this as a fillable form - show your completed version to Tyler
January 17 Christmas Invitation - or make an invitation for Diwali, Holi, Eid, Moon Festival or some other event. Work on it in class. Show your file to Tyler.
January 20 Excel - Invoice - create this invoice in Excel and make it auto-calculate. To be completed by today! show your file to Tyler Excel formula practice - to be completed by Wednesday January 22 - email your file to Tyler
January 21 Open the Charts Excel file below and create 4 new sheets (tabs) and label the tabs for each of the exercises below Charts - download and open this file Excel - chart - favourite films Make Beautiful Excel Charts Like The Economist - we will create the Bar Chart from the first part of the video
Video - Basic formatting in Excel Practice file for basic formatting in Excel
Video - Modifying Columns, Rows, and Cellsl Practice file - Modifying Columns, Rows, and Cells
Excel - how to do IF Statements IF - exercise - to be completed by Thursday January 23
January 22 Video - how to do conditional formatting in Excel (3:46) - watch the video and use the practice file below Practice file for conditional formatting in Excel
Video - Excel Tables (3:19)
Video - how to do filter data in Excel (4:45) practice file for filtering in Excel
Excel - practice sheet for sorting
January 23 SUMIF - exercise - to be completed by Friday January 24
January 24 Excel - Pivot Tables Video - How to create Pivot Tables in Excel (4:34) Instructions for Pivot Table - 1
January 27 Video - Pivot Tables in Excel - with Filters, Slicers and Pivot Charts (3:28) Sales - pivot tables - show your completed file to Tyler Movies - pivot tables - show your completed file to Tyler Pivot Tables and Charts - practice file with sales data - show your completed file to Tyler
January 28 Quorum - PowerPoint Practice (Zip file) - work on it today - show your completed file to Tyler
Excel - Interactive Dashboard Exercise - work on it in class Instructions - Interactive Dashboard Exercise
January 29 Map of Canada - add map to Presentation and add triggers to it Siddhartha Corsus - Bhagavan (MP3)
20 Really Good PowerPoint Examples to Inspire Your Next Presentation Why are visuals more effective than words?
The human brain processes visual content 60,000 times faster than text. That means that a picture is actually worth 60,000 words! Even more, 90 percent of information transmitted to the brain is visual. We observe, learn, process and decide with visual information.
January 30 Suncor - income statement and instructions - to be completed by today Suncor - sample file - make your document look like this one
IF and SUMIF Function - exercise - to be completed by Monday February 3
January 31 How to do Mail Merge in MS Word Mail Merge - assignment - to be completed by Wednesday February 5
February 4 Video - how to use Freeze Pane (4:21) Excel - practice sheet for using Freeze Pane
Data Entry Form How to create a Data Entry form in Excel Data Entry form - use this file along with the instructions from the above file Data Entry Typingclub.com - Pracice Typing Numbers (top of keyboard) - see Lessons 245 to 274 If doing a lot of number entry for data entry, you may want to use the Numeric Keypad on the right of your keyboard.
Excel - Create a Fillable Form and lock it Excel - How to Create a Fillable Form and lock it - instructions Cheque requisition form (PDF) - create this form in Excel
February 6 Dashboard Exercise 3 Video - Instructions - Video (15:26) Dashboard Exercise 3 - Excel Data - Email your completed file to Tyler
|