코스 개요
모듈 1 – 의사 결정을 위한 고급 Excel (6시간)
- 고급 공식과 함수(INDEX/MATCH, XLOOKUP, IF, 중첩 공식)
- 데이터 분석 도구: 피벗 테이블, 피벗 차트, Power Query 기초
- 매크로와 Copilot 제안을 통한 자동화
- 리더십 인사이트를 위한 대시보드 및 보고서 작성
- 의료 및 관리 시나리오에 적용된 실습 연습
모듈 2 – 강력한 프레젠테이션을 위한 PowerPoint (6시간)
- 전문적인 슬라이드 디자인과 스토리텔링 기법
- 효과적인 데이터 시각화와 차트 사용
- Excel 및 Copilot 생성 프레젠테이션 통합
- 임원 청중과의 상호작용을 위한 팁
- 최종 프로젝트: Copilot을 사용한 프레젠테이션 작성
모듈 3 – 전문 문서를 위한 Word (6시간)
- 전문 보고서와 제안서 작성 및 서식 지정
- 일관성과 효율성을 위한 템플릿과 스타일
- 쓰기, 요약, 편집을 위한 Copilot 통합
- 협업 도구와 버전 관리
- 리더십 보고서 작성 실습 연습
모듈 4 – 생산성과 팀 조직을 위한 Outlook (6시간)
- 고급 이메일 및 캘린더 관리 기술
- 효율성을 위한 규칙, 카테고리, 자동화
- 초안 작성, 요약, 일정 조정을 위한 Copilot
- Teams 및 기타 Microsoft 365 도구와의 통합
- 리더십 중심 시간 관리 전략
모듈 5 – 리더십 워크플로를 위한 Microsoft Copilot (6시간)
- Microsoft 365 전반에 걸친 Copilot 개요
- Excel, Word, Outlook에서의 AI 지원 작업 자동화
- 효과적인 Copilot 사용을 위한 프롬프트 설계
- AI 윤리 및 데이터 보안 최선의 관행
- 실습 연습: Copilot을 사용한 워크플로 생성
요약 및 다음 단계
요건
- 기본 데이터 관리 및 보고 개념 이해
- Excel, Word, PowerPoint, Outlook 등의 Microsoft Office 애플리케이션 사용 경험
- Teams 또는 OneDrive와 같은 온라인 협업 도구에 대한熟悉
대상자
- Microsoft 365 및 Copilot을 사용하여 생산성을 향상시키고자 하는 관리자와 의사 결정자
- 리더십을 위한 보고서, 프레젠테이션, 문서 준비를 담당하는 전문가
- 자동화와 전략적 인사이트 생성을 위해 AI 도구 활용을 목표로 하는 팀
회원 평가 (5)
**Course Outline****Course Title:** Mastering Mobile App Development**Duration:** 12 weeks**Scope of Material**This course covers the essentials of mobile app development, focusing on both iOS and Android platforms. Students will learn to design, develop, and deploy mobile applications using industry-standard tools and frameworks. The curriculum includes an introduction to mobile app architecture, user interface design, and backend integration. Students will gain hands-on experience with Xcode, Swift, Android Studio, Java, and Kotlin. Additionally, the course will cover best practices for app performance, security, and user experience.**Course Objectives**- Understand the fundamentals of mobile app development for iOS and Android.- Design and implement user interfaces for mobile applications.- Develop and integrate backend services for mobile apps.- Utilize version control systems like Git for collaborative development.- Apply best practices for app performance, security, and user experience.- Deploy mobile applications to the App Store and Google Play.**Course Outline****Week 1-2: Introduction to Mobile App Development**- Overview of mobile app development ecosystem- Setting up the development environment- Introduction to Xcode and Swift for iOS development- Introduction to Android Studio and Java/Kotlin for Android development**Week 3-4: Mobile App Architecture**- Understanding mobile app architecture patterns- Model-View-Controller (MVC) and Model-View-ViewModel (MVVM) architectures- Designing scalable and maintainable mobile applications**Week 5-6: User Interface Design**- Principles of mobile UI/UX design- Creating intuitive and user-friendly interfaces- Using Storyboard and Auto Layout in Xcode- Using XML layouts and ConstraintLayout in Android Studio**Week 7-8: Backend Integration**- Introduction to RESTful APIs and web services- Integrating backend services with mobile applications- Working with JSON and XML data formats- Implementing authentication and authorization**Week 9-10: Advanced Topics**- Working with databases: SQLite, Room, and Core Data- Implementing push notifications- Utilizing third-party libraries and SDKs- Implementing in-app purchases and advertisements**Week 11: Performance and Security**- Optimizing app performance- Ensuring app security and data protection- Conducting thorough testing and debugging**Week 12: Deployment and Best Practices**- Preparing apps for deployment to the App Store and Google Play- Following best practices for app store optimization (ASO)- Monitoring app performance and user feedback- Iterating and updating mobile applications
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
코스 - Word dla zaawansowanych
기계 번역됨
**Course Title: Introduction to Big Data and Hadoop****Course Duration:** 40 hours**Course Description:**This course provides an in-depth overview of big data concepts and the Hadoop ecosystem. Participants will gain hands-on experience with Hadoop tools and frameworks, enabling them to process and analyze large datasets efficiently.**Course Outline:****Module 1: Introduction to Big Data**- Understanding Big Data - Definition and characteristics - Importance of Big Data in today's world - Examples of Big Data use cases- Big Data Challenges - Volume, Velocity, Variety, Veracity - Traditional vs. Big Data processing- Big Data Technologies - Overview of Hadoop, Spark, and other tools - Big Data ecosystem components**Module 2: Introduction to Hadoop**- What is Hadoop? - History and evolution - Core components: HDFS, MapReduce, YARN- Hadoop Architecture - Cluster setup and configuration - Data storage and processing workflows- Setting Up Hadoop - Installation on Linux and Windows - Configuration files and settings**Module 3: Hadoop Distributed File System (HDFS)**- Introduction to HDFS - Architecture and components - Data replication and fault tolerance- HDFS Operations - File operations: read, write, delete - Directory operations: create, delete, list- HDFS Best Practices - Data organization and management - Performance tuning and optimization**Module 4: MapReduce Programming**- Introduction to MapReduce - Concepts and workflow - MapReduce programming model- Writing MapReduce Programs - Setting up the development environment - Writing and running MapReduce jobs- MapReduce Examples - Word count example - Custom MapReduce programs**Module 5: Advanced Hadoop Ecosystem**- Apache Hive - Introduction and architecture - Querying data with HiveQL- Apache Pig - Introduction and architecture - Data processing with Pig Latin- Apache HBase - Introduction and architecture - NoSQL database concepts- Apache Zookeeper - Introduction and architecture - Coordination and management services- Apache Sqoop - Introduction and architecture - Data import/export between Hadoop and relational databases- Apache Flume - Introduction and architecture - Data ingestion and streaming**Module 6: Hadoop Administration**- Hadoop Cluster Management - Cluster setup and configuration - Monitoring and maintenance- Security in Hadoop - Authentication and authorization - Data encryption and security best practices- Performance Tuning - Optimizing Hadoop performance - Troubleshooting common issues**Module 7: Real-world Use Cases and Projects**- Case Studies - Real-world applications of Big Data and Hadoop - Success stories and best practices- Hands-on Projects - Designing and implementing Big Data solutions - Working on real-world datasets**Assessment and Certification:**- Participants will be assessed through quizzes, assignments, and a final project.- Upon successful completion, participants will receive a certificate of achievement.
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
코스 - MS Word - poziom podstawowy
기계 번역됨
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
코스 - Advanced Slide Design in PowerPoint
이미지 형식 및 템플릿에 관한 몇 가지 작은 요령 - 매우 유용합니다 :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
코스 - Advanced MS PowerPoint
기계 번역됨
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.