This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document
This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts
There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups
Duration 1 Days 6 CPD hours This course is intended for Experienced Web Intelligence report creators and analysts upgrading from a previous version of SAP BusinessObjects Web Intelligence to SAP BusinessObjects Web Intelligence 4.1. In this course, participants will gain an understanding of the Deltas between Web Intelligence 3.1 and 4.1. Content Preview Data Ribbon Options Context Menus Drag-and-Drop functionality Application Modes -Data Mode -Reading Mode -Design Mode Freeze Columns New options in the formula editor Grouping Data New Predefined Cells Element Linking New Charting Engine Direct Connectivity to SAP BW BEx Queries
Duration 2 Days 12 CPD hours This course is intended for Application consultants, Business Analysts, Executives, Technology Consultants, Users Overview By the end of this course, students will be able to:Explain SAP LumiraCreate documents and acquire dataPrepare datasetsVisualize dataShare stories In this course, students will learn how to create stunning and interactive visualizations by choosing a rich library of visualization types, ranging from scatter plots, heat and geo maps to tag clouds, box plots and network charts. Course Outline Positioning and Overview of SAP Lumira Discovery Navigating the BI Launchpad Acquiring Data Enrich the Dataset Create Visualizations Create a Story Sharing Options Using the Lumira Discovery Formula Editor Additional Data Sources Data Mashups
Duration 5 Days 30 CPD hours This course is intended for NULL Overview Topics include: basic file manipulation; basic and advanced filesystem features; I/O redirection and pipes; text manipulation and regular expressions; managing jobs and processes; vi, the standard Unix editor; automating tasks with shell scripts; managing software; secure remote administration; and more. The GL120 is a challenging course that focuses on the fundamental tools and concepts of Linux and Unix. Students gain proficiency using the command line. Beginners develop a solid foundation in Unix, while advanced users discover patterns and fill in gaps in their knowledge. Like all Guru Labs courses, the course material is designed to provide extensive hands-on experience. The GL120 is a challenging course that focuses on the fundamental tools and concepts of Linux and Unix. Students gain proficiency using the command line. Beginners develop a solid foundation in Unix, while advanced users discover patterns and fill in gaps
Duration 2 Days 12 CPD hours This course is intended for This course is geared toward development, engineering, and operations staff. Students in this class should have some familiarity and comfort with the following: 1. Writing code (of just about any flavor) in a text editor 2. Working on the command line 3. Basic system administration ? installing packages, configuring those packages, starting service Overview Get started with Chef by taking Chef Essentials. It?s a two-day instructor-led course that covers all the basics. You?ll learn what it means to turn infrastructure into code so that you can automate the configuration, deployment and management of your servers. You?ll also learn about Chef Architecture and the set of tools included in the Chef Development Kit (ChefDK). Each of the core units includes hands-on exercises that will give you confidence in your new skills. At the end of the course, you?ll come away with a repo and the skills to start automating your own infrastructure. You?ll learn what it means to turn infrastructure into code so that you can automate the configuration, deployment and management of your Windows servers. IntroductionResourcesCookbooksOhaiTemplatesLabWorkstation installationSigning up for Managed ChefThe Chef serverCommunity cookbooksManaging multiple nodesRolesSearchEnvironmentsFurther resources
This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson
Duration 2 Days 12 CPD hours This two-day course provides students an opportunity to learn about the skills, tools, and knowledge needed to deploy iOS devices. Interactive discussions and hands-on exercises guide students through the configuration, management, and supervision of iOS devices. Students? knowledge and skills are tested and reinforced by working through real-world scenarios The Role of MDM, VPP, and DEP How to successfully deploy iOS devices Identify and respond to challenges when deploying and managing devices without MDM Apple IDs Explain what an Apple ID is and identify when it?s needed Security How security is relevant in the context of a given deployment scenario Design and implement a deployment solution for a given scenario DEP Devices Configure DEP registered devices for Over-the-Air Enrollment Configure and manage settings, apps, and content on user-owned and company-owned devicesPrerequisites Manual Configuration Explore the challenges and inconsistencies when manually configuring multiple devices. Creating Configuration profiles using Apple Configurator to view and edit a configuration profile. Learn how profiles ensure consistency across multiple devices Manage Settings The iOS MDM protocol How a MDM solution is used to configure and manage devices over-the-air with consistency and accountability Apps and Content Introduce and define VPP Assign apps and content to their user and then configure and test managed 'open in' functionality Company-Owned (Personalized and Shared) Configure settings to enable Over-the-Air Enrollment and supervision and learn how users can personalize company-owned devices. Configure and test shared (shared) device scenarios and how Apps and content are distributed to the devices Workshop Real-world deployment scenarios Design a deployment that meets your scenario?s needs
Duration 1 Days 6 CPD hours This course is intended for This course is intended for individuals who want to become more confident and relaxed when speaking in front of an audience. Overview Upon successful completion of this course, students will become more confident and relaxed in front of an audience which will translate into a successful speaking event. In this course, students will learn some basic public speaking skills, including in-depth information on developing an engaging program and delivering their presentation with power. Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives Identifying Your Audience Performing a Needs Analysis Creating an Audience Profile Identifying Key Questions and Concerns Creating a Basic Outline Outlining the Situation Identifying the Task That Had to Be Performed Listing the Actions You Took Revealing the Results Organizing the Program Making Organization Easy Organizational Methods Classifying and Categorizing Fleshing It Out Identifying Appropriate Sources Establishing Credibility The Importance of Citations Putting It All Together Writing Your Presentation Adding a Plan B Reviewing, Editing, and Rewriting Being Prepared Checking Out the Venue Gathering Materials A 24 Hour Checklist Overcoming Nervousness A Visit from the Boss Preparing Mentally Physical Relaxation Techniques Appearing Confident in Front of the Crowd Delivering Your Speech (I) Starting Off on the Right Foot Using Visual Aids Checking the Volume of Your Voice Delivering Your Speech (II) Adjusting on the Fly Gauging Whether Breaks Are Required Wrapping Up and Winding Down Questions and Answers Ground Rules Answering Questions That Sound Like an Attack Dealing with Complex Questions Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations