MICROSOFT OFFICE
In this course; you'll learn how to use Word 2019 to create and edit simple documents, format document, add tables and lists, add design elements and layout options and proof documents. Microsoft Word 2019 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun.
Course Objectives
In this course; you will learn fundamental Word skills. You will: Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application. Format text and paragraphs. Perform repetitive operations efficiently using tools such as Find and Replace, Format Printer and Styles. Enhance lists by sorting, renumbering, and customising list styles. Create and format tables. Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art. Format the overall appearance of a page through page borders and colours, watermarks, headers and footers, and page layout. Use Word features to help identify and correct problems with spelling, grammar, readability and accessibility.
Creating professional-looking documents can give and your organisation a competitive edge. Implementing time-saving features such as document templates and automated mailings can help reduce expenses. Mastering these techniques will make you a valued employee in your organisation.
Course Objectives
In this course; you will learn to create and modify complex documents and use tools that allow you to customize those documents. You will: Organize content using tables and charts. Customize formats using styles and themes. Insert content using Quick Parts. Use templates to automate document formatting. Control the flow of a document. Simplify and manage long documents. Use mail merge to create letters, envelopes, and labels.
Microsoft Word enables you to do far more than simple word processing. Word includes advanced image manipulation tool, collaboration features, and tools to automate document production.
Course Objectives
In this course; you will learn to use the advanced capabilities of Word 2019. You will: Use images in a document. Create custom graphic elements. Collaborate on documents. Add reference marks and notes. Secure a document. Create and manipulate forms. Create macros to automate tasks.
This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Excel can help you organize, calculate, analyse, revise, update, and present your data in ways that will help the decision makers in you orgaization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialised software.
Course Objectives
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organization. You will: Get started with Microsoft Office Excel 2019. Perform calculations. Modify a worksheet. Format a worksheet. Print workbooks. Manage workbooks.
This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019: Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence. The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organisation that is able to complete at high at a high level.
Course Objectives
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organisational decisions. You will: Work with functions, Works with lists, Analyse data, Visualize data with charts, Use PivotTables and PivotCharts.
This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel 2019: Level 1 and Microsoft Office Excel Level 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you neeed from the vast amounts of data your organisation generates.
Course Objectives
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will: Work with multiple worksheets and workbooks, Share and protect workbooks, Automate workbook functionality, Use Lookup functions and formula auditing, Forecast data, Create Sparklines and map data.
Microsoft PowerPoint has become an industry standard for efficiently communicating information to an assembled group of people. PowerPoint is full of features which allow you to present information in a concise and exciting format. Most presenters, however, only scratch the surfaces of all that is available when creating a PowerPoint presentation.
Course Objectives
Upon completing this course, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphic, and animations. You will: Identify the basic features and functions of PowerPoint 2019, Develop a PowerPoint presentation, Perform advanced text editing operations, Add graphical elements to your presentation, Modify objects in your presentation, Add tables to your presentation, Add charts to your presentation, Prepare to deliver your presentation.
In this course, students learn different tools and features within PowerPoint that will help them deliver content in an informative and memorable manner. Student will create presentation that not only stand out, but also don't consume all of their time.
Course Objectives
Upon completing this course, you will be able to customize the PowerPoint 2019 application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations. You will modify the PowerPoint environment, Customise design templates, Add SmartArt and math equations to a presentation, Work with multimedia and animations. Collaborate on a presentation, Customise a slide show, Secure and distribute a presentation.
In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.
Course Objectives
In this course, you will use Outlook to manage your email communications, including composing, reading, and responding to emails; schedule appointments and meetings; manage contact information; schedule tasks and create notes; customize message response options; and organize your mail.
- Navigate Outlook to read and respond to email.
- Use the Address Book and format and spell check new messages.
- Attach files and insert illustrations to messages.
- Customize read and response options.
- Use flags, categories, and folders to organize messages.
- Create and work with Contacts.
- Create appointments and schedule meetings in Calendar.
- Create and work with Tasks and Notes.
In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you'll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.
Course Objectives
In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings.
- Insert objects in messages, and modify properties and global options.
- Organize, search, and manage messages.
- Protect your mailbox and manage its size.
- Use rules and Quick Steps to automate message management.
- Work with advanced calendar settings.
- Import and forward contacts.
- Manage activities by assigning tasks to others.
- Delegate access to and share Outlook items with others.
- Archive and back up Outlook items using data files.
Microsoft Access is an Information management tool that helps you store information for reference, reporting and analysis. Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.As relational database software, Microsoft Access allows small teams and individuals to easily organize and report on business data.
Access is a file-based desktop application that enables organizations to manage and leverage data. The relational database also includes tools that allow you to quickly build database-bound forms and reports. This instructor led 4 day Microsoft Access courses offered by PRONETA will teach you how to:
- Create, design and encrypt Access databases
- Build and work with Access tables, relationships, keys and constraints
- Query data
- Manage and design interfaces with Access Forms
- Produce basic to advanced reports
- Automate tasks, procedures and functions with Macros and VBA
- Customize Access configuration options
Course Objectives
In this course, you will create and manage an Access 2019 database. You will learn how to:
- Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
- Organize and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
- Customize a form layout to improve usability and efficiency of data entry.
- Share data across applications.• Use macros to improve user interface design.
- Use VBA to enhance tasks.
- Organize data into appropriate tables to ensure data dependency and minimize redundancy.
- Lock down and prepare a database for distribution to multiple users.
- Create and modify a database switchboard and set the startup options.
- Database management
- Advanced form design
- Packaging a database
- Encrypting a database
- Preparing a database for multi-user access
Managing projects with microsoft project
Microsoft Project is a leading project management software that enables managers and individuals to achieve project outcomes faster and more efficiently. It is a project management solution designed for organisations of all sizes. It features project scheduling, which allows project managers to define project tasks, assign them to the team, and track in-progress assignments. Microsoft Project also features project budgeting, which helps managers estimate the costs for the entire span of a project. Managers can also perform “Earned Value Analytics” and estimate the cost performance of their projects. The software provides built in templates, scheduling tools, and access across devices increase productivity for project managers. Microsoft Project provides interactive dashboards and reporting functionalities. The project managers can also prepare insightful reports and make decisions about project execution and staffing levels.
With Microsoft Project training from PRONETA, you’ll learn how to analyse resources, manage timelines and measure progress at a glance. Discover how to use any version of Microsoft Project to oversee individual tasks, submit time sheets, flag issues and collaborate with team members.
Microsoft Project training at PRONETA will also enable you to:
- Create a robust project plan
- Manage and configure tasks in Project
- Better understand and allocate resources
- Integrate data with other Microsoft applications
- Track costs
- View project information visually
About Microsoft Project
Microsoft Project helps individuals and businesses deliver high-quality projects on time and within budget. With Microsoft Project, businesses and individuals can adjust and manage projects in real time.
The program helps teams plan and prioritize tasks, assign resources and track progress and budgets to complete projects more efficiently.
Who Should Attend
- This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage and customize those plans through the implementation stage of a project.
- Everyone involved in project management with the view of planning and prioritizing tasks, assigning resources and tracking progress and budgets to complete projects more efficiently, which makes the ultimate difference between success and failure when completing a complex project.
Course Overview
Information Security is one of the major areas of concern for both private and public entities today as they face threats to their critical infrastructure. Our IT Security Awareness training course has been developed to provide employers and employees with a general understanding of the threats to cyber/information security that they face, help them to recognize the threats and vulnerabilities to their company’s information assets, and respond to them appropriately including detailing the countermeasures that can be adopted. With the ever increasing demands and requirements to ensure your organization’s or clients' business data, information, and systems are secure, this course provides the right content designed to help you in your own practice to effectively fulfil the demands for securing your infrastructure
Course Objectives
This course focuses on the fundamentals of information security that are used in protecting both the information present in computer storage as well as information traveling over computer networks. Interest in information security has been spurred by the pervasive use of computer based applications such as information systems, databases, and the Internet. The ultimate objective of this course is to equip delegates with a sound knowledge of the fundamental principles of information security and to provide them with the expertise needed to analyse and evaluate information security problems.
The objectives of the course are as follows:
- Explain the challenges and scope of information security
- Understand the Importance of and the Benefits of Information Security
- The Importance of and the Benefits of Information Security
- Classification of Information Assets
- Threats, Vulnerabilities and Safeguards
- Overview of Asset Protection Mechanisms
- Information Systems Risk Management
- Information Systems Risk Management
- Information Security Policies
- The Organization’s Management of Security
- Organizational Policy, Standards and Procedures
- Information Security Governance
- Information Security Implementation
- Security Information Management
- Legal and Ethical Concepts in Information Security
BUSINESS INTELLIGENCE & DATA FORECASTING AND ANALYSIS
Dashboards provide at-a-glance views of KPIs (key performance indicators) relevant to a particular objective or business process (e.g. sales, marketing, human resources, or production). Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. Business Intelligence is a hot commodity in today’s world and dashboards are the most frequently used method of providing that information.
This Microsoft Excel Forecasting & Data Analysis course is aimed at people who want to expand their knowledge into forecasting and more specialised analytical functionality offered by Microsoft Excel. Engineers, accountants, business analysts, finance professionals, research professionals, marketing and sales, and general business professionals and staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliations, and analysis.
This program is designed for: Accountants, senior and junior accountants, business analysts, accounting and finance professionals, research professionals, marketing and sales, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliations, and analysis.
Charting with Microsoft Excel course is suitable for those with a working knowledge of Excel and familiarity of charts. At the end of this course you will have a greater understanding of charting concepts, shortcuts and fine tuning. You will learn more advanced techniques for chart layout tabs and chart formatting options & types. Armed with all of this you will have greater competence at producing more comprehensive Excel charts based on your working data.
Our Microsoft Excel Pivot Tables course is suitable for those with a basic working knowledge of Pivot Tables who want a greater understanding of the more sophisticated functions and features available.At the end of this course you will have a greater understanding of the functionality and potential of Pivot Tables. You will be able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage and add to the statistical analysis of your data, deal with varying data sources, automate, troubleshoot and utilise Pivoted data in many different contexts.