Wise Owl courses

...Creating a mask Styles Using styles to apply formatting Number format styles Formatting numbers and dates Standard number formats Hiding cell contents... Learn about: Data tables, Advanced Lookup Functions, Cashflow calculations...

...Creating queries Comments Indentation and case Setting criteria using WHERE Wildcards (% and _) Setting criteria for dates Coping with nulls Outputting to Excel Results... Learn about: Creating databases - overview, More exotic joins, Simple Queries...

...Using object variables Looping over collections Links to other applications Referencing other applications Instantiating objects Writing inter-application... Learn about: Passing arguments, Working with text files, Class modules...

...Microsoft Excel VBA macros are fun - let us show you why! Suitable for: This Excel VBA macros course is aimed at people who have a good existing working... Learn about: Automating Excel, Referencing other applications, Messages & variables...

...Page headers and footers Pagination between groups Header and footer expressions Parameters Using query parameters Creating drop lists Multi-value... Learn about: Reporting Services, Simple Reports, Data source...

...update and delete triggers Using the generated tables (eg INSERTED) Using INSTEAD... Learn about: Parameters and return variables, Stored procedures, Derived tables and CTEs...

...Excel can do so much more than simple pivot tables! This two-day course will show you how to: create simple, elegant data models in PowerPivot... Learn about: Getting data (Power Query), PowerPivot data models, Using other data sources...

...and adding fancy devices like indicators and gauges! There is no difference that we know of between Report Builder 3.0 and Report Builder for SQL Server... Learn about: Page setup, The SSRS web portal, Graphical Indicators...

...Visual Studio Creating a project Creating a data source Data Source Views Keys and relationships Exploring data Named queries Named calculations Dimensions... Learn about: Cube actions, Multi-dimensional models, Star and snowflake schemas...

...the loop Expression constraints Importing multiple files Using expressions for connections Dynamic connections within loops If time Looping over rows Object... Learn about: Data viewers, Handling Errors, Lookup transforms...

...Creating relationships Excel pivot tables Analysing data in Excel Connecting from Excel Using Excel pivot tables If time Power BI Desktop overview Importing... Learn about: Connecting to SQL Server, Prototyping using PowerPivot, Creating a data model...

...visualisations KPIs Query editor Filtering rows Manipulating columns Working with data types More on query editor Creating new columns Introducing... Learn about: Publishing reports, Power BI Service Overview, Data sources...

...titles If time Parent-child hierarchies The PATH functions Displaying different levels Making the results neater DAX queries Evaulating data Summarising... Learn about: Understanding EARLIER, Basic measures, Ways to edit DAX...

...Using SQL Server Using Object Explorer Hiding system objects Creating databases - overview Designing databases Primary keys Indexing fields Working... Learn about: Database training, SQL Database...

...feature Drill-through filtering Adding drillthrough filters Back buttons Action buttons Assigning actions to shapes Inserting buttons Hover and select... Learn about: Power BI Desktop overview, Creating databases - overview, Power BI Service Overview...

...(if time) • The try clause • Handling exceptions Working with data types (if time) • Manipulating strings • Numbers and Booleans • The DATETIME module... Learn about: Data sources, Debugging and error handling, Visual Studio basics...

...Changing the aggregation function Drilling down Filtering and sorting Advanced pivot tables Grouping fields Showing % of grand totals, etc Slicers... Learn about: Advanced pivot tables, Text Functions, Pivot tables...

...other applications Manipulating Excel from Access If time Modifying queries Basic SQL statements Amending queries'... Learn about: The VBA code editor, Creating functions, Visual Basic explained...

...applications and how to design and create your own. The course will also cover user controls. This course will use Visual Studio as its editing...

...Windows Presentation Foundation is the new technology for designing forms-based applications from Microsoft. It offers prettier screens, better data-binding... Learn about: Data sources...