The ULTIMATE Guide to Spreadsheet Basics for EVERYONE
I have had to teach spreadsheet basics so many times to so many people, I decided it was time to put the basics into a video.
Even if you are an experienced spreadsheet user, you may learn some new things in this video, or you may be able to offer suggestions or corrections for what is taught here.
In any case, whenever someone asks you to explain how spreadsheets work, you can now refer them to THIS video!
CHAPTERS:
00:00 Opening
01:24 Chapter 1 - Getting Set Up
02:27 Chapter 2 - Definitions and Spreadsheet Layout
05:41 Chapter 3 - Types of Information
08:10 Chapter 4 - Using Cell References
14:53 Chapter 5 - Drag-Duplication
19:19 Summary
20:40 Closing
========================================
Check out our companion website: www.DavidsTutorials.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Most links below are affiliate links – they don't cost you any more but go to help support our channel – not a lot, but some. Items marked with * were used in this video.
MY AUDIO EQUIPMENT:
Zoom H1n digital recorder: https://amzn.to/2VxOVHR
Rode Smartlav: https://amzn.to/2VsYise
I now use this combination to get outstanding audio, which I then sync in post to the videos.
Blue Yeti: https://amzn.to/2VuHscv
This is my choice for when I record screencast tutorials; it records the voice directly into the screen recording.
MY VIDEO EQUIPMENT:
Sony AX700: https://amzn.to/2ECX6wC
I use a camcorder instead of a DSLR because I often record live shows of more than an hour, and a DSLR has a 30-minute shoot limit. The camcorder does not.
AngeTube Webcam 1080p: https://amzn.to/3l4S5QV
X-Rite ColorChecker Passport (for) Video: https://amzn.to/3j3YxWw
Sony CX260: https://amzn.to/2T30IRz
This is a VERY LIGHTWEIGHT camera – less than 1 pound (my version is a 2011 model PJ260V) – that still shoots great HD video. This is the camera I carry when on vacation with my family because of how lightweight and easy it is to carry all day long. It takes great stills as well as video.
GoPro Hero6 Black: https://amzn.to/2SzdtOu
Super tiny portable, with HD and wide-angle lens. Great for those crazy-angle shots you can't get any other way.
iPhone 8+ - https://amzn.to/2OZmEry
This has amazing video capabilities, especially when paired with the next item.
Zhiyun Smooth 4 Gimbal for iPhone: https://amzn.to/2UkrV2J
The iPhone 8+ BARELY fits into this, but it provides no-screen-touch controls for zoom, focus, frame rate, and much more. If you have an iPhone NOT a plus model, it should work even better. If you know of a better gimbal for a larger smartphone like the 8+, please let me know.
SOFTWARE:
Blackmagic DaVinci Resolve (free)
Adobe Premiere Pro (not free)
Camtasia (latest version): https://techsmith.z6rjha.net/65ED3
Audacity (free)
Irfanview (free)
Magix Xara Designer Pro X ($299): https://bit.ly/2THg6RO
=======================================
Background music (at the end):
Five Card Shuffle by Kevin MacLeod
Link: https://incompetech.filmmusic.io/song...
License: http://creativecommons.org/licenses/b...