You're browsing Business Software Training in San Diego, CA

FORMULAS: Use AutoSum to add numbers Use Formulas to calculate numbers Use AutoFill to copy formulas Understand the Order of Operations Use Absolute Cell References Create 3D formulas Link workbooks 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)...

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...

CHART BASICS Create Column Charts Create Bar Charts Create Line Charts Create Area Charts Create Pie Charts Create Doughnut Charts  EDIT CHARTS: Select / Edit Data Range Apply Chart Styles Change Chart Colors Apply Quick Layouts Add / Remove Charts Elements Change Chart Type Move Charts Copy and Paste Charts into Word and PowerPoint Link...

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...

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. ...

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....

Use Pivot Tables to summarize large spreadsheets. Create a Pivot Table Layout & Design Move a PivotTable Filter a Pivot Table Sort a Pivot Table Expand & Collapse Columns Grand Totals and Subtotals Functions (Sum, Average, Min, Max) Change Data Source (change range of cells, use Access as data source, etc.) Append (Add) Data to a...