Online Assistant - Technician Training & eLearning Courses

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code....

Events

Duration

1 Day

Price

655.00

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation....

Events

Duration

2 Days

Price

1190.00

As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of ""big data"" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action....

Events

Duration

3 Days

Price

1895.00

In this course, students will create a basic report by connecting to a database and modifying the report's presentation....

Events

Duration

2 Days

Price

990.00

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

Events

Duration

2 Days

Price

1190.00