Mon, Jul 22
9:00am - 4:00pm
2 classes have spots left
Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Course Outline Unit 1: Using multiple worksheets and workbooks Topic A: Using multiple workbooks Topic B: Linking worksheets with 3-D formulas Topic C: Linking workbooks Topic D: Managing workbooks Unit 2: Advanced formatting ...
Monday Jul 22nd, 9am - 4pm
Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...
Tuesday Jul 23rd, 9am - 4pm
Google Analytics is a suite that is integrated with Google’s data to help draw conclusions about the effectiveness of your site content, promotions and advertising campaigns. This class will go over how to implement Google Analytics, how to manage your accounts, perform reports and in-depth analysis with specific reports.
Saturday Jul 20th, 9am - 4pm
According to the wisdom of Kabbalah, Shabbat is the most powerful day of the week – a time when the spiritual and physical worlds are united. On Shabbat, we have the opportunity to transform our reality using specific prayers and food to connect to the available cosmic energy. On Shabbat Pinchas, we find tremendous codes and conduits for tapping...
Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields,and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
Tuesday Jul 16th, 9am - 4pm
Students will learn to create, save, and rearrange presentations. Then they will format text, use drawing objects, work with graphics, and insert tables and charts. They will then learn to use templates and themes, slide masters, and transition effects. Finally, students will learn to proof, and run presentations.
Thursday Jul 25th, 9am - 4pm
The focus of this class is the design of an Access database. You will learn how to create tables and basic forms, basic queries, and basic reports. We will cover planning a database, finding records, editing data, and using sorting and filters. Input masks and validation will be covered to help get correct information into your database.
Monday Jul 15th, 9am - 4pm
Learn to navigate documents, enter and edit text, create and save documents, formatting, create tables, insert headers and footers, insert graphics, and more. Course Content Lesson 1: Getting Started with Word Topic A: Navigate in Microsoft Word Topic B: Create and Save Word Documents Topic C: Manage Your Workspace Topic D: Edit Documents Topic...
Monday Jul 15th, 9am - 4pm
In this class, students will learn how to use Microsoft Windows efficiently. The majority of computers today use Microsoft Windows. Therefore, a solid understanding of Windows is necessary before learning other programs. In our Introduction to Windows class we will resize windows, navigate the desktop and use online help. We will customize Windows,...
Monday Jul 15th, 9am - 4pm
Students will customize PowerPoint by modifying the Ribbon and changing application settings. They will also apply themes and templates, and they will work with SmartArt graphics, tables, and charts. Students will add multimedia content and interactive elements to slides. Finally, students will integrate PowerPoint with Word and Excel.
Friday Jul 26th, 9am - 4pm
Learn to move and copy data, do formulas, insert rows and columns, create basic charts, & more! Course Outline: Unit 1: Getting started Topic A: Spreadsheet terminology Topic B: The Excel environment Topic C: Getting help Topic D: Navigating a worksheet Unit 2: Entering and editing data Topic A: Entering and editing text and values Topic...
Thursday Jun 27th, 9am - 4pm
This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Target Student: You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might...
Google AdWords allows individuals and organizations to advertise on the Internet. In this course, students will learn how to create and navigate a Google AdWords account, create and manage ad campaigns, work with keywords, write ads, manage bidding and budgets, launch and manage ads and be able to create financial and performance reports. About Our...
Google AdWords allows individuals and organizations to advertise on the Internet. In this course, students will learn how to create and navigate a Google AdWords account, create and manage ad campaigns, work with keywords, write ads, manage bidding and budgets, launch and manage ads and will also be able to create financial and performance reports...
Learn CSS 3 layout techniques, including the syntax and structure and how to control multi-column, flexible box, grid and regions layout. Explore relative and absolute positioning, floated layout, block and inline display, and table layout techniques. Learn how to speed up workflow by using CSS libraries and frameworks.
Saturday Jun 22nd, 9am - 4pm