You're browsing Tech Classes in San Diego, CA

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 Google Sheets in a long time.  Learn how to navigate the Google Sheets user interface. Learn many keyboard shortcuts that will speed up common tasks. Create, Open, Close,...

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

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

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

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

ESTIMATES & INVOICESCreate estimates. Base invoices on information in an estimate. Add Reimbursable Expenses to invoices and mark-up the amounts to make a profit.TIME TRACKINGUse Timesheets to track time for different projects and use Timesheet data for invoicing, in payroll, and reports.CLASSESUse "Classes" to track and compare different parts...

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

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

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

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

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

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

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