| |
| |
|
|
| |
|
|
|
|
|
Our
Excel 1 and Excel 2 classes are full length classes.
I have broken down the classes with time increments, so
you can move forwards or backwards to the point in the
class that you want to review. |
|
|
Excel 1 (58:00) |
|
|
Excel 1 |
|
|
Note: this
is a recording of a live webinar |
|
|
Begin: Introduction to
Class |
|
|
3:21: Ended PowerPoint
presentation | Windows logo key | How to open Excel |
Create an Excel shortcut on desktop | Show desktop icon |
|
|
5:23: Overview of Excel
| Excel toolbars | Comparing Excel to Word | What is a
workbook? | What is a worksheet? | Sheet 1, sheet 2 &
sheet 3 | Workbook name | Title bar | Columns & Rows |
Name box | Cells | Moving around a spreadsheet | Arrow
keys | Page up & page down keys | How many rows? |
Keyboard shortcuts | How many columns? | Find & Replace |
|
|
17:20: Why use Excel
| Is Excel the best choice? |
|
|
19:10: Starting to
use Excel | Example: tracking employee information |
Entering information | Anticipating what I type | Zoom |
Cell spillover | Resizing columns & rows | Leading zeros
| Selecting multiple cells | Should I be thing about a
template? | Undo & Redo |
|
|
27:11:
Formatting cells | Formatting Columns & Rows | Phone
numbers, social security numbers, currency, zip code |
Rethinking a template |
|
|
31:25: Moving
information | Pointer Shapes | Duplicating the contents
of a cell (fill) | Completing patterns | Creating a
numbered list | See: Fill Series
Box (coming soon). |
|
|
35:50: Saving a
Template as an Excel file | See: Template tutorial |
NOTE: on the tape I say I'm taking a break
(it was a live class), please disregard, I edited it
out. |
|
|
38:10: Introducing
Tony's Place | Formatting Tony's Place: making it look
better | Cleaning up the numbers | Increase and decrease
decimal: cleaning up the numbers | Working with round
numbers | Editing contents of a cell | Formula Bar |
|
|
43:50: Calculations:
Adding together multiple cells | AutoSum | Dancing black
ants |
|
|
45:30: The 1/3, 1/3,
1/3 Rule |
|
|
46:42: Manipulating
data in a spreadsheet | Discussing the data | There's a
problem | Insert a comment | Viewing a comment | Be
careful with comments | Hiding a column or row | Unhide
| Rows and columns are the same |
|
|
52:16: Adding a row
or column | How it impacts a formula | Adding multiple
rows or columns |
|
|
53:58: Introduction
to formulas | Cheating to remember! | Closing remarks |
|
|
|
|
|
Excel 2 (55:00) |
|
|
Excel 2 |
|
|
Begin:
Quick review
of Excel 1: Includes formatting | Increase & decrease
decimal point | Formula bar | AutoSum | Creating formulas
| Using control and shift key to select cells | Understanding an existing spreadsheet
| Using Google to
help with Excel | Working with tabs | Tab colors I Tab
scroll bar. |
|
|
15:01:
AutoFilter | Zooming in and out | Selecting multiple columns or rows
| Filtering multiple columns | Drilling down filtered
results. |
|
|
23:11:
PivotTables | Understanding your data | PivotTable wizard, selecting
data for your PivotTable | PivotTable field list | Organizing PivotTable data
| Filtering a PivotTable | Practice makes perfect. |
|
|
32:41:
Excel options | Recent file list count |
Reviewing different tabs | Password protection | Zero values
| Comment options and
more. |
|
|
39:11: Creating a
copy of a worksheet | Deleting a worksheet | Selecting
data in multiple worksheets | Changing data in multiple
worksheets. |
|
|
44:11: Side-by-side
comparisons. |
|
|
46:43:
A bunch of
little things: naming a series of cells | Creating a
commissions formula | Using a formula with a named cell
| Conditional formatting and closing comments. |
|
|
a |
|
|
Excel 3: A Series of Short Tutorials (136:00) |
|
|
Creating Formulas
(8:00)
Filtering Data
(6:00)
PivotTables 1
(6:00)
PivotTables 2
(7:00)
All items below were added after
9-7-2009
Save vs. Save As
(7:00)
Adding a shortcut to Save As to the toolbar
(3:00)
What is an Active Cell?
(1:00)
Always Show Full Menus in
Word, Excel & PowerPoint
(2:00)
Pick from a dropdown list
(2:00)
Add a custom list to Excel
(3:00)
Excel's help feature: I'd use Google
(4:00)
Excel's Spell check feature
(2:00)
Concatenate Formula: Merging Stuff Together
(5:00)
Putting same thing in multiple cells
(1:00)
Excel paste options
(6:00)
Creating a Fill Series
(4:00)
All items below were added after
9-27-2009
Understanding autofill options
(3:00)
Tony's Place quick review (to help with upcoming
tutorials)
(2:00)
AutoSum and some common Excel formulas
(3:00)
Working with rows and columns
(3:00)
Excel options
(2:00)
Formatting text options
(3:00)
AutoFormat
(1:00)
Freeze Panes
(2:00)
Two common formula errors
(2:00)
Copying and pasting a formula
(3:00)
Absolute and relative reference
(3:00)
Now formula
(2:00)
Editing worksheet tabs
(2:00)
Specialty formatting
(3:00)
Conditional formatting
(2:00)
Printing a spreadsheet
(3:00)
Data validation
(2:00)
Named cells: naming a range
(5:00)
Creating formulas with named ranges
(6:00)
Creating a formula using multiple worksheets: Part 1
(3:00)
Creating a formula using multiple worksheets: Part 2
(2:00)
Linking a formula to a second workbook
(3:00)
Added
after 10-1-2009
Introduction to Excel Charts: I love charts, I hate
charts (7:00)
Showing (exposing) formulas in a spreadsheet
(2:00)
Adding a calculator to the toolbar
(2:00)
Adding a comment in Excel (4.00)
VLOOKUP Introduction: The Scenario & Example (6.00)
VLOOKUP Part 2: Looking at the formula (4.00)
VLOOKUP Part 3: A search engine for your spreadsheet (8.00)
|
|
|
|
OFFICE 2007
| |
NOTE:
For best viewing watch
my QuickBooks tutorials in a screen resolution of 800x600. |
| |
QuickBooks 1 (29:00) |
| |
Introduction to QuickBooks Part 1
Overview: you learn by doing | Don’t be intimidated by QuickBooks |
Practice makes perfect | time: begin to 3:40
My
approach to QuickBooks | QuickBooks home page | Creating an Invoice for
RRR Painting | Widgets as an item | Tab key & keyboard shortcuts | Quick
Add vs. setup | Numbering invoices (make it look like you’ve been in
business forever | Adding more detail to an invoice | The first month is
the hardest | QuickBooks is great because you learn by doing | The first
month is the hardest and most time consuming | You learn a great deal
about QuickBooks by creating your first invoice | Creating items | Sub
items
time: 3:40 to 18:45
Getting
you comfortable with QuickBooks versus making you the world’s best
accountant | QuickBooks is easy to use | Invoice options: print, batch
print, email and save as a PDF | Emailing an invoice as an attachment |
You created an invoice, now you have something to report about |
Creating an accounts receivable report | Getting around a report | The
zoom tool (magnifying glass drills down) | Your first customer, invoice
and report…very easy | Save an invoice | Starting a new invoice | Open
windows on left | Planning what things should be called
time: 18:46 to end
|
| |
QuickBooks 2
(21:00) |
| |
Introduction to QuickBooks Part 2
Receiving Payments | Where does the payment go? | Creating a
checking account | Chart of Accounts | Tony’s Checking Account | Opening
Balance | Outstanding checks | Quick review of checking account |
Managing a payment | Viewing open invoices | Applying payments to the
proper invoice | Using the tab key | Where do you deposit your received
payments? | Check deposit logistics | Using the dropdown calendar to
select a date | Save and close | Funds out of receivables and deposited
into checking account
time: begin to 10:00
Creating shortcuts on
toolbar | Icon choices | Partial payments | Match payments to invoices |
Creating estimates | QuickBooks email service | Estimate Options | Save
as PDF | Converting an estimate to an invoice | Printing options | More
than one way to do the same thing | Don’t worry, mistakes will be caught
when you reconcile | QuickBooks email server | Sending an email via
QuickBooks
time: 10:01 to end
|
| |
QuickBooks 3
(22:00) |
| |
Introduction to QuickBooks Part 3
Ways to get paid
| Sales receipt | Invoice vs. Sales Receipt | Deposit to | Make deposits
| Save & close | Chart of Accounts | Checking account shortcut on
toolbar | Simplify QuickBooks | Makes it easier to train others | Make
reports easy for the boss | Accounts receivable report | Shortcut to AR
report | Writing checks | Date issues | Today’s date | Keyboard
shortcuts | T for Today | M for Month | Fred Jones example | Quick add
vs. setup | Avoiding the mouse | Vendor, customer, employee or other |
Entering a check in register | Account field | Memo Field | Running
account balance
time: begin to
13:30
Downloading
banking information | Backup strategies | How to backup | Backup options
|
Carbonite | Files out of office
time: 13:31 to end
|
Web Design featuring
FrontPage (105 Minutes)
Part 1: Introduction
(16:00)
Part 2
(29:00)
Part 3
(31:00)
Part 4
(29:00)
|
|
|
More than
40
hours of
Free Computer Training!
|
