Tableau: Data Driven Insights Bootcamp

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

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

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

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

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

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

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

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

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

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