3187 Courses

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Welcome to a hands-on SQL course. In this course, you will learn the fundamentals of SQL databases and the relational model. We will cover core concepts such as inserting data into SQL databases, extracting data from SQL databases, aggregations, subqueries, joins, unions, and window functions. This course will help you write complex queries to perform tasks as required in technical interviews or on the job.

Define multimode system terminology Describe goals and applications of multimode systems Detail basic component layouts of multimode systems Define microgrid systems and diagram component layouts for microgrid applications List applications for multimode systems Distinguish between back-up and self-consumption use cases Examine daily and annual data to perform a load analysis Review battery bank sizing Identify PV array sizing methods and variables for multimode systems Calculate minimum PV array size to meet load requirements Calculate what percentage of overall annual consumption will be offset by selected PV array size Analyze data required to specify a multimode inverter Differentiate between sizing considerations for internal and external AC connections Describe various configurations for stacking and clustering multiple inverters Describe when and why advanced inverter functions are used Discuss the equipment and designs needed for advanced multimode functions Analyze each advanced multimode function List data needed to perform an accurate financial analysis of systems that use advanced multimode functions Describe factors that can affect the financial analysis of systems using advanced multimode functions Describe the National Electrical Code (NEC®) Articles that apply to the different parts of PV and energy storage systems (ESS) Identify specific requirements for ESS and systems interconnected with a primary power source List relevant building & fire codes Communicate specific requirements for workspace clearances, disconnects, & OCPD Describe PV system requirements that affect ESS installation List ESS labeling requirements Review DC coupled systems, including advantages and disadvantages Discuss MPPT charge controller operations and options Review charge controller sizing for grid-tied systems Design a DC coupled multimode PV system for a residential application Define operating modes of an AC coupled PV system while grid-connected or in island mode Explain charge regulation methods of grid-direct inverter output Review AC coupled PV system design strategies Evaluate equipment options for AC coupled multimode applications Design an AC coupled multimode PV system for a residential application Define Energy Storage System (ESS) Describe criteria for evaluating energy storage system configurations and applications Design ESS system for back-up power Describe large-scale energy storage system applications and functions; review use case examples Analyze equipment configuration options for large-scale AC and DC coupled systems Formulate questions to enable design optimization of large-scale energy storage systems Note: SEI recommends working closely with a qualified person and/or taking PV 202 for more information on conductor sizing, electrical panel specification, and grounding systems. These topics will be part of this course, but they are not the focus.

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Master Power BI’s most powerful functions on this 2 day Advanced Power BI training course.  This is a hands-on course. You get lots of time to practise creating and editing reports and data visualisations. This ensures that you really get to grips with what you are being taught. By the time you finish, you’ll be an expert Power BI user.  ✔ A course covering all of Power BI’s most advanced functions.  ✔ Plenty of one-to-one attention and time to ask questions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ All the materials and extras that you’ll ever need.  ✔ Ongoing support and help with issues you have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

OVERVIEW Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models. During this course you will review: Writing DAX formulas. Defining calculated tables and columns. Defining measures. Using DAX iterator functions. Modifying filter context. Using DAX time intelligence functions. After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns. COURSE BENEFITS: Understand Analytic queries in Power BI Create calculated tables, calculated columns and measures Use DAX functions and operators to build DAX formulas Use DAX iterator functions Create formulas that manipulate the filter context Use DAX time intelligence functions WHO IS THE COURSE FOR? Analysts with experience of Power BI wishing to develop more advanced formulas in DAX Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable LAB OUTLINE Lab 1 Setup Connect to data and understand the objectives of the future labs Lab 2 Write DAX Formulas For Power BI Create a measure Use variables in the measure definition Lab 3 Add Calculated Table And Columns Duplicate a table Create a hierarchy Create a date table Add calculated columns Lab 4 Add Measures To Power BI Desktop Models Add an implicit measure to a report Add an explicit measure Add a compound measure Add a quick measure Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model Complex summarization Higher grain summarization Create ranking measure Lab 6 Modify DAX Filter Context In Power BI Desktop Models Apply Boolean expression filter Remove filters: use ALL Remove filters: use AllSelected Preserve filters: use KeepFilters HASONEVALUE ISINSCOPE Context transition Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models TOTALYTD SAMEPERIODLASTYEAR Calculate new occurrences Snapshot calculations

SDH training course description Our SDH training course is designed for those with a basic knowledge of the principles of telecommunication digital transmission techniques. An overview of the existing transmission hierarchies and their limitations is provided with an introduction to the Synchronous Digital Hierarchy (SDH). The advantages of SDH are explained fully. What will you learn Identify the major limitations of the PDH network. Outline the advantages of using the SDH. Illustrate the various SDH equipment and network topologies. Describe the principles of the SDH multiplexing structure. SDH training course details Who will benefit: Anyone working with SDH. Prerequisites: It should be noted that this course will assume some basic telecommunication transmission knowledge from the delegates attending. This may be accomplished by attending the Introduction to Telecommunications course. Duration 2 days SDH training course contents Introduction to SDH Timing and synchronisation of digital signals, the plesiochronous digital hierarchy (PDH), the synchronous digital hierarchy (SDH), service protection with SDH SDH Multiplexing Techniques The multiplexing principles of SDH, mapping and aligning a 2Mbit/s tributary into a TU-12, aligning the VC-12 in a TU-12, multiplexing TU-12's into a TUG-2, multiplexing TUG-2's into a TUG-3, multiplexing TUG-3's into a VC-4, the VC-4 path overhead, the STM-1 frame, the AU-4 pointer, the STM-1 section overheads, multiplexer section protection, transmission at rates higher than STM-1, concatenation line transmission functions in SDH SONET Multiplexing Techniques Mapping a DS1 tributary into a virtual tributary, aligning the VT-SPE into a VT frame, mapping the VTGs into a STS-1 SPE, the STS-1 synchronous payload envelope, the STS-1 frame SONET network sections and lines transmissions at higher rates than STS-1 SDH Functions and Facilities SDH network topologies, structure of SDH equipment, synchronisation of SDH networks, protection switching in SDH networks, SDH alarm structure, SDH performance monitoring, testing of SDH, equipment and systems, network management and SDH, asynchronous transfer mode (ATM), future services and technologies OSI Telecommunications Network Management Definition of network management, managing telecom equipment, the managed object library, the management information base, the telecommunications management network (TMN), the Q3 protocol.

Overview In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models. Objectives Harness Excel's tools within a best practice framework Add flexibility to their models through the use of switches and flexible lookups Work efficiently with large data volumes Model debt effectively Approach modelling for tax, debt, pensions and disposals with confidence Build flexible charts and sensitivity analysis to aid the presentation of results Learn and apply Excel tools useful in financial forecasting Understand and design the layout of a flexible model Forecast financial statements of a public or private company Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation