Alle kategorier
Du har valgt: IT-kurs
Nullstill
Filter
Ferdig

-

Mer enn 100 treff i IT-kurs

Sorter på søkerangering, kursnavn, pris, sted, kursdato


Oslo København 5 dager 2 989 EUR
08 May
08 May
The course reviews the tasks covered in Red Hat System Administration I (RH124) and II (RH134) at an accelerated pace. [+]
The RHCSA Rapid Track course (RH200) relates to Red Hat® Enterprise Linux® 7 and is designed for students who already have significant experience with Linux administration. The course reviews the tasks covered in Red Hat System Administration I (RH124) and II (RH134) at an accelerated pace On completion of course materials, students should be prepared to take the Red Hat Certified System Administrator (RHCSA) exam. This version of the course includes the exam. Note: This course builds on a student's existing understanding of command-line based Linux system administration. Students should be able to execute common commands using the shell, work with common command options, and access man pages for help. Students lacking this knowledge are strongly encouraged to take Red Hat System Administration I (RH124) and II (RH134) instead. Language: Spoken language in the training will be english unless all students are comfortable/familiar with norwegian. Training material is in english.   Follow up courses and exams: Red Hat Certified System Administration (RHCSA) exam (EX200) Red Hat System Administration III with RHCE Exam (RH255) Red Hat Enterprise Virtualization (RH318), RHCVA Exam (EX318) Red Hat Linux Troubleshooting (RH142) Includes: 5 days intensive training on Red Hat Enterprise Linux Hands-on labs and exercises Catered lunch One workstation per student Student materials, pre-assessment questionnaire, study aids, handouts Red Hat promotional items All other expenses of travel and per diem are the student´s responsibility.   Course content summary Managing users and groups, files, and file permissions Updating software packages with yum Managing and troubleshooting systemd services during the boot process Network configuration and basic troubleshooting Managing local storage and creating and using file systems Firewall management with firewalld Managing kernel-based virtual machines (KVMs) Automating installation of Red Hat Enterprise Linux using Kickstart   Outline for this course Accessing the command line Log in to a Linux system and run simple commands using the shell.   Managing files from the command line Work with files from the bash shell prompt.   Managing local Linux users and groups Manage Linux users and groups and administer local password policies.   Controlling access to files with Linux file system permissions Set access permissions on files and interpret the security effects of different permission settings.   Managing SELinux security Use SELinux to manage access to files and interpret and troubleshoot SELinux security effects.   Monitoring and managing Linux processes Monitor and control processes running on the system.   Installing and updating software packages Download, install, update, and manage software packages from Red Hat and yum package repositories.   Controlling services and daemons Control and monitor network services and system daemons using systemd.   Managing Red Hat Enterprise Linux networking Configure basic IPv4 networking on Red Hat Enterprise Linux systems.   Analyzing and storing logs Locate and interpret relevant system log files for troubleshooting purposes.   Managing storage and file systems Create and use disk partitions, logical volumes, file systems, and swap spaces.   Scheduling system tasks Schedule recurring system tasks using cron and systemd timer units.   Mounting network file systems Mount network file system (NFS) exports and server message block (SMB) shares from network file servers.   Limiting network communication with firewalld Configure a basic local firewall.   Virtualization and kickstart Manage KVMs and install them with Red Hat Enterprise Linux using Kickstart. [-]
Les mer
Oslo 3 dager 1 750 EUR
27 Mar
This officially-authorized Apple Pro Training is a top-notch primer for anyone who needs to implement, administer, or maintain a network that uses OS X Server on El Capit... [+]
This course provides comprehensive coverage of OS X Server and is part of the Apple Pro Training series—the only Apple-certified training on the market. Designed for help desk specialists, technical coordinators, and entry-level system administrators, this course teaches you how to install and configure OS X Server on El Capitan to provide network-based services. You’ll also learn to use tools for efficiently managing and deploying OS X Server. In addition to learning key concepts and experiencing hands-on, practical exercises throughout. Provides authoritative explanations of OS X Server setup and management on El Capitan Focused lessons take you step by step through practical, real-world exercises Lesson review questions summarize what you learn to prepare you for the Apple certification exam Lesson files available for download What You’ll Learn The features and functionality of OS X Server for El Capitan How to configure essential services on OS X Server for El Capitan How to use OS X Server tools to monitor and troubleshoot services Effective use of OS X Server to manage a small network of Mac computers and users How to manage access to files and services Table of Contents Configuring and Monitoring OS X Server Lesson 1 Installing OS X Server Lesson 2 Providing DNS Records Lesson 3 Exploring the Server App Lesson 4 Configuring SSL Certificates Lesson 5 Using Status and Notifications Lesson 6 Backing Up OS X Server Configuring Accounts Lesson 7 Configuring Open Directory Services Lesson 8 Managing Users Managing Devices with Configuration Profiles Lesson 9 Configuring OS X Server toProvide Device Management Lesson 10 Managing with Profile Manager Sharing Files Lesson 11 Configuring the File Sharing Service Lesson 12 Defining File Access Implementing Deployment Solutions Lesson 13 Leveraging NetInstall Lesson 14 Caching Content from Apple Lesson 15 Implementing the Software Update Service Providing Network Services Lesson 16 Offering Time Machine Network Backup Lesson 17 Providing Security via the VPN Service Lesson 18 Configuring DHCP Lesson 19 Hosting Websites Using Collaborative Services Lesson 20 Providing Mail Service Lesson 21 Configuring the Wiki Service Lesson 22 Implementing the Calendar Service Lesson 23 Managing the Contacts Service Lesson 24 Providing the Messages Service Using Command Line Lesson 25 Managing OS X Server with the Command-Line Interface [-]
Les mer
Stockholm 4 dager 17 700 kr
09 May
This 3 day course is for the skilled DBA who wants to learn about and how to setup different High Availability solutions for MariaDB and MySQL. [+]
MariaDB & MySQL are all about performance. Getting the most performance requires not just the standard MariaDB or MySQL tweaking and tuning, but also a deep understanding of the new performance enhancing features. This instructor-led class is for those who wants to be able to obtain the highest performance from their MariaDB & MySQL databases. Learn how to optimize queries, find bottlenecks, utilize caches, and more. Get the latest tips and tricks for squeezing every last drop of performance out of your MariaDB or MySQL server! What you'll learn Choose the best storage engine to suit your dataset and traffic Configure MariaDB or MySQL for best connection concurrency vs memory footprint Design your schema, normalize it, and know when to de-normalize! Tune your SQL queries with inside knowledge of the MariaDB Optimizer Design your application to handle scaling out with Replication, and other technologies [-]
Les mer
Trondheim Kristiansand Og 5 andre steder 1 dag 4 900 kr
05 Apr
26 Apr
11 May
Excel nivå 2 er et mellomnivå kurs for deg som har du tatt i bruk Excel, og ønsker å lære mer. [+]
Har du tatt i bruk Excel, og ønsker å lære mer? Excel nivå 2 er et mellomnivå kurs for deg som bruker Excel fra tid til annen, men som føler likevel at en ikke får ordentlig taket på mulighetene som ligger i programmet. Kurset passer også perfekt som oppfølgingskurs for deg som har deltatt på Excel nivå 1.  Du kommer til å bli overrasket over mulighetene som ligger i Excel. Dette lærer duI løpet av kurset vil du lære du hvordan du bedre kan utnytte mulighetene som ligger i programmet slik at din arbeidsdag blir enklere og mer effektiv. Du vil blant annet lære: Hvordan bruke Excel effektivt Nyttige formler og funksjoner Pivottabeller Profesjonelt utseende av ditt regneark Mange gode tips og triks som gjør arbeidsdagen enklere Les mer om kursinnhold her: Kursinnhold Kursleder Kursleder er Georg Mjølsnes Georg har over 15 års erfaring med undervisning fra Excel. Han er sertifisert Microsoft ekspert i office pakke og får fantastisk gode tilbakemelding fra deltakere. Tilbakemeldinger fra tidligere deltakere: «Veldig fornøyd ! Kursleder var veldig flink til å lære fra seg. Lærte mer enn jeg forventet» » Utrolig bra, mange nyttige tips og aha opplevelser. Fantastisk kurs» «Dette skulle jeg gjordt for lenge siden. Meget lærerikt, positivt og humørfylt» «Hyggelig atmosfære og klar formidling. Helt topp pedagogisk»  Praktiske opplysninger Pris for kurset er kr 4 900,-. Inkludert i prisen er undervisningsmateriell, kursbevis, lunsj samt servering i pauser. Kurset foregår på hotell og inkludert i prisen er en smakfull lunsj samt servering i pauser. Kurset er lagt opp med praktiske oppgaver underveis i kurset. Vi stiller med en pc til hver av deltakerne. Vi har maks 15 deltakere på dette kurset slik at alle skal få utbytte av undervisningen. [-]
Les mer
Oslo 2 dager 12 000 kr
22 May
Students attending this course will gain in-dept knowledge of how to configure an manage their Palo Alto networks Panorama Management server. [+]
  Palo Alto Networks Education Training from Palo Alto Networks® and a Palo Alto Networks® Authorized Training Center delivers the knowledge and expertise to prepare you to protect our way of life in the digital age. Our trusted security certifications give you the next-generation security platform knowledge necessary to prevent successful cyber attacks and safely enable applications. Overview The Palo Alto Networks® Panorama 8.0: Manage Multiple Firewalls (EDU-221) course is two days of instructor-led training that will enable you to: Configure and manage the next-generation Panorama™ management server Gain experience configuring templates and device groups Gain experience with administration, log collection, and logging and reporting Gain experience with Panorama™ High Availability Target Audience Security Administrators, Security Analysts, Network Professionals, Security Engineers, Network Engineers, and Support Staff Prerequisites Students must complete the Firewall 8.0 Essentials: Configuration and Management (EDU-210) class, have an understanding of Palo Alto next-generation firewall management, and understand basic networking concepts, including routing and IP addressing.Scope Course level: IntermediateCourse duration: 2 daysCourse format: Combines lecture with hands-on labsPlatform support: PanoramaLanguage: The instructor will speak Norwegian, the documentation is in English KURSINNHOLD: Module 1: Overview Module 2: Initial Configuration Module 3: Templates Module 4: Device Groups Module 5: Administration Module 6: Distributed Log Collection Module 7: Logging and Reporting Module 8: Panorama High Availability   Deltagerne må ta med egen PC til bruk under kurset.     [-]
Les mer
København Stockholm 2 dager 1 700 USD
15 May
01 Jun
In Puppet Architect students will learn how to design their own infrastructure and define their ownRight Way to implement Puppet. [+]
This course is designed to provide practical skills used to architect Puppet infrastructure and to understand interactions between different components. The class will focus on the architecture of Puppet Enterprise itself, giving students the ability to determine the most efficient and extensible architecture to scale Puppet to their own needs with API integration and monitoring to support its growth. Note: This is an advanced level course. Objectives After completing this course students will be able to architect a robust Puppet infrastructure integrated with external tooling and scale up to meet growing business demands. They will be able to evaluate design patterns and workflow alternatives and develop policies that work well for their own organization.   What You Will Learn to Help You Solve Problems   Designing and implementing an efficient development workflow. Designing complex Hiera datasource hierarchies. Sharing data between nodes via exported resources. Using MCollective from the command line to automate infrastructure orchestration. Estimating the number of nodes their Master(s) can support. Using r10k to automate Puppet code deployment. Dynamic provisioning strategies providing for rapid infrastructure scaling. Designing a scaled architecture for their infrastructure. Managing multiple Puppet environments in an effective manner. Interacting with the Puppet Master using the REST APIs. The underlying message passing protocol that MCollective is built on. Scaling the ActiveMQ messaging bus. Integrating Puppet with external tools via Hiera backends, report processors, etc.   [-]
Les mer
Stockholm Oslo 1 dag 360 EUR
08 May
29 May
12 Jun
This course guides you through the process of integrating Mac into a Windows or other standards-based network. [+]
Organizations are increasingly integrating Mac computers into Windows or other standards-based network environments. But users and the IT professionals who support them can relax, because Mac integration is easy. This guide provides step-by-step instructions for a successful integration.  Objectives Upon completion of the Mac Integration Basics 10.12 course, students will be able to: Integrate a Mac into a Windows network environment Configure a Mac to work with Active Directory Take advantage of network services, file sharing, printing, instant messaging, email, calendars, and contacts Provide security at the user, local-networking, and remote-networking levels Migrate data from a Windows PC to a Mac Back up data Run Windows programs on a Mac Curriculum Directory Services Connecting a Mac to a directory server Using network accounts File Sharing Connecting to file servers Turning on personal file sharing Email, Contacts, and Calendars Managing Internet Accounts preferences Connecting to an Exchange Server Connecting Mail to non-Windows servers Adding accounts in Mail, Contacts, and Calendars Security Built-in security features Creating strong passwords Using two-factor authentication Setting a firmware password Locking a Mac screen Creating user accounts Disabling automatic login Protecting start-up disk files Ensuring that the apps you download are safe Providing network security Printing Connecting to a local printer Setting up a wireless printer Sharing your printer Setting up a printer shared by a Mac and a PC via SMB or CIFS Setting up an IP printer Specifying printer features Printing from a network printer Instant Messaging iMessage Jabber Configuring Messages Adding accounts Chatting on a local network with Bonjour Moving and Backing Up Content Moving content Backing up data with Time Machine Running Windows on a Mac Running Windows natively or virtually Using Office Using cross-platform apps Using cross-platform files Additional Resources Books Courses Certifications Support [-]
Les mer
Oslo København 1 dag 4 100 kr
31 Mar
31 Mar
02 Jun
The exam tests to determine if your knowledge, skill, and ability meet those required of a senior system administrator responsible for RHEL systems. [+]
This exam and the exam objectives provided here are based on the Red Hat® Enterprise Linux® 7 version of the exam. The performance-based Red Hat Certified Engineer exam (EX300) tests to determine if your knowledge, skill, and ability meet those required of a senior system administrator responsible for Red Hat Enterprise Linux (RHEL) systems. Red Hat Certified System Administrator (RHCSA) certification is required to earn RHCE certification. An RHCE certification is earned by a Red Hat Certified System Administrator (RHCSA) who has demonstrated the knowledge, skill, and ability required of a senior system administrator responsible for Red Hat Enterprise Linux systems.   Study points for the exam RHCE exam candidates should consult the RHCSA exam objectives and be capable of RHCSA-level tasks, as some of these skills may be required in order to meet RHCE exam objectives. Red Hat reserves the right to add, modify, and remove objectives. Such changes will be made public in advance through revisions to this document. RHCE exam candidates should be able to accomplish the following without assistance. These have been grouped into several categories.   System Configuration and Management  Use network teaming or bonding to configure aggregated network links between two Red Hat Enterprise Linux systems Configure IPv6 addresses and perform basic IPv6 troubleshooting Route IP traffic and create static routes Use firewalld and associated mechanisms such as rich rules, zones and custom rules, to implement packet filtering and configure network address translation (NAT) Use /proc/sys and sysctl to modify and set kernel runtime parameters Configure a system to authenticate using Kerberos Configure a system as either an iSCSI target or initiator that persistently mounts an iSCSI target Produce and deliver reports on system utilization (processor, memory, disk, and network) Use shell scripting to automate system maintenance tasks   Network Services Network services are an important subset of the exam objectives. RHCE candidates should be capable of meeting the following objectives for each of the network services listed below:  Install the packages needed to provide the service Configure SELinux to support the service Use SELinux port labeling to allow services to use non-standard ports Configure the service to start when the system is booted Configure the service for basic operation Configure host-based and user-based security for the service HTTP/HTTPS Configure a virtual host Configure private directories Deploy a basic CGI application Configure group-managed content Configure TLS security DNS Configure a caching-only name server Troubleshoot DNS client issues NFS Provide network shares to specific clients Provide network shares suitable for group collaboration Use Kerberos to control access to NFS network shares SMB Provide network shares to specific clients Provide network shares suitable for group collaboration Use Kerberos to authenticate access to shared directories SMTP Configure a system to forward all email to a central mail server SSH Configure key-based authentication Configure additional options described in documentation NTP Synchronize time using other NTP peers Database services Install and configure MariaDB Backup and restore a database Create a simple database schema Perform simple SQL queries against a database [-]
Les mer
Stockholm Oslo 4 timer 700 EUR
04 Apr
09 May
30 May
In this four-hour workshop, participants learn about security and privacy technologies that are built into iOS [+]
Whether a company is deep into its deployment of iOS or just beginning the journey, security and privacy come up in every deployment conversation. In this four-hour workshop, participants learn about security and privacy technologies that are built into iOS so they’re ready to discuss why the Apple platform is the best choice for business mobility. Objectives Identify the security and privacy posture for a device after the completion of Setup Assistant Explain the importance of a device passcode in protecting user and company data Describe the built-in features of iOS that help keep user and company data separate Identify strategies to ensure that data is encrypted when sent over networks to trusted hosts Respond to misconceptions related to iOS security and privacy Help plan the security and privacy strategy for a successful iOS deployment [-]
Les mer
Oslo Trondheim 2 dager 7 750 kr
19 Apr
02 May
04 May
Bli med på spennende og lærerikt kurs hvor du lærer å ta i bruk smarte og tidsbesparende metoder for arbeid i Office-programmene. [+]
Bli med på kurs i Office og få en oppdatering på nyheter i Excel, PowerPoint og Word. Jobb mer effektivt og spar mye tid! Kurs i officepakken gir deg en oversikt over de mest populære og tidsbesparende teknikkene i Excel, Word og PowerPoint.  Du vil få innblikk i de aller smarteste metodene for å forenkle din arbeidsdag, og spare deg for verdifull tid. Oppdag at oppgaver som tidligere tok flere timer, kan gjøres på få minutter. Kurset foregår i en kombinasjon av teori og praktiske øvelser.Emneoversikt, dette lærer du: ExcelIngen andre kurs gir deltakerne så mange aha-opplevelser som Excel-kurs. Regneark-programmet er elsket av den som behersker det, og hatet av dem som ikke har lært det ordentlig. Se frem til en rekke nye oppdagelser som vil løse dagligdagse problemer med få tastetrykk. Jobb smart med formler og funksjoner Navngivning av celler Autofyll og rask utfylling Sparklines Tabell og lister Pivottabeller- og diagrammer Betinget formatering PowerPointI løpet av en halv kursdag vil du lære å gjøre enkle grep som vil løfte dine PowerPoint-presentasjoner til nye høyder. Ikke minst vil du ha stor glede av å lære å inkludere film, lyd og animasjoner i din presentasjon. SmartArt, figurer og fotografier Film og lyd i presentasjoner Animasjoner og bevegelsesbaner Tilpassede lysbildefremvisninger SlideShark og Slideshare WordDe aller fleste har et forhold til Word, og mange har lært seg programmet på egenhånd.  Likevel viser det seg at de fleste jobber ineffektivt og upraktisk. Vi lærer deg hvordan du kan ta i bruk avanserte funksjoner som løser en rekke problemer og sparer deg for utallige timers arbeid. Effektiv jobbing med avsnitt, punktmerkeringer og nummerering Stiler Innholdsfortegnelser Topp- og bunntekst Fotnoter og andre referanser Fletting Bruk av maler   Hvem passer kurset for Kurset passer for deg som vil jobbe mer effektivt i Microsoft Office, og som allerede har grunnleggende kunnskap i bruk av Excel, Word og PowerPoint.Målet med kurset Etter gjennomført kurs i Office-pakken vil du få en god forståelse for hvordan du jobber smart i Microsoft Office. Vi viser deg hvordan du kan spare mye tid ved å bruke riktige arbeidsteknikker i Excel, Word og PowerPoint.Forkunnskaper Du må ha grunnleggende forståelse for bruk av PC, og du bør tidligere ha jobbet litt i Excel, Word og PowerPoint.Varighet 2 dager á 6 timerInkludert i kursetKursbevis, lunsj og forfriskninger gjennom kursdagen.  Annen viktig informasjon: Deltakerne må ta med egen PC med programmene: PowerPoint, Word og Excel på dette kurset. Det er viktig at alle som ikke har programmet laster ned Office 2013, 2016 eller Office 365 og har den klar på din PC før kurset starter. En gratis prøveversjon som varer i 30 dager kan enkelt lastes ned her: https://products.office.com/nb-no/try Du kan bruke både PC og Mac, men PC er å foretrekke da menyen vil se noe annerledes ut på Mac. Husk å ta med lader og gjerne mus! Velkommen på kurs i Office-pakken!     Kursleder Kathrine Jølle Wathne Kathrine Jølle Wathne har lang erfaring med undervisning i Office-programmene, og har evnen til å engasjere sine kursdeltakere. Hun får svært gode tilbakemeldinger på evalueringene.     [-]
Les mer
København 4 timer 600 EUR
19 May
The performance-based Red Hat Certificate of Expertise in Ansible Automation exam (EX407) tests your ability to use Ansible to automate the configuration of systems and a... [+]
The performance-based Red Hat Certificate of Expertise in Ansible Automation exam (EX407) tests your ability to use Ansible to automate the configuration of systems and applications. By passing this exam, you earn a Red Hat Certificate of Expertise that also counts towards earning a Red Hat Certified Architect (RHCA®). This exam is based on Red Hat® Enterprise Linux® 7. Red Hat recommends that candidates earn Red Hat Certified Engineer (RHCE®) or at a minimum Red Hat Certified System Administrator (RHCSA®) before attempting this exam, but neither is required. Study points for the exam To help you prepare, the exam objectives highlight the task areas you can expect to see covered in the exam. Red Hat reserves the right to add, modify, and remove exam objectives. Such changes will be made public in advance. Candidates should have the following skills and abilities: Understand core components of Ansible Inventories Modules Variables Facts Plays Playbooks Configuration files Run ad-hoc Ansible commands Use both static and dynamic inventories to define groups of hosts Utilize an existing dynamic inventory script Create Ansible plays and playbooks Know how to work with commonly used Ansible modules Use variables to retrieve the results of running a commands Use conditionals to control play execution Configure error handling Create playbooks to configure systems to a specified state Selectively run specific tasks in playbooks using tags Create and use templates to create customized configuration files Work with Ansible variables and facts Create and work with roles Download roles from an Ansible Galaxy and use them Manage parallelism Use Ansible Vault in playbooks to protect sensitive data Install Ansible Tower and use it to manage systems Use provided documentation to look up specific information about Ansible modules and commands As with all Red Hat performance-based exams, configurations must persist after restart without intervention. Preparation Red Hat encourages all candidates for the Red Hat Certificate of Expertise in Ansible Automation exam to consider taking the Cloud Automation with Ansible course (DO407). Attendance in this class is not required to take the exam. While attending Red Hat classes can be an important part of one's preparation to take this exam, attending class does not guarantee success on the exam. Previous experience, practice, and native aptitude are also important determinants of success. Many books and other resources on system administration for Red Hat's products are available. Red Hat does not officially endorse any as preparation guides for its exams. Nevertheless, you may find additional reading deepens understanding and can prove helpful. Exam Format This exam is a performance-based evaluation of a candidate’s ability to use Ansible to automate system configuration and application deployment. Candidates will be required to develop Ansible playbooks that configure systems for specific roles and then apply those playbooks to systems to implement those roles. Candidates will also be asked to demonstrate their ability to run Ansible playbooks and configure an Ansible environment for specific behaviors. Candidates will be evaluated on whether they have met specific objective criteria. Performance-based testing means that candidates must perform tasks similar to what they perform on the job. This exam consists of one section lasting 3 hours. Scores and reporting Official scores for exams come exclusively from Red Hat Certification Central. Red Hat does not authorize examiners or training partners to report results to candidates directly. Scores on the exam are usually reported within 3 U.S. business days. Exam results are reported as total scores. Red Hat does not report performance on individual items, nor will it provide additional information upon request. Recommended training In preparation to take this expertise exam, Red Hat recommends: Automation with Ansible (DO407)Learn to write and manage Ansible playbooks and automate system administration tools. [-]
Les mer
Oslo Trondheim 2 dager 8 990 kr
29 Mar
20 Apr
20 Apr
PPivottabeller og rapportering i Excel: Fra transaksjonsdata til en forståelige rapport [+]
  Beskrivelse: Du importerer, bearbeider og analyserer data i Excel! Jobber du på en økonomiavdeling og med Excel er sannsynligheten meget stor for at du kan spare timer hver eneste uke ved å delta på dette kurset. Stikkordene er: Import Bearbeiding av store datamengder som kommer fra andre systemer Rapportering i Excel Kurset fokuserer på å hente, strukturere og kvalitetssikre data fra andre systemer i Excel. Du lærer å utnytte de muligheter som pivottabeller gir slik at dine rapporter gir grunnlag for mer solide beslutninger og også fremstår mer profesjonelle. Etter å ha deltatt på dette kurset vil du: Ha solid kompetanse om pivotteknikker og hvordan du blir mer effektiv i rapporteringen Kunne utnytte Excel og koblinger mot databaser for å sikre solid kvalitet på data som du jobber med Har lært ulike metoder for å slå sammen data (konsolidere) fra ulike kilder Kunne jobbe effektiv med Excel i kombinasjon med andre Office -programmer Effektivt lage rapporter med nøkkeltall og status Målgruppe: Økonomipersonell som lager rapporter med Pivottabeller.    Forkunnskaper: Excel videregående.    Innhold: Introduksjon: Kort repetisjon med de ”smarteste” triksene fra Excel Uttrekk fra andre databaser Lær å sette opp en ODBC-kobling mot en ekstern datakilde Bruk SQL for å lage dine egne uttrekk (Ms-Query) Lage profesjonelle rapporter med Pivot Lær å lage felt og element Lær ulike beregningsmåter (akkumulering, statistikk osv.) Hent data direkte fra en database direkte inn i Pivottabellen Grupper data og vis data slik du selv ønsker Lær mer om bruk av funksjoner for smarte formler Hvordan bruke INDEKS sammen med SAMMENLIGNE og FORSKYVNING for uttrekk av data fra komplekse tabeller Bruk av funksjonen INDIREKTE for fleksible uttrekk Lær å lage fleksible navngitte områder som endrer seg i forhold til listens størrelse Introduksjon til bruk av matriseformler Automatisering med makro (VBA) Introduksjon til VBA - Prosjektutforsker Bruk av Inputbox og msgbox for kommunikasjon med regnearket Lær å gjøre enkle endringer i innspilt vba-kode       [-]
Les mer
Oslo 3 dager 19 000 kr
29 May
Successful completion of this three-day, instructor-led course will enhance the student’s understanding of how to troubleshoot the full line of Palo Alto Networks® nex... [+]
Palo Alto Networks Education Training from Palo Alto Networks® and a Palo Alto Networks® Authorized Training Center delivers the knowledge and expertise to prepare you to protect our way of life in the digital age. Our trusted security certifications give you the next-generation security platform knowledge necessary to prevent successful cyber attacks and safely enable applications. Overview Firewall 8.0: Debug and Troubleshoot is the next-level course to Palo Alto Networks® Firewall 8.0 Essentials: Configuration and Management (EDU-210). The three-day, instructor-led Firewall 8.0: Debug and Troubleshoot course expands on the topics from the 210 course with hands-on troubleshooting labs: Investigate networking issues using advanced firewall tools including the CLI Analyze advanced logs to resolve various real-life scenarios Solve advanced routing scenario challenges Target Audience Security Engineers, Security Administrators, Security Operations Specialists, Security Analysts, Network Engineers, and Support Staff. Prerequisites Students must complete the Firewall 8.0 Essentials: Configuration and Management (EDU-210) course and have an understanding of network concepts, including routing, switching, and IP addressing. They also will need in-depth knowledge of port-based security and security technologies. Scope Course level: AdvancedCourse duration: 3daysCourse format: Combines lecture and hands-on labsPlatform support: PaloAlto Networks® next-generation enterprise firewallsrunningthePAN-OS® operatingsystemLanguage: The instructor will speak Norwegian, the documentation is in English   KURSINNHOLD: Module 1: Troubleshooint Methodology Module 2: Platform Comparisons When Troubleshooting Module 3: Flow Logic Module 4: Administration Troubleshooting Module 5: Layer 3 Troubleshooting Module 6: Policy Troubleshooting Module 7: User-ID™ Troubleshooting Module 8: VPN Troubleshooting Module 9: GlobalProtect™ Troubleshooting Module 10: Performance Troubleshooting   Deltagerne må ta med egen PC til bruk under kurset.   [-]
Les mer
Oslo Stavanger 2 dager 9 900 kr
20 Apr
26 Apr
10 May
Kurs for deg som vil publisere rapporter fra ulike datakilder [+]
Dette 2-dagers-kurset egner seg for deg som skal begynne å bruke PowerBI. For informasjonsarbeidere som vil ha en introduksjon til BI generelt, vil dette kurset gjennomgå sentrale begreper og praktisk bruk med ett verktøy de kan bruke. For IT-pro og beslutningstakere vil kurset være et grunnlag for å se om brukerne trenger det. For brukere som har fått verktøyet i hendene og vil ha en grunnleggende erfaring og forståelse, vil dette kurset være å komme i gang med PowerBI.    Innhold: Kort introduksjon til PowerPivot og Power Query (repetisjon fra PowerPivot kurs) Kort gjennomgang av forskjeller mellom PowerPivot og pivottabeller, grunnstruktur for god modellering, håndtere datarelasjoner, import av data med Power Query og bruk av Dax. Introduksjon til Power BI Desktop Kom i gang med Power BI Deskop Innlastning av data Utvikling og dekorering av rapporter Filtrering av rapporter Bruk av naturlig språk spørringer (skriv inn hva du ønsker og du får det) Bruk av kalenderfunksjon Bruke Power Pivot og Power BI Desktop sammen Deling og oppdatering av rapporter (Dashboard) Inviter brukere til å se dine rapporter Bruk av arbeidsområde (Workspace) i Power BI Vis rapporter på mobile enheter (f.eks ipad eller ipad) Oppdatering av rapporter Oversikt over dataoppdatering [-]
Les mer
Oslo Stockholm 3 dager 13 500 kr
26 Apr
08 May
12 Jun
This course will give you a thorough introduction to bash - using Linux and UNIX on the command line. [+]
This course will give you a thorough introduction to bash - using Linux and UNIX on the command line. You will learn how to correctly use Linux/Unix from the command line interface by learning the 50 (approx.) most common commands pluss useful functions and mechanismsin the shell.   If you are looking at using Linux or UNIX for more than your usual officeapplication, this is the course for you. Redpill Linpros other courses in shellscripting and system administration has this course or comparable knowledge as a requirement.   Goals Understanding how the fundamentals of Linux/UNIX works Enabling you to effectively use the most common tools in UNIX/Linux  Learning the commandline interpreter Bourne Shell (sh) and/or Bourne Again shell (bash). Course Summary What is UNIX/Linux? Files Filehandling Wildcards and regular expressions Tools Redirections and pipes File editing Filetools Shellscript Processhandling Net-tools [-]
Les mer