Unfortunately, no classes have spots left
Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...
ONLC Training Centers @ 7700 Irvine Center Dr, Los Angeles, CA
Although this class will be taught using Microsoft Excel 2013 and ONLC's "Excel 2013 Intermediate" manual, this class is relevant for individuals using either the 2010 or 2013 versions of the software. The instructor will note where there are differences in features and functions between the two versions. For the most part, those differences will be minor related to the topics taught in this class. Prerequisites Excel 2013 Introduction or equivalent...
This course offers students the opportunity to take an existing ASP.NET MVC application and expand its functionality as part of moving it to Azure. This course focuses on developing in Azure using Storage, Cloud Services, Service Bus, Active Directory, WebSites and SQL among other features. This course also focuses on using the provided .NET SDKs, REST APIs, configuration and deployment options related to Azure. Audience Profile The developers targeted...
Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™
ONLC Training Centers @ 11400 W Olympic Blvd, Los Angeles, CA
This course is designed for students who wish to learn the basic operations of the Microsoft Word to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to advance to using more complex Word features such as protecting your documents and usage of ligatures. Prerequisites To be successful in this course, you should be familiar...
This three-day instructor-led course is intended for IT professionals who are interested in expanding their knowledge base and technical skills about Windows 7 Client. In this course, students learn how to install, upgrade, and migrate to Windows 7 client. Students then configure Windows 7 client for network connectivity, security, maintenance, and mobile computing. Audience Profile This course is intended for IT professionals who are interested...
You will create, format, edit, and distribute publications. Target Student This course is intended for persons with a basic understanding of Microsoft Windows and Microsoft Word who need to learn how to use Microsoft® Publisher 2010 to create, layout, and edit publications. Prerequisites Students should be familiar with using personal computers and have used a mouse and keyboard (basic typing skills are recommended). They should be comfortable...
ONLC Training Centers @ 7700 Irvine Center Dr, Los Angeles, CA
Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2008 enhances report building and report processing techniques with a slew of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation. Course Objective You will connect to a database to extract data and present it as a report. Target Student This...
This is a 5-day Instructor Led Training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and users....
ONLC Training Centers @ 7700 Irvine Center Dr, Los Angeles, CA
Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports' tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries....
ONLC Training Centers @ 1500 Rosecrans Ave, Los Angeles, CA
Although this class will be taught using Microsoft Excel 2013 and ONLC's "Excel 2013 Advanced" manual, this class is relevant for individuals using either the 2010 or 2013 versions of the software. The instructor will note where there are differences in features and functions between the two versions. For the most part, those differences will be minor related to the topics taught in this class. Prerequisites Excel 2013 Intermediate or equivalent...
In this Python training course, students already familiar with Python programming will learn advanced Python techniques. This advanced Python course is taught using Python 3; however, differences between Python 2 and Python 3 are noted. Goals Learn to work with the Collections module. Learn about mapping and filtering and lambda functions. Learn advanced sorting. Learn to work with regular expressions in Python. Learn to work with databases,...
The one-day Microsoft Dynamics GP Payables Management course examines the accounting cycle and the processes required to enter vendor invoices and process checks. This course also shows you how to perform additional functions such as adjustments, prepayments, month-end closing, and cash flow control. A thorough understanding of these topics allows for capitalizing on vendor discount dates to reduce accounts payable liabilities and easily select...
Intensive and hands-on, the course emphasizes becoming productive quickly as a Java™ application developer. This course quickly covers the Java language syntax and then moves into the object-oriented features of the language. Students will then learn the I/O streams and collections API packages. This course is current to Java 7 and uses the Eclipse IDE. Audience Programmers moving to object-oriented programming using Java. Prerequisites...
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Perl has evolved from its beginnings as an eclectic scripting tool for UNIX administrators into one of the most popular, influential, and widely used computer languages in history. In this course, you will learn how to fully utilize the Perl programming language. Audience Application programmers, system administrators, web-site authors, webmasters, and UNIX/NT power users. Prerequisites Perl Programming and Perl application development experience....
The Certified Penetration Testing Engineer course trains students on the 5 key elements of penetration testing: information gathering scanning enumeration exploitation reporting Ethical hacking is the art of using these penetration testing techniques to identify and repair the latest vulnerabilities in a system to make sure it is secure. Malicious hackers use these same techniques to find the same vulnerabilities except they exploit...
You will create and manage a project schedule using Microsoft Project 2010. You will exchange project plan data with other applications, update project plans, create visual reports, and reuse project plan information. Target Student This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans. Prerequisites...
Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management...
Overview Get Power BI Desktop Getting started with Power BI Desktop Connect to Data Data Sources in Power BI Desktop Connect to web data Import Excel Workbooks Analysis Services Tabular Data Shape and Combine Data Query overview Shape and combine data Data categorization Relationship view Create and manage relationships in Power BI Desktop Common query tasks Data Fundamentals Data Type in Power BI Desktop Measures in Power BI...
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Learn how to generate complex and customized reports using Crystal Reports in this advanced course. Discover how to create subreports, cross-tabs, and running totals, as well as utilize SQL queries for faster and more efficient reporting. Enhance your data visualization skills by adding charts to your reports.
ONLC Training Centers @ 7700 Irvine Center Dr, Los Angeles, CA
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by...
Try removing some filters.
Discover
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.