Wise Owl courses

...Selecting to the end of a block Selecting a range by its corners The VB code editor Using Project Explorer Creating modules Basic subroutines and comments... Learn about: Loops & conditions, Referencing other applications, Visual Basic...

...and when you should avoid them; and learn about debugging and error trapping. Suitable for: This Advanced SQL course is aimed primarily at people working... Learn about: Temporary tables and table variables, Table-valued functions, Testing conditions...

...The VBA code editor Two ways to create modules Using Project Explorer Basic subroutines and comments Messages and variables The all-powerful DoCmd object... Learn about: Messages & variables, Case Studies, Linking to Excel & Word...

...Avoiding circularity Separating interest paid and received Dealing with compound interest rates Investment appraisal Net present value Internal rate... Learn about: Cashflow calculations, Building models, Conditional Formatting...

...functions and concatenation Calculations using dates GetDate Converting dates Useful date functions Basic joins Inner joins Table aliases Left and right... Learn about: Setting criteria using WHERE, Aggregation and grouping, Creating databases - overview...

...classes in Excel Excel templates Sharing classes Excel add-ins Linking to data ADO or Access Database Engine Referencing the right library Opening and using recordsets... Learn about: Revision of VBA, Class modules, Links to other applications...

...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, Data sets, Reporting Services...

...(Power Query) Querying databases Web pages and XML files Transforming data (Power Query) Splitting columns Merging and inserting columns Other transforms... Learn about: Transforming data (Power Query), DAX basics, PowerPivot data models...

...a child report The SSRS web portal Browsing to the web portal Viewing reports Managing reports If time KPIs and mobile reports Creating a KPI Installing... Learn about: The SSRS web portal, Data sources and datasets, Basic reports...

...software Using Excel as a client Using Reporting Services Cube actions Creating URL click-throughs Drill-through actions... Learn about: MDX Expressions, Visual Studio primer, Multi-dimensional models...

...and the exercises use simulated examples of real-life tasks. SSIS basics Solutions and projects Basic packages Control and data flow tasks The 32-bit question... Learn about: Using different data connections, Basic data transforms, Data conversion transforms...

...Linking tables using RELATED Measures Creating measures SUMX, AVERAGEX, etc. Changing query context The CALCULATE function Using FILTER Prototyping using... Learn about: Visual Studio basics, Changing query context, Calculated columns...

...and thirdly, you'll learn how to create calculated columns and measures using basic DAX language. You'll also learn how to use Power BI... Learn about: Query editor, Action buttons, Using Power BI Service...

...Date-based functions Advanced date functions Multiple relationships Moving averages Dynamic measures The ISFILTERED function The ALLSELECTED FUNCTION Dynamic... Learn about: DAX queries, Understanding EARLIER, Dynamic measures...

...ANY and IN Using EXISTS Correlated subqueries If time Derived tables and CTEs Using derived tables Common Table Expressions (CTEs) Multiple CTEs in a single query... Learn about: SQL Database, Database training...

...effects Bookmarks Creating bookmarks Filtering using bookmarks Spotlighting and hiding visuals Overview of maps The types of map Geo-location Introduction... Learn about: Creating databases - overview, Working with tables, Power BI Service Overview...

...Basic coding • Python variables • Testing conditions • Printing and f-strings Visual Studio Code • Installing extension • Configuring settings • Useful... Learn about: Visual Studio basics, Data sources, Error Handling...

...functions Finding and replacing text Extracting and joining text Multiple worksheets Group editing Formulae across sheets 3D summing across sheets Advanced... Learn about: Multiple Worksheets, Text Functions, Lookup functions...

...Visual C# (also known as Visual C Sharp) as its programming language. Suitable for: This Advanced ASP.NET C# course is aimed primarily at businesses...

...The course is ideally suited to people who have some programming or web development background. You will write code using Visual C# within Visual Studio... Learn about: Data sources...