Data Science BootCamp with Jonathan Bechtel

In addition to basic formatting you'll learn how to cut & paste, copy and paste, set margins, line spacing, justification, add graphics, add borders & shading, add bullets & numbers, run Spell Checker & Grammar Checker, use the Thesaurus, add Special Symbols, use Find & Replace, and more. Word Basics: Create, Close, Save, Preview,...

Navigate the user interface. Create a QuickAccess Toolbar so your favorite features are one click away. Create, edit, save, close, open, view, export, and print presentations. Burn a presentation onto a CD or flashdrive. Share a presentation online. Hide and unhide slides. Learn handy keyboard shortcuts for using PowerPoint. DESIGN PRINCIPLES: Learn...

Create estimates. Base invoices on information in an estimate. Add Reimbursable Expenses to invoices and mark-up the amounts to make a profit. TIME TRACKING Use Timesheets to track time for different projects and use Timesheet data for invoicing, in payroll, and reports. CLASSES Use "Classes" to track and compare different parts of your business....

Take your Excel skills to the next level and create formulas using parentheses, combine information from different sheets or files, use Validation to create look-up lists and limit what users can input, password protect all or part of a sheet, use Conditional Formatting to make important values stand out, and analyze large spreadsheets with PivotTables. ...

This class is intended for: PC/Windows Users: Excel 2010-2013-2016-2019-365 Course Materials: FREE Certificate of Completion (optional): $5 Course Length: 1 Day Basic Functions: Average (average a range of cells) Max (display highest number in a range cells) Min (display lowest number in a range of cells) Sum (sum or total of a range of...

QUICKBOOKS BASICS:Navigating in QuickBooks, setting-up a company, working with Chart of Accounts.LISTS:Create & Edit Customer, Vendor, and Item lists (products, services, taxes, and shipping).ACCOUNTS RECEIVABLE:Create, Edit, Customize, and Print invoices and Sales Receipts. Apply full or partial payments to open invoices, and make deposits. ...

SETUP: Setup your company "from scratch" OR Import your company file from QuickBooks Desktop Version OR Import individual lists (Customers/Vendors/Items) from QuickBooks Desktop Version or Excel Navigate QBO Program Customize Program Settings Setup Chart of Accounts (Income/Expenses/Assets/Liabilities) Setup Checking/Savings/Credit Card Accounts...

Since 1992 we have provided affordable, hands-on computer training classes to over 25,000 San Diego residents and businesses. Our classes are small, reasonably-priced, and to the point - a winning combination that has proved popular with our students. Instructor is a Certified Microsoft Office Specialist (Master level) and QuickBooks ProAdvisor with...

Recommended for anyone who hasn't worked with formulas or charts before or those with little or no experience with Excel. Great refresher course for students who haven't used Excel in a long time. Learn how to navigate the Excel user interface. Customize the Quick Access Toolbar to include your favorite commands. Learn many keyboard shortcuts that...

Create more complex documents using Breaks (page / column / continuous), add page numbers, wotk with columns, set custom Tab Stops, add Headers & Footers, use Footnotes and Endnotes, create tables, insert charts & diagrams, use Track Changes, add Hyperlinks and Bookmarks, and more! Breaks: Insert page breaks, section breaks, and column...

Use Styles to format a document, create envelopes & labels, use Mail Merge, insert an Index, Table of Contents, Table of Figures, Bibliography, and Table of Authorities, create Macros to automate repetitve tasks, use Quick Parts for re-usable content, and fill-in fields, etc. Styles & Themes: Create and use Styles and Themes to quickly...

Learn about E-mail, Folders, Contacts, Calendar, Planning a Meeting, Tasks, Notes, and the Journal. Outlook Basics: Become more productive at home or at work with this easy-to-use information management program. MS-Outlook helps you organize and share data, manage e-mail messages, appointments, contacts, tasks, files and activities. Contacts:...

Take your QuickBooks skills to the next level. Learn about Payroll, Estimates, Progress Billing, Importing & Exporting Lists, Fixed Assets, Reimbursable Expenses, Journal Entries, and more. ESTIMATES & INVOICES Create estimates. Base invoices on information in an estimate. Add Reimbursable Expenses to invoices and mark-up the amounts to make...

Create a number of different Queries that will sort and filter data using different criteria such as name, amount, and date. Use multiple criteria (text, numbers, dates) to narrow a search, use wildcards, use parameters, filter data by text, a range of dates or amounts, etc.  Create queries based on existing queries/tables, rename queries, and...