ZAP ACCOUNTING SOFTWARE
  • Home
  • Testimonials
    • Sales System Templates
    • Bookkeeping Template
  • The Challenge
  • Education
    • !! Start Here !!
    • ----------------------
    • Single Page Visuals (and more...)
    • Fun Seekers Corner >
      • FSC 101
    • Accounting Studio Magic >
      • ASM 101
      • ASM 103
    • ----------------------
    • Software in Greater Detail... >
      • Spreadsheets 101
      • Sales Systems 101
      • Bookkeeping 101
      • DIY Software Programming 101
    • Intro Videos
    • Books & Pamphlets
    • ------------------------
    • Empowerment
    • Reimagination
    • ----------------------
    • End User Benefits
    • FAQs
  • Software
    • !! Start Here !!
    • ----------------------
    • Via the 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Invoicing 101 - Petes Electric
      • Statements 101 - Martha's Counseling
      • Legal Billing (images only)
    • Box 2 >
      • Expense and Profit Analysis
      • Time and Attendance
      • Payroll System
    • Box 3 >
      • Bank Deposit Prep WB
      • Acc'ts Receivable - Digital Bar Tab
      • Acc'ts Receivable - Double Entry
    • Box 4 >
      • Check Journal Example
      • Check Journal w/ 3 up Printing
      • Acc'ts Payable - Simple Digital List
    • Box 5 >
      • Bookkeeping
      • Transaction Generator
      • Bank Statement Generator
      • Bilbo's Bank - Faux Bank Website
      • Manual Balance Sheets
    • Box 6 >
      • Tax Prep Summary Worksheet
      • Tax Return Journals
      • Taxable Income Tracking
      • Tax Simulation & Estimating (Fed, State, PremTaxCred)
      • Real Estate Transaction Journal
      • Sales Tax Remittance Tracking
    • ------------------------
    • Other >
      • Accounting Master File
      • DIY1 uBoundGScriptProject
  • FAQs
  • More...
    • Orientation >
      • ------ INFORMAL ------
      • Models & Data Flow for folks on the GO!
      • Problems, Solutions and Bigger Backstory
      • ------- FORMAL -------
      • Step 1 - Welcome
      • Step 2 - Custom For You... >
        • Accounting Alchemists
        • Categorizing Crackerjacks
        • Simmering Sages
        • Sorcerous Students
        • Magical Millennials
        • Enchanting Educators
        • Spreadsheet Gurus, Javascript Wizards, Database Devils, & Full Stack Devs too...
      • Step 3 - Reunited!
      • Step 4 - The Accounting System 6 Box Model
      • ----------------------
    • For CPAs >
      • Welcome & Orientation
      • Resources >
        • Bookkeeping Template Data Flow Details
        • Balance Sheet Re-imagined
        • Income Statement Re-imagined
        • Bookkeeping Re-Imagined
        • Demystification Documents
        • Empowerment For CPAs
      • Notifications >
        • 11/6/2021 - Sea Change Notice
        • 1/17/2022 - The Opportunity
        • 5/14/2022 - Seeking CPE Partners
    • Contribute
    • Admin > Login/Logout
    • Archive >
      • Home_out20210331
      • Commerce Snippets
    • About
    • Contact
  • Home
  • Testimonials
    • Sales System Templates
    • Bookkeeping Template
  • The Challenge
  • Education
    • !! Start Here !!
    • ----------------------
    • Single Page Visuals (and more...)
    • Fun Seekers Corner >
      • FSC 101
    • Accounting Studio Magic >
      • ASM 101
      • ASM 103
    • ----------------------
    • Software in Greater Detail... >
      • Spreadsheets 101
      • Sales Systems 101
      • Bookkeeping 101
      • DIY Software Programming 101
    • Intro Videos
    • Books & Pamphlets
    • ------------------------
    • Empowerment
    • Reimagination
    • ----------------------
    • End User Benefits
    • FAQs
  • Software
    • !! Start Here !!
    • ----------------------
    • Via the 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Invoicing 101 - Petes Electric
      • Statements 101 - Martha's Counseling
      • Legal Billing (images only)
    • Box 2 >
      • Expense and Profit Analysis
      • Time and Attendance
      • Payroll System
    • Box 3 >
      • Bank Deposit Prep WB
      • Acc'ts Receivable - Digital Bar Tab
      • Acc'ts Receivable - Double Entry
    • Box 4 >
      • Check Journal Example
      • Check Journal w/ 3 up Printing
      • Acc'ts Payable - Simple Digital List
    • Box 5 >
      • Bookkeeping
      • Transaction Generator
      • Bank Statement Generator
      • Bilbo's Bank - Faux Bank Website
      • Manual Balance Sheets
    • Box 6 >
      • Tax Prep Summary Worksheet
      • Tax Return Journals
      • Taxable Income Tracking
      • Tax Simulation & Estimating (Fed, State, PremTaxCred)
      • Real Estate Transaction Journal
      • Sales Tax Remittance Tracking
    • ------------------------
    • Other >
      • Accounting Master File
      • DIY1 uBoundGScriptProject
  • FAQs
  • More...
    • Orientation >
      • ------ INFORMAL ------
      • Models & Data Flow for folks on the GO!
      • Problems, Solutions and Bigger Backstory
      • ------- FORMAL -------
      • Step 1 - Welcome
      • Step 2 - Custom For You... >
        • Accounting Alchemists
        • Categorizing Crackerjacks
        • Simmering Sages
        • Sorcerous Students
        • Magical Millennials
        • Enchanting Educators
        • Spreadsheet Gurus, Javascript Wizards, Database Devils, & Full Stack Devs too...
      • Step 3 - Reunited!
      • Step 4 - The Accounting System 6 Box Model
      • ----------------------
    • For CPAs >
      • Welcome & Orientation
      • Resources >
        • Bookkeeping Template Data Flow Details
        • Balance Sheet Re-imagined
        • Income Statement Re-imagined
        • Bookkeeping Re-Imagined
        • Demystification Documents
        • Empowerment For CPAs
      • Notifications >
        • 11/6/2021 - Sea Change Notice
        • 1/17/2022 - The Opportunity
        • 5/14/2022 - Seeking CPE Partners
    • Contribute
    • Admin > Login/Logout
    • Archive >
      • Home_out20210331
      • Commerce Snippets
    • About
    • Contact

Education > Software Systems > Spreadsheets 101

Start with this case study and some simple practices to introduce the idea of google sheets.
  • https://spreadsheets-for-all.weebly.com/

Key Strokes you will need to know. Most are basic. A few at are not intuitive
  • Ctl-C and Ctl-v for cells, the stuff in cells, column(s), row(s)
  • Ctl-x and backspace for deleting
  • Ctl-shift-V for past special values only as a keystroke
  • Ctrl-shift-arrow (down/up/right/left) to bulk select (can do ctrl-shift-arrow right to grab a row, and then with ctrl-shift still down, click arrow down to get entire data set selected) (VERY IMPORTANT)
  • Paste Special - values and format
  • Freeze Rows, sort sheets by column with frozen rows
  • Sort Range (not sheet), and do it by a row other than the first row
  • Ctrl - Arrow down and Ctrl-Arrow up for jumping around  (VERY IMPORTANT)
  • You are at the bottom of a large data table with frozen rows at top.  You want to get to the first rows of data. do NOT scroll up to get there.  click into cell in the frozen area, then arrow down until you go past the botton frozen row. (VERY IMPORTANT).
  • To fill the download set ID on the rawTxns worksheet, click into first cell in row and type the value and leave the cell. THEN, highl;ight the cell. Then click on little X in bottom right corner of cell to autofill down. 
What's a HELOC in 1st?  Link coming soon...
ZAP Accounting Software - a 
220Club Initiative - copywrite 2017 and beyond...
Proudly powered by Weebly