Overview

COURSE OBJECTIVESThe course aims to provide in-depth knowledge on how to use this extraordinary tool for business productivity and much more. Knowing how to use Office 365 is an advantage when it comes to finding a job in any type of company. But not only that. It can also be used by groups of students, athletes or other groups to always be in contact with each other and be able to collaborate, even remotely, in chat, video conference, sharing files to work together.We will also see how to use two interesting Microsoft 365 applications: Power BI for data analysis and modeling and PowerApps for managing tickets remotely.Both, like all other Microsoft 365 applications, assume knowledge of account administration in terms of who can do what.________________________RESOURCESEbooks- 172 pages ebook (4 chapters) on the Global Administrator of the Microsoft 365 account (figure, responsibilities, powers, knowledge to cover the role in the company. Screenshots of the index in preview in section 2);- 265-page ebook (5 chapters) on the Share Point Administrator (the figure, role and professional opportunities for one of the key figures in the administration of the Microsoft 365 account (see preview index screenshots);- 500-page manual on Power BI and DAX language (measures and calculated columns). Everything you need to know to use Power BI to 100% of its informative potential with data analysis/modeling. Detailed illustrations of DAX expressions (see preview screenshots in section 3);- 206 pages ebook (10 chapters) on the types of APPs that can be developed in PowerApps (Canvas, Model-Driven and Portals. Screenshots of the index in preview in section 4);- Ebook of 1670 pages (26 chapters) on the professional use of the PC. ICDL Modules 1 and 2: European driving licence certification e-skills (see the list of chapters at the bottom of this presentation. Screenshots index in preview in the relevant section).- 130 NAVIGABLE POWER POINT SLIDES TO SUPPORT VIDEO LESSONSLots of screenshots and comments. Downloadable.One-click navigable with handy indexes for apps, sections, and topics.On each slide there is a link to return to the topic, the section, the APP index, the general index.See preview SCREENSHOTS in the dedicated section.- 1880 Multiple choice quizzes with score return and explanation of correct answers**See full list of quiz topics at the bottom of this presentation. You can take an open quiz in the preview section.- Two Microsoft Access-licensed software to sync with Power BIa) COURSE MANAGEMENT: training organisations, cultural and sports associations: courses, students, teachers, course registers; face-to-face, distance and videoconference courses. Specific environment for HACCP courses.b) COMPLETE MANAGEMENT OF THE COMPANY AND THE ISO 9001 QUALITY SYSTEM.It's open in the structure, and you can customize the masks and reports in your language.Environments:1. Management control: fixed costs, variable costs and break-even points;2. Supplier management: personal data, invoices, performance evaluation;3. Customer management: customer files, invoices, satisfaction surveys, complaint management;4. Management of invoicing: stock to be invoiced, VAT balance, cash flow with the possibility of simulation on day "N";5. Warehouse management: inbound and outbound movements, delivery notes, value and stock;6. Human resources management: personal data of employees, functions, hourly wages, attendance register;7. Management of orders and quotes: from customers and suppliers;8. Management of the ISO 9001 quality system: inspection audits, improvement projects, preventive actions, quality plans, non-conformities, registrations and their revisions, management review, performance indicators, SWOT analysis, calibration sheet of measuring and precision instruments.________________________COURSE PROGRAM1. INTRODUCTION TO MICROSOFT 365A world of applications made to interact with each other for the sole purpose of increasing business productivity. More income for the same factors of production used or the same income using a smaller quantity.2. CREATE USERS, GUESTS, CONTACTS, GROUPS, AND SHARED MAILBOXESWe'll look at how to build the architecture of the organization by first designing it, and then seeing how users and groups fit into it.Later, we'll cover all aspects related to setting up the Office 365 account:- The admin panel, which shows how to sign in, the list of active users, and the list of active Office 365 groups and teams in Teams- the creation of a user model that allows users to be quickly inserted who will absorb all its characteristics in terms of skills and assigned licenses;- Multiple user additions;- add simple contacts who will not be members or guests but can be included in email distribution lists and shared mailboxes;- Add guests with the assignment of groups, powers and the internal manager of the company;- the creation of a shared mail box in which members can have one or more powers at the same time: full access to read and manage, send as and send on behalf of.3. THE FIRST-LEVEL PERMIT SYSTEM. ACCOUNT ADMINISTRATORS- Macro categories of actions: create, exploit, share;- The figure of the administrator;- Criteria for assigning roles;- The global administrator of the account.4. Permissions administration system in SharepointWith 46 PowerPoint slides to support the video lessons and 500 QuizzesConcepts and basics; Permission levels; Setting advanced permissions; Create user groups; Basic concepts of sharing outside your organization; External sharing: anonymous users and authenticated users; External sharing: permission management; External sharing: separate lists and secondary site.5. Microsoft Planner: Perfect organization of company activities and projects90 navigable PowerPoint slides to support video lessons.How to use the application in planning to manage medical conference events and how it interacts with other applications.6. Data Analysis and Modeling with Microsoft Power BIWe will illustrate the steps to connect a data source that we already have (for example in Excel, Access, Share Point) to this environment so that we can model the data from a variety of visual angles with extreme simplicity (for example, it will create the pivots automatically to achieve which in Excel would take hours and hours of work):- database with 7230 ready-to-use DAX formulas (view screenshots);- Microsoft Access Course Management Software to Sync with Power BI. Lifetime License (view screenshots).7. Microsoft PowerApps. Customizing the Service Desk templateIllustration of the installation and commissioning process of an application model present in PowerApps Microsoft 365. The procedure is simple and with it you get an optimal management result that will give the possibility to remotely manage the external interventions of the company's employees.8. Microsoft Power AutomateWorkflow construction to collect data via Web into a Microsoft Share Point list when a Microsoft Forms form is filled out. In the example, the personal and bank details of the Hostesses and Stewards who will work at a medical conference are collected.9. Data Entry Profession whith Microsoft AcessIn this section of the course, you will learn the profession of data entry by inserting data into software developed in Microsoft Access that you can download. Master the art of form creation, enabling you to facilitate a streamlined and user-friendly data entry process. Understand the importance of input validation and how to implement it to maintain data integrity. Explore techniques for efficient batch data entry, including importing data from external sources.________________________1880 Multiple choice quizzes with score return and explanation of correct answersYou can take an open quiz in the preview section.Microsoft 365 Administration - 20 questions on each of these topics - 640 Quiz- Microsoft 365: a World of Productivity Apps;- Customizing and managing your Microsoft 365 environment;- Microsoft Authenticator Application Features;- Setting Up a Microsoft 365 Business Account Properly;- Microsoft 365 Admin Panel;- Creating Users;- Creating Groups;- Creating a User Template;- Adding Multiple Users;- Adding Contacts;- Adding Guests;- Creating Shared Mailboxes;- Microsoft 365 Account Administrator;- Admin Role Assignment Policies;- Billing Administrator;- Exchange Administrator;- Fabric Administrator;- Global Administrator;- Groups Administrator;- Support Administrator;- License Administrator;- Message Center Administrator;- Syncing Microsoft 365 Account Message Center with Microsoft Planner;- Office Apps Administrator;- Service Support Administrator;- Organizational Message Writer;- Power Platform Administrator;- Admin Reading Reports;- Share Point Administrator;- Teams Administrator;- User Administrator;- User Experience Success Manager.Microsoft Power BI - 20 questions on each of these topics - 600 Quiz- Power BI UI and Navigation;- Importing and connecting to data sources in Power BI;- Transforming and Cleaning Data with Power Query;- Data modeling and relationships;- Creating Calculated Measures and Columns with DAX;- Advanced use of DAX functions;- Visualizing data and choosing appropriate graphs;- Customizing and formatting views;- Creating interactive reports;- Using filters and slicers to segment data;- Manage and organize reports with workspaces;- Publishing and Sharing Reports to Power BI Service;- Secure data sharing and collaboration;- Creating and managing dashboards;- Using Power BI Mobile;- Power BI integration with other Microsoft applications;- Automating Workflows with Power Automate;- Using Power BI Embedded to Integrate Reports into Applications;- Data Security and Permissions Management;- Optimizing Report Performance;- Using Natural Language with Q & A;- Real-time data analysis;- Creating paginated reports with Power BI Report Builder;- Using Templates and Themes;- Localization and internationalization of reports;- Best practices for report design;- Using Power BI Desktop vs Power BI Service;- Understanding Power BI architecture and its components;- Troubleshooting common issues in Power BI;- How to stay up to date on new Power BI features.Microsoft PowerApps - 20 questions on each of these topics - 200 Quiz- Types of Apps: Understanding the difference between canvas, model-driven, and portal apps;- Use connectors to integrate data from various sources such as SharePoint, SQL Server, and others;- Familiarize yourself with the controls available to customize the user interface of your apps;- Learn to use formulas to add logic to your apps;- Create automated workflows with Power Automate to streamline your business processes;- Data Management: Manage data using Microsoft Dataverse;- Configure security settings to control access to apps;- Create and manage environments to organize apps, data, and users;- Analysis and Reporting: Use Power BI to analyze data and create interactive reports;- Customizing the app interface.Notions on professional use of the PC - 20 questions on each of these topics - 440 Quiz- Hardware;- Software;- CPU (processor);- RAM (Random Access Memory);- Applications running on PC;- PC Desktop and its Management;- The PC File Manager;- User interface;- Installing the Software;- Uninstalling Software from PC;- Creating file on PC;- Organizing Files on PC;- Using files search functions;- Back up data on PC;- Data Recovery on PC;- Local Area Network (LAN);- The Internet Connection;- Encryption files;- Email organization;- Online Communications Management;- Web Browser.

Skills

Reviews