Kursplan
Module 1 – Advanced Excel for Decision-Making (6 hours)
- Advanced formulas and functions (INDEX/MATCH, XLOOKUP, IF, nested formulas)
- Data analysis tools: PivotTables, PivotCharts, Power Query basics
- Automation with macros and Copilot suggestions
- Creating dashboards and reports for leadership insights
- Practical exercises applied to healthcare and management scenarios
Module 2 – PowerPoint for Impactful Presentations (6 hours)
- Professional slide design and storytelling techniques
- Effective data visualization and use of charts
- Integration with Excel and Copilot-generated presentations
- Tips for engaging executive audiences
- Final project: presentation building using Copilot
Module 3 – Word for Professional Documentation (6 hours)
- Creating and formatting professional reports and proposals
- Templates and styles for consistency and efficiency
- Integrating Copilot for writing, summarizing, and editing content
- Collaboration tools and version control
- Practical exercise: building a leadership report
Module 4 – Outlook for Productivity and Team Organization (6 hours)
- Advanced email and calendar management techniques
- Rules, categories, and automation for efficiency
- Copilot for drafting, summarizing, and scheduling assistance
- Integration with Teams and other Microsoft 365 tools
- Leadership-focused time management strategies
Module 5 – Microsoft Copilot in Leadership Workflows (6 hours)
- Overview of Copilot across Microsoft 365
- AI-assisted task automation in Excel, Word, and Outlook
- Prompt design for effective Copilot usage
- Ethical use of AI and data privacy best practices
- Hands-on practice: creating workflows using Copilot
Summary and Next Steps
Krav
- An understanding of basic data management and reporting concepts
- Experience with Microsoft Office applications such as Excel, Word, PowerPoint, and Outlook
- Familiarity with online collaboration tools such as Teams or OneDrive
Audience
- Managers and decision-makers seeking to enhance productivity using Microsoft 365 and Copilot
- Professionals responsible for preparing reports, presentations, and documentation for leadership
- Teams aiming to leverage AI tools for automation and strategic insight generation
Referanser (5)
**Scope of Material**This course provides a comprehensive introduction to the fundamental concepts and advanced techniques in the field of data science. The scope of material is designed to equip learners with the essential skills and knowledge necessary to excel in data science roles.**Course Overview**- Introduction to Data Science- Data Collection and Preprocessing- Exploratory Data Analysis- Statistical Methods- Machine Learning Algorithms- Data Visualization- Big Data Technologies- Ethical Considerations in Data Science- Case Studies and Real-World Applications**Learning Objectives**- Understand the core principles of data science.- Learn how to collect, clean, and preprocess data.- Apply statistical methods to analyze data.- Implement machine learning algorithms.- Create effective data visualizations.- Work with big data technologies.- Address ethical issues in data science.- Solve real-world problems using data science techniques.**Prerequisites**- Basic understanding of programming.- Familiarity with Python or R.- Knowledge of basic statistics.- Interest in data analysis and machine learning.**Target Audience**- Aspiring data scientists.- Professionals looking to transition into data science roles.- Data analysts seeking to enhance their skills.- Students studying computer science, statistics, or related fields.**Assessment and Evaluation**- Assignments and projects.- Quizzes and exams.- Participation in discussion forums.- Final project presentation.
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Kurs - Word dla zaawansowanych
Maskinoversatt
**Kursoversikt****Kurskode:** INFO3001**Kursnavn:** Innføring i programmering**Kursbeskrivelse:**Denne kurset gir en grunnleggende innføring i programmering. Studenter vil lære å bruke programmeringsspråket Python for å løse problemer og utvikle programvareløsninger. Kurset dekker grunnleggende programmeringskonsepter, algoritmer og datastrukturer. Studenter vil også få innføring i bruken av Git for versjonskontroll og samarbeid i programmeringsprosjekter.**Læringsmål:**- Forstå grunnleggende programmeringskonsepter og syntaks i Python.- Utvikle evnen til å løse problemer ved hjelp av programmering.- Implementere og bruke grunnleggende algoritmer og datastrukturer.- Bruke Git for versjonskontroll og samarbeid i programmeringsprosjekter.**Kursinnhold:****Uke 1: Introduksjon til Python**- Installasjon av Python og IDLE- Grunnleggende syntaks og variabler- Innlesing og utskrift av data**Uke 2: Kontrollstrukturer**- Betingelser (if, else, elif)- Løkker (for, while)- Bruk av innbyggede funksjoner**Uke 3: Funksjoner og moduler**- Definering og bruk av egne funksjoner- Importering og bruk av moduler- Pakkeadministrasjon med pip**Uke 4: Datatyper og samlinger**- Listen datatype- Strenger og string-metoder- Dictionaries og tuples**Uke 5: Feilhåndtering og testing**- Feilhåndtering med try-except- Skriving av tester med unittest- Testdrevet utvikling**Uke 6: Innføring i algoritmer**- Algoritmer og kompleksitet- Sorteringsalgoritmer- Søkealgoritmer**Uke 7: Innføring i datastrukturer**- Stakk og kø- Lenkede lister- Binære trær**Uke 8: Innføring i Git**- Installasjon og konfigurering av Git- Grunnleggende Git-kommander- Bruk av GitHub for samarbeid**Vurdering:**- Praktiske oppgaver: 40%- Projekt: 30%- Eksamen: 30%**Anbefalt litteratur:**- "Automate the Boring Stuff with Python" av Al Sweigart- "Python Crash Course" av Eric Matthes**Kursressurser:**- Python-dokumentasjon- Git-dokumentasjon- Online-tutorialer og videoforelesninger**Kursansvarlig:**Professor John Doekontakt@eksempel.no**Kontaktinformasjon:**For spørsmål eller ytterligere informasjon, vennligst kontakt kursansvarlig.
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Kurs - MS Word - poziom podstawowy
Maskinoversatt
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Kurs - Advanced Slide Design in PowerPoint
noen små triks angående bildeformatering og maler - veldig nyttig :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
Kurs - Advanced MS PowerPoint
Maskinoversatt
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.