-
All
-
Online
-
Filters
Wise Owl courses
- Course
- Online
- Advanced
- Different dates available
- 12h - 2 Days
...Creating what-if scenarios The scenario manager If time Goal-seeking Targeting a given value Setting the number of iterations Data tables One-way... Learn about: Cashflow calculations, Multiple Worksheets, Array formulae...
- Course
- Londonandanother venue.
- Manchester
- Beginner
- Different dates available
- 2 Days
...outer joins More exotic joins Cross joins Full outer joins Self joins Aggregation and grouping SUM, AVG, MIN, MAX Various ways to count Grouping by fields... Learn about: Simple Queries, Using SQL Server, Setting criteria using WHERE...
- Course
- Online
- Advanced
- Different dates available
- 12h - 2 Days
...code Working with files Using FileSystemObjects Working with files and folders Using FileDialogs Protecting applications Trapping keys in Excel and... Learn about: Working with text files, Passing arguments, Linking to data...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...Not only our best-selling course, but also one of our favourites. This two-day course takes you through , all the way from recording Excel VBA macros through... Learn about: Visual Basic, Messages & variables, Event Handling...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...data Linking to datasets Map layers Center points and point layers Deploying reports Setting the target server Deploying an entire project Deploying single... Learn about: Data source, Simple Reports, Reporting Services...
- Course
- Londonandanother venue.
- Manchester
- Advanced
- Different dates available
- 2 Days
...error functions Custom error messages Deleting using SQL Ways to drop tables DELETE versus TRUNCATE Updating data in SQL The UPDATE statement Updating... Learn about: Table-valued functions, Creating Tables, Inserting Data...
- Course
- Online
- Beginner
- Different dates available
- 2 Days
...Calendars Creating in Excel or SQL Linking to calendars Sorting months Multiple date tables Date functions Period to date Fiscal year calculations Parallel... Learn about: Date Functions, The CALCULATE function, Power BI Desktop overview...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...Floating headers Grouping Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions The expression builder... Learn about: Exporting reports, Page setup, Graphical Indicators...
- Course
- Londonandanother venue.
- Manchester
- Intermediate
- Different dates available
- 2 Days
...Visual Studio Creating a project Creating a data source Data Source Views Keys and relationships Exploring data Named queries Named calculations Dimensions... Learn about: Hierarchies and Relationships, Star and snowflake schemas, Time dimensions...
- Training
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...variables Reading in data Looping over ADO rows Dynamic connection strings Using parameter placeholders Using the ? Symbol Mapping parameters Merge joins... Learn about: Data conversion transforms, Conditional split transforms, Basic data transforms...
- Course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...PowerPivot Using PowerPivot Importing PowerPivot models into SSAS Constraints Accessing DAX queries From within Excel From Reporting Services Calendars... Learn about: Accessing DAX queries, Calculated columns, Visual Studio basics...
- Training
- Londonandanother venue.
- Manchester
- Beginner
- Different dates available
- 2 Days
...visualisations KPIs Query editor Filtering rows Manipulating columns Working with data types More on query editor Creating new columns Introducing... Learn about: Using Power BI Service, Power BI Service Overview, Query editor...
- Training
- Londonandanother venue.
- Manchester
- Intermediate
- Different dates available
- 2 Days
...titles If time Parent-child hierarchies The PATH functions Displaying different levels Making the results neater DAX queries Evaulating data Summarising... Learn about: Dynamic measures, The FILTER function, Basic measures...
- Short course
- Online
- Beginner
- 12h - 2 Days
...use SQL Server 2008 if you prefer; the differences are small). Suitable for: This Writing SQL course is aimed primarily at businesses and public sector organisations... Learn about: SQL Database, Database training...
- Short course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...reports Power BI accounts Power BI files (PBIX) Power BI Service Overview Differences from PBI Desktop Workspaces Favorites Using Power BI Service Reports... Learn about: Power BI Service Overview, Working with tables, Power BI Desktop overview...
- Short course
- Online
- Beginner
- Different dates available
- 12h - 2 Days
...of loops • Ranges of numbers Working with modules • Installing modules using PIP • System modules (OS and SYS) • Maths functions (MATH) Sequences • Tuples... Learn about: Visual Studio basics, Debugging and error handling, Error Handling...
- Course
- Manchester
- Advanced
- Different dates available
- 2 Days
...Advanced lookup functions Using = MATCH to find values Combining =INDEX and =MATCH The OFFSET function The INDIRECT function Text functions Basic... Learn about: Advanced pivot tables, Pivot tables, Advanced tables...
- Short course
- Inhouse
- Intermediate
- Different dates available
- 2 Days
...If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn. This two-day course shows you how to use Access VBA to automate your databases... Learn about: Debuggin and error handling, Creating functions, Linking to Excel & Word...
- Course
- Manchester
- Advanced
- 3 Days
...This three-day course assumes that you know the basics of ASP.NET, and aims to turn you into a serious developer. The course will show how to create 3-tier...
- Course
- Manchester
- Intermediate
- 3 Days
...and link to a SQL Server database WPF basics Using Visual Studio WPF and WinForms compared Basic windows Understanding XAML Basic WPF controls Changing... Learn about: Data sources...
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you