Industry Specific

Excel 2013: Macros

0

Discover how to automate tasks in Excel. Learn how to record, share, and edit macros.Want to save time on routine tasks in Microsoft Excel? Macros are your answer. In this course, author Dennis Taylor explains how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.IntroductionWelcomeUsing the exercise files1. Getting Started with MacrosIdentifying applicable situations for using macrosRecognizing the need for single-action macrosUnderstanding securityShort examples of the recording methodOverview of other techniques2. Running a MacroRunning a macro from the Developer tab or the View tabRunning a macro from the Quick Access Toolbar buttonRunning a macro from a keystroke shortcutRunning a macro from an object or clip art3. Using Visual Basic for Applications (VBA)The VBA environment and VBA componentsCreating the Personal Macro WorkbookClosing and updating the Personal Macro Workbook4. Recording a Macro in StagesRecording a simple macroExpanding a macro with the if statement5. Creating Nonrecordable VBA CodeUnderstanding when to use absolute or relative referencesUsing For and For Next statementsUsing Do While and Do Until statementsCreating interactive macros6. Macro Project: Converting a Mailing List into a Database ListPlanning a macroRecording partial codeUsing loop structures in contextTesting a macro in Step modePulling the data togetherJoining two macrosStreamlining macrosConclusionNext steps

Cinema 4D: Dynamics

0

Learn how to use CINEMA 4D dynamics to create physically accurate object animations, using real-world physics like gravity, collisions, and bounces.CINEMA 4D dynamics are powerful, but easy to understand and fun to play with. In this course, Thanassis Pozantzis shows you how to use dynamics to create physically accurate object animations, using real-world physics like gravity, collisions, and bounces. Learn how to work with forces like initial velocity, create more complex objects like hierarchies and static objects, and use dynamics with MoGraph clones and particle systems. You'll also get a look at eight of the major physical properties, learn how to connect your simulation to keyframe-animated objects, and trigger dynamics. After the completion of this course, you should be able to create complex dynamic simulations setups. The possibilities are limited only by your imagination.This course was created by Thanassis Pozantzis. We're honored to host this training in our library.

Sculpting a Game Asset in Blender

0

Learn how to use Blender's Multiresolution modifier and sculpting tools to create high-poly texture maps for 3D game assets.Blender's sculpting tools are great for modeling, but they also can be used to create fine-detail textures for your 3D models, whether for animations or games. In this course, Darrin Lile demonstrates how to use Blender's Multiresolution modifier and sculpting tools to create texture maps that simulate high-poly sculpt information. He reviews the process of baking these textures out to normal and ambient occlusion texture maps, and then shows how to apply them to your 3D game assets in Unity.

Excel Data Visualization: Designing Custom Visualizations

0

Go beyond the built-in chart and graph tools in Excel. Learn how to create custom data visualizations, including how to build dynamic dashboards and gauge charts.Interested in using more than the built-in chart and graph tools to showcase your data in Excel? In this course—the second and final installment in the Excel Data Visualization series—instructor Chris Dutton steps through how to create unique, custom data visualizations in Excel. Since Chris covered the core data visualization capabilities of Excel in the previous installment of the series, he dives into some more sophisticated techniques here. As he moves through a series of hands-on demos, Chris covers everything from building dynamic dashboards to advanced maneuvers like value-based formatting and dynamic series selection.

Oracle Database 19c: Basic SQL

0

Learn the basics of how to code using SQL in an Oracle 19c Database environment. Learn how to get data in and out of tables, modify data, delete data, and more.Mastering SQL is an essential skill for any Oracle professional and the first step in becoming a true Oracle expert. In this course, Bob Bryla covers the basics required to code using SQL in an Oracle 19c Database environment. Bob covers what you need to know to get data in and out of your database tables, as well as how to modify data. He explains how to leverage SELECT statements, filter and sort rows, use both single- and multiple-row functions, and join tables. He delves into the Oracle data dictionary—a set of tables that provide information about a database—and shows how to query it. Plus, he demonstrates how to efficiently delete data using DML statements. Upon wrapping up this course, you'll have the fundamental skills you need to work with SQL in this popular relational database management system.

SQL Essential Training

0

Learn how to use SQL to manage your database. Explore beginner-level tutorials on creating tables, defining relationships, and manipulating strings with SQL and SQLiteStudio.Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.This course was created by Bill Weinman. We are pleased to offer this training in our library.

Animating Cartoon Characters in Maya

0

Teaches simple steps to creating exaggerated cartoon animation in Maya, using principles such as squash and stretch, exaggeration, follow-through, and overlapping action.Now that you've rigged your characters, it's time to make them move. Starting from where Modeling a Cartoon Character in Maya left off, George Maestri teaches five simple steps to creating exaggerated cartoon animation in Maya. Using the rig developed in the previous course, he shows how to animate a walk, create a jump, animate changes in facial expression and posture, animate a "zip out" or quick exit, and then show how to finalize and render the complete project. Throughout the course, George touches on animation principles such as squash and stretch, exaggeration, follow-through, and overlapping action.

Educational Administration, Management and leadership in School Education

4.5

Educational administration is a process that includes the combined operation through which a country is maintained in good working conditions. It is a process of utilizing appropriate material in such a way as to promote effectively the development of human qualities. It includes all those techniques and procedures employed in operating the educational organization in accordance with established policies. Here the totality of resources are made available and made effective for accomplishing the purpose of an enterprise. Educational administration includes functions like planning, organizing, financing, directing, supervising, inspecting and evaluation. It is also concerned with elements like setting up of goals of education, review, feedback and innovation.Management in businesses and organizations is the function that coordinates the efforts of people to accomplish goals and objectives by using available resources efficiently and effectively. Management includes planning, organizing, staffing, leading or directing, and controlling an organization to accomplish the goal or target. Resourcing encompasses the deployment and manipulation of human resources, financial resources, technological resources, and natural resources.Leadership is both a research area and a practical skill encompassing the ability of an individual or organization to "lead" or guide other individuals, teams, or entire organizations.The course- Perspectives, issues and research in teacher education is a 60 hour 4 credit course having 36 modules. The time distribution will be as follows:Self Study through Video & Text - 35 hoursParticipation in discussion forum - 05 hoursWeb Search/ Library Search - 10 hoursAssessment/Assignment - 10 hours

Oracle Database 12c: Backup and Recovery

0

Learn how to design and implement backup and recovery strategies that keep the data stored in your Oracle 12c databases safe and secure.Keeping the information in an Oracle database safe from failure is one of the most important tasks of a successful Oracle DBA. In this course, Oracle instructor and consultant David Yahalom covers the theoretical concepts as well as the practical knowledge required to design and implement bulletproof Oracle backup and recovery strategies. Learn how human errors, hardware failures, and even storage loss can affect your database, and how you can leverage the technologies and features built into Oracle 12c to ensure you will never suffer any data loss. Discover how to use various Oracle tools and technologies, including RMAN, Data Pump, Flashback, and hot and cold backups, to protect your database from the inevitable crash.

Financial Analysis: Analyzing the Bottom Line with Excel

0

Learn how to analyze the bottom line (or profitability) of your company, by analyzing your gross margin and operating expenses with Excel.Learn how to analyze the bottom line (or profitability) of your company and identify areas of under- or overperformance with Excel. Rudolph Rosenberg, author of the Financial Analysis series, shows how to use the data your company generates every day to break down your gross margin and operating expenses. He introduces the tools and techniques you can use in Excel to prepare and analyze that data, including PivotTables and the invaluable SUMIF function. Plus, you'll learn to identify and analyze sales and marketing spending, staff expenditures, and productivity separately, so you can get a really clear picture of your data from multiple angles.Also check out the companion course, Financial Analysis: Analyzing the Top Line with Excel.

Excel Business Intelligence: Power Pivot and DAX

0

Learn how to use Power Pivot and the DAX language to explore and analyze relational data models in Excel.Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course—the third and final installment of the Excel Business Intelligence series—experienced Excel trainer Chris Dutton spells out how to use the DAX language and Power Pivot to explore and analyze relational data models. Chris picks up where he left off in the previous installment of the series, demonstrating how to add calculated columns and measures to data models in Excel. He highlights the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Premiere Pro Guru: Professional Trimming

0

Learn to trim on the timeline, perform various kinds of trim edits, trim audio, and incorporate keyboard shortcuts that make the work go faster.Trimming is at the very heart of editing. The fine adjustments that you make to your edits for timing and precision make a huge if subtle difference to the final product. This course is a deep dive into all of the tools used to make trim edits and the different ways to utilize them. Professional editor and documentary filmmaker Jason Osder teaches members how to trim on the timeline, perform various kinds of trim edits, trim audio, and incorporate keyboard shortcuts that make the work go faster.

Maya 2018: Bifröst Fluids

0

Render realistic animated liquids in Maya with the Bifröst fluid dynamics engine and the Arnold renderer.Bifröst for Maya 2018 includes many welcome updates to the liquid simulation plugin, Bifröst Fluids. With Maya 2018.1, Arnold supports exciting new ways to render fluids in better fidelity without heavy mesh caches. This course takes an overview of simulating liquids in Bifröst and rendering in Arnold. For convincing materials, instructor Aaron F. Ross shows how to extract fluid dynamics data such as vorticity and apply it in an Arnold shading network. To finish the exploration of fluids, he takes a look at Bifröst foam, which generates secondary particles from the main fluid.

Premiere Pro Guru: Optimizing Titles

0

Create and optimize titles and graphics using Premiere Pro and other tools from Adobe Creative Cloud: After Effects, Photoshop, Illustrator, and InDesign.All video editors use titles in their work: intro and ending titles, lower thirds, scrolling titles, and many other types of infographics. In this course, Luisa Winters takes you through creating and optimizing titles and graphics using Premiere Pro, After Effects, Photoshop, Illustrator, and InDesign. Learn to use the tools that you already have in the Creative Cloud to achieve the greatest impact with your titles and create reusable templates and title styles that maximize your editing efficiency.

Educational Technology

0

This course is about learning the concept of educational technology. What comes to our mind when you hear the term educational technology? Maybe computer, digital tools, internet, mobile phones, smart boards, electric gadgets, etc.?? Is educational technology only about these tools and gadgets? Definitely not. It is not restricted to these tools only but encompasses everything that enhances teaching and learning. It helps in improving teaching learning process and reaching the pre-set goals of education through systematic organization of learning procedures and processes. For new generation learners, it is required to have a sound knowledge of educational technology and its effect on teaching-learning process. In this course, we will be studying about Introduction of Educational Technology, Classroom Communication and Teaching Aids, Instructional Techniques and Phases, levels and Models of Teaching and Understand the concept, approaches and significance of educational technology and explain the role of communication in the field of education.