Wise Owl courses

...on for a worksheet Protecting the whole workbook Grouping/outlining Creating and removing groups Expanding and collapsing Multiple worksheets Group editing... Learn about: Cashflow calculations, Array formulae, Multiple Worksheets...

...slightly between different database providers; this course teaches the T-SQL or Transact-SQL language using SQL Server 2005 (although you can elect... Learn about: Basic joins, Calculations using dates, Working with tables...

...Trapping keys in Access Disabling bypass keys Security How macro security works Creating security certificates Digitally signing macros Class modules What is a class?... Learn about: Working with text files, Links to other applications, Passing arguments...

...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, Debugging and error handling, Referencing other applications...

...of a chart Creating charts Formatting charts Data bars and sparklines Need for a grouped row Creating data bars Creating sparklines Lists Creating... Learn about: Data source, Data sets, Simple Reports...

...Mult-statement table-valued functions Derived tables and CTEs Using derived tables Common Table Expressions (CTEs) Multiple CTEs in a single query If... Learn about: Testing conditions, Updating data in SQL, Error Handling...

...fields AutoSum fields Creating in Excel and PowerPivot DAX basics The DAX Studio add-in Calculating ratios Aggregate X functions The CALCULATE function... Learn about: The CALCULATE function, Getting data (Power Query), PowerPivot data models...

...child report Creating the main report Linking the two reports If time Drill-through reports Parent and child reports Creating actions Passing values... Learn about: Basic reports, Data sources and datasets, Page setup...

...The dimension wizard Attribute hierarchies Deploying dimensions Publishing dimensions and cubes Deploying Processing Handling deployment errors Basic Cubes... Learn about: Basic Cubes, Multi-dimensional models, Data Source Views...

...Data flow tasks Connection managers Sources and destinations Using different data connections SQL Server (OLEDB) Connecting to Excel workbooks New... Learn about: Conditional split transforms, Derived column transforms, Data conversion transforms...

...Creating a hierarchy Viewing hierarchies KPIs The parts of a KPI Absolute and relative measures Creating and viewing KPIs Perspectives Creating perspectives... Learn about: Connecting to SQL Server, Changing query context, Excel pivot tables...

...feature Drill-through filtering Adding drillthrough filters Back buttons Action buttons Assigning actions to shapes Inserting buttons Hover and select... Learn about: Drill-through filtering, Action buttons, Dashboard visualisations...

...Date-based functions Advanced date functions Multiple relationships Moving averages Dynamic measures The ISFILTERED function The ALLSELECTED FUNCTION Dynamic... Learn about: Understanding EARLIER, Calendars and dates, Calculated columns...

...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: Database training, SQL Database...

...effects Bookmarks Creating bookmarks Filtering using bookmarks Spotlighting and hiding visuals Overview of maps The types of map Geo-location Introduction... Learn about: Working with tables, 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, Error Handling, Debugging and error handling...

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

...Trapping for errors Case studies Navigation buttons Creating a simple menu Validating forms Criteria forms If time Linking to Excel and Word Referencing... Learn about: The VBA code editor, Messages & variables, Case Studies...

...3-tier applications Creating a data layer Methods to change data Using data classes User controls Creating and referencing Exposing methods/properties...

...control properties Running applications Handling events Coding buttons and controls Displaying messages The event arguments Visual C# coding Indentation... Learn about: Data sources...