-
Mastering Microsoft Excel Power Query Editor (SKT_MSEXPQE)Les mer
COURSE CONTENT: Introduction to Power Query Editor • What is Power Query and why use it? • How Power Query fits into Microsoft Excel’s ecosystem. • Importing data from…
-
Microsoft 365 Teams Fundamentals (SKT_M365TMF)Les mer
COURSE CONTENT: Getting Started with Teams • Sign in to Teams • Pick a Team and channel • Find and join a Team • Add a member Best Practices…
-
Microsoft 365 Power Automate Fundamentals (SKT_M365PAF)Les mer
COURSE CONTENT: • Overview of Power Automate • Planning a Power Automate Project • Create an Automatic Flow based on a Template • Work with Approvals Templates • Create…
-
Microsoft 365 Power BI DAX (SKT_M365PBIDX)NOK 6.200Les mer Dette produktet har flere varianter. Alternativene kan velges på produktsiden
COURSE CONTENT: – Percent of Total – Moving Averages – Cumulative Totals – Time Intelligence – Static Grouping – Parameter Tables
-
Microsoft 365 Power BI Advanced Visualisation (SKT_M365PBIAV)NOK 6.200Les mer Dette produktet har flere varianter. Alternativene kan velges på produktsiden
COURSE CONTENT: Report Layouts – Design Tricks to make your Report look great. – Use PowerPoint to Design your Canvas Background – Themes and Layout – Use Logos and…
-
Microsoft Word Level 2 (SKT_MSWDL2)Les mer
COURSE CONTENT: • Customizing Word • Proofing and printing • Word compatibility mode • Advanced paragraph formatting • Advanced picture manipulation • Headers, footers and sections • Watermarks •…
-
Microsoft Word Level 1 (SKT_MSWDL1)Les mer
COURSE CONTENT: • The Microsoft Word screen • Starting to use Microsoft Word • Using templates to create documents • Manipulating text • Pinning files and folder and opening…
-
Microsoft Project Level 4 (SKT_MSPRL4)Les mer
COURSE CONTENT: Customising Microsoft Project • Create Custom Fields • Importing Excel Data • Create Custom Tables • Create Custom Filters • Using the Organizer Tool • Create Custom…
-
Microsoft Project Level 3 (SKT_MSPRL3)Les mer
COURSE CONTENT: Managing Costs • Working with Cost Rate Tables • Changing Costs Rates for Specific Tasks • Using Rate Tables with a Resource Pool • Alter Costs based…
-
Microsoft Project Level 2 (SKT_MSPRL2)Les mer
COURSE CONTENT: Baseline and Interim Plans • Save and View Multiple Baselines in a Single Project • Use Interim Plans to Compare Date Movements Update a Project Plan…
-
Microsoft Project Level 1 (SKT_MSPRL1)Les mer
COURSE CONTENT: Getting Started and Using Project • Installing the Sample Files • Getting Started and Using Project • The Project 2016 Screen • The Ribbon • Closing Microsoft…
-
Microsoft PowerPoint Level 2 (SKT_MSPPL2)Les mer
COURSE CONTENT: • Slide Master Manipulation • Custom Slide Shows • Video and Audio • Action Buttons • Linking and Embedding • Merging and Exporting • Converting to a…
-
Microsoft PowerPoint Level 1 (SKT_MSPPL1)Les mer
COURSE CONTENT: • Creating a presentation • Manipulating slides • Design themes • Text boxes (placeholders) • Inserting slides • Applying a background • Slide Master • Animations •…
-
Microsoft Excel VBA Part 2 (SKT_MSEXVBAP2)Les mer
COURSE CONTENT: If Then Statements • Logical Operators • Select Case • Tax Rates • Mod Operator • Prime Number Checker • Find Second Highest Value • Sum by…
-
Microsoft Excel VBA Part 1 (SKT_MSEXVBAP1)Les mer
COURSE CONTENT: Create a Macro • Swap Values • Run Code from a Module • Macro Recorder • Use Relative References • Formula R1C1 • Add a Macro to…
-
Microsoft Excel Data Management (SKT_MSEXL4)Les mer
COURSE CONTENT: • PivotTables • PivotCharts • Input tables • Hyperlinks • Linking and embedding • Sorting and filtering data • Tracking and reviewing changes • Scenarios • Data…
-
Microsoft Excel Level 3 (SKT_MSEXL3)Les mer
COURSE CONTENT: • Templates • Paste Special Options • Time and Date functions • Financial Functions • LookUp Functions • Nested Functions • Advanced charts • Importing Text files…
-
Microsoft Excel Level 2 (SKT_MSEXL2)Les mer
COURSE CONTENT: • Set up and viewing options • Proofing and printing • 3-D Reference • Mixed References • Mathematical functions • Logical functions • Statistical functions • Text…
-
Microsoft Excel Level 1 (SKT_MSEXL1)Les mer
COURSE CONTENT: • Getting started with Excel • Selection techniques • Manipulating rows and columns • Manipulating Worksheets • Font formatting • Alignment formatting • Number formatting • Basic…
-
Microsoft SharePoint Webpages (SKT_M365SPW)Les mer
COURSE CONTENT: • Get inspired with Microsoft Look Book • Customise site home page • Create site pages and manage page structure • Add text to a page •…
-
Microsoft SharePoint Online for Users (SKT_M365SPU)Les mer
COURSE CONTENT: What is SharePoint Online? • SharePoint Structure • Team site or Communication site • Discover SharePoint site and Follow • Navigation on your SharePoint site Working with…
-
Microsoft SharePoint Online for Owners (SKT_M365SPO)Les mer
COURSE CONTENT: What is SharePoint Online • SharePoint Structure • Team site or Communication site • The SharePoint Environment • Navigation on your SharePoint site Create a new Team…
-
Microsoft 365 Power BI Level 2 (SKT_M365PBIL2)NOK 6.500Les mer Dette produktet har flere varianter. Alternativene kan velges på produktsiden
COURSE CONTENT: Data Modelling • Introduction to Data Modelling • Joins, Relationships and Cardinality • Many to Many Relationships • Star Schemas • Create a Date Table Create…
-
Microsoft 365 Power BI Fundamentals Part 1 (SKT_M365PBIF)Les mer
COURSE CONTENT: Getting Started with Power BI • Concepts and overview • Introduction to main features Connect to a Data Source • Data sources Power BI will connect to…
-
Mastering Microsoft 365 Essentials (SKT_M365IWA)Les mer
COURSE CONTENT: What is Microsoft 365? • Core Components • Log In and Sign Out process Overview of key Microsoft 365 Apps • SharePoint Online (SPO) • Outlook Online…