- Видео 6
- Просмотров 43 921
Steven Lundy
Добавлен 24 авг 2013
Cell References
This video goes through the different types of cell references and examples of how to use each one.
Просмотров: 48
Видео
Counting Functions
Просмотров 559 лет назад
This video goes through the counting functions that are available in Microsoft Excel 2013. Video Contents 0:34 - COUNTA 1:24 - COUNT 2:10 - COUNTBLANK 2:47 - COUNTIF 3:03 - COUNTIF "Female" 3:32 - Count people with 2 pets 4:12 - Count adults, age ≥18 4:50 - Complex Counting 5:48 - Count Teenagers, 13 ≤ age ≤ 19 6:40 - COUNTIFS 7:33 - Calculating percentages 8:00 - Formatting percentages 8:21 - ...
Basic Formulae and Functions
Просмотров 539 лет назад
This video goes through the basics of entering formulae and functions into Microsoft Excel 2013. Video Contents 0:14 - Addition 0:31 - Inserting Formulae 0:53 - Editing Formulae 1:20 - Subtraction 1:34 - Multiplication 2:01 - Division 2:30 - Exponentiation (Powers) 3:00 - Example 1 - Friends with Pens 3:43 - Cell References 4:27 - Copying Formulae 5:33 - Relative Cell References 5:59 - Order of...
Spreadsheet Basics
Просмотров 609 лет назад
This video goes over the basics of navigating through spreadsheets using Microsoft Excel 2013 Video Content 0:14 - Parts of a spreadsheet 1:12 - Inputting data 1:55 - Selecting and formatting cells 3:11 - Selecting rows 3:26 - Inserting rows 3:56 - Selecting columns 4:14 - Inserting columns 4:26 - Adjusting column width 4:56 - Auto-adjusting width/height 5:12 - Deleting rows and columns 5:29 - ...
Using a Mail Merge On a Business Letter
Просмотров 8479 лет назад
This video goes through the process of performing a mail merge with a business letter and a spreadsheet of information in Microsoft Office 2013. Contents of Video 0:00 - Why Mail Merge 0:20 - Looking at the Letter 0:41 - Looking at the spreadsheet 1:27 - Selecting Recipients 2:04 - Inserting Merge Fields 3:50 - Preview Results 5:17 - Finish & Merge 5:40 - Mail Merge Envelopes 7:35 - Other uses ...
Formatting a Newsletter
Просмотров 43 тыс.9 лет назад
This video goes through the process of formatting articles into a newsletter using Microsoft Word 2013. PDF of final newsletter drive.google.com/file/d/0B6iBYJvw64mmazduZWpZVGh1dDg Contents of Video 0:00 - Insert content 0:48 - Clear formatting 1:03 - Apply styles 3:16 - Spell check 4:25 - Change Margins 4:55 - Headers and footers 5:45 - Page numbers 6:10 - Different header on first page 6:27 -...
TLDR: Formatting a newsletter involves a variety of techniques such as applying styles, adjusting margins, using page breaks, and enhancing the appearance with photos and other visual elements. 00:00 📰 Format a newsletter by copying and pasting articles, adding space, and using clear formatting, then apply Styles and shortcuts for quick formatting. 02:32 📝 Remove extra spaces, use shift enter for line breaks, and do a spell check to correct errors in the newsletter. 04:28 📰 Adjust margins, add headers/footers, use "different first page" option, organize articles with columns/sections, and adjust text box size/placement for a well-formatted newsletter. 07:55 📰 Use page breaks, headings, hyphenation, and columns to format a newsletter for improved readability and appearance. 11:28 📰 Use drop caps, small caps, and photos to enhance the appearance of a newsletter article. 14:08 📰 Adjust and enhance newsletter layout by formatting and adding captions to photos. 16:51 📰 Adding clip art and pull quotes to a newsletter can enhance visual appeal and grab the reader's attention. 19:32 📰 Customize newsletter by adjusting text size, placement, and font, and use custom styles and colors to make it unique.
I just looking for how to make it ,then i found your video.Thank you so much!
This video proved really usefull..👍
Thanks for this
Great work
Thank you for this video, it really helped me with my school project. :)
Helpful information thanks dear instructor.
I simply loved ur video..life savior for me..love u 💓
Great job Steven...thanks !
Bravo. Superbly executed
I think I learned more about Word watching this video than all other sources put together, Thanks!
Thank you, this was so usefull. I tried some software and got all wrapped up with it. Was about to give up on the whole newsletter idea till I came across this video. Today the first edition of our company newsletter was published and we got a bunch of compliments. Thought it'd be fair to pass them on to you. Thanks again :-)
This is great, Steven. So clearly understood. I don't think people have been clicking the "like" because, like me, I rushed to start applying it! Came back to like it though. Thanks for posting.