153 Office courses in Glasgow

OVERVIEW -------------------------------------------------------------------------------- This Course is specially designed to enhance communication skills and gain advanced skills in office management. It will help identify key features of the role and will navigate through all the components and techniques for operating an efficient support team. This course will update your interpersonal skills, communication skills and other skills required to have effective office management and gain advanced administrative skills.

FourSquare Training specialise in private, corporate Microsoft 365 courses delivered at your premises and tailored to your needs.

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

COMPLETE VBA PROGRAMMING TRAINING COURSE DESCRIPTION This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. WHAT WILL YOU LEARN * Record, write and run macros. * Work with VBA Editor. * Use the huge library of built-in functions. * Create simple dialog boxes and complex forms. * Customize Word, Excel, PowerPoint, Outlook, and Access. * Program the Office 2016 ribbon. COMPLETE VBA PROGRAMMING TRAINING COURSE DETAILS * Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. * Prerequisites: None. * Duration 5 days COMPLETE VBA PROGRAMMING TRAINING COURSE CONTENTS * Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. * Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. * Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. * Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. * Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. * Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.

Price £750 inc VAT Finance options In Company training - £750 for groups of up to 8 delegates. Discounts for Nonprofits/Charities...  Study method On-site Duration 2 days, Full-time Qualification No formal qualification Certificates Certificate of completion - Free Additional info Tutor is available to students -------------------------------------------------------------------------------- Course Objectives At the end of this course you will be able to: * Identify the components of the Microsoft Project environment * Create a new project plan * Create the project schedule * Use different views to analyse the project plan * Create, allocate and manage resources in a project plan * Finalise a project plan * Track progress * View and report project plan information ' 1 year email support service Customer Feedback * Very good course. Learnt a lot. Looking forward to the next level. * Alexandra - CIAL 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. * Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. -------------------------------------------------------------------------------- DESCRIPTION Introduction to Microsoft Project * Recap on project management concepts * Project environment overview * The 3 databases: Tasks, Resources and Assignments * Different ways of displaying the Project Plan * Access Help Creating a Project Plan * Create a New Project Plan * Project Information * Create and apply the project calendar * Defining recurring exceptions to the calendar * Defining the calendar's work weeks * Create the Summary tasks * Create the Work Breakdown Structure Task creation and scheduling * Exploring the Entry Table and its fields * Task editing and the Task Information window * Task Durations * Defining Milestones * Manual Scheduling vs Automatic Scheduling * Changing the Task's Calendar * Create a split in a Task * Create Task Relationships * Adding Lag or Lead to a Relationship * Identifying the Critical Path * Adding Constraints and Deadlines to Tasks * Create Recurring Activities * Adding Notes and links to Tasks Managing Resources * Exploring the Entry Table and its fields * Resource editing and the Resource Information window * Resource Types * Fixed Costs vs Variable Costs * Adding Resource Costs * Defining when costs accrue * Changing the Resource Calendar and Availability * Project calendar vs Resource and Task Calendar * Assigning Resources to Tasks * Effort Driven Scheduling * Resolving Resource Overallocation Tracking the Project Progress * Setting a Project Baseline * Entering Actuals * Different ways of viewing the Progress * Checking if the Project is on track Viewing and Reporting Project Detail * Adding Tasks to the Timeline and sharing it * Modifying the Timescale and Zoom level * Formatting the Gantt View * Filtering and Grouping Tasks * Print and Troubleshoot the Gantt View * Using built-in Reports in Microsoft Project WHO IS THIS COURSE FOR? 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 these project plans. -------------------------------------------------------------------------------- REQUIREMENTS General knowledge of the Windows OS -------------------------------------------------------------------------------- CAREER PATH Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Remote working is on the increase. However, managing a remote team is not always the same as managing a traditional, single-site office-based team.

PC FUNDAMENTALS TRAINING COURSE DESCRIPTION A basic introductory course for those who have never worked with PCs before. The principle target audience is for those who will become PC support people. WHAT WILL YOU LEARN * Cable PCs. * Perform preventive maintenance on PCs * Run Windows and start applications. * Use Microsoft Office applications. * Customise Windows. PC FUNDAMENTALS TRAINING COURSE DETAILS * Who will benefit: Anyone new to PCs. * Prerequisites: None. * Duration 3 days PC FUNDAMENTALS TRAINING COURSE CONTENTS * PC hardware Overview of components inside a PC, cabling up a PC, preventive maintenance, cleaning mice, hardware screen controls, booting a PC. * Windows overview Versions of Windows, Starting Windows, logging on, shutting down. * Using Windows The desktop, the start menu and submenus, getting help, shutting down Windows, switching between applications, sizing and controlling windows, special keys on the keyboard. * Accessing files and folders Folders and files, Windows explorer, IE, creating, viewing and manipulating folders, creating, viewing and manipulating files, permissions, bits and bytes, the recycle bin, undeleting and undoing, formatting floppy disks, using floppy disks * DOS Accessing DOS, basic DOS commands, drives. * Microsoft Office Word documents, Excel spreadsheets, emails, browsing the Internet, printing files, managing print queues. * Printing Overview, printing, properties * Customisation Customising the task bar, customising the start menu. The control panel, mouse and display properties, Desktop settings, setting the date and time. * Networking overview Workgroups and domains, Accessing file and print resources

Mental Health First Aiders (MHFAiders®) are vital to helping boost employee wellbeing as we adjust to a completely changed workplace environment.

COMPLETE VB.NET TRAINING COURSE DESCRIPTION A hands on introduction to programming in Visual BASIC .Net. WHAT WILL YOU LEARN * Build Visual BASIC applications. * Build simple components * Debug Visual BASIC programs. * Examine existing code and determine its function. COMPLETE VB.NET TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to program in Visual BASIC. Anyone wishing to build Windows based applications. * Prerequisites: None although experience in another high level language would be useful. * Duration 5 days COMPLETE VB.NET TRAINING COURSE CONTENTS * Writing your first program Visual Studio, forms designer, running VB programs, the UI, properties, writing the code. * Toolbox Controls Basic use, input controls, ActiveX controls. * Menus and Dialog Boxes Menus, Dialog Box controls, event procedures. * Visual Basic .NET variables and operators Variables, I/O, data types, constants, operators, Math Methods, precedence. * Decision Structures and Loops and Timers Event-Driven programming, If…Then, Select Case, For…Next Loops, Timer Control. * Debugging Visual Basic .NET Programs Break Mode, watch & command windows. * Structured Error Handling Try...Catch, Finally, Err Object, retry periods. * Modules and Procedures Standard modules, public variables, procedures. * Arrays and Collections to Manage Data Fixed-Size & dynamic Arrays, ReDim Preserve, object collections, Controls Collection. * Text Files and String Processing Text Box object, Text String methods, sorting. * Automating Office Applications Application objects, automation in VB, the Object Browser, the Process Component. * Deploying Visual Basic .NET Applications Planning a deployment, ways to deploy an application, deployment projects, options. * Managing Windows Forms Forms, positioning, manipulation, adding controls, organizing controls, Startup Object. * Adding Graphics and Animation Effects System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency. * Inheriting Forms and Creating Base Classes Inheriting forms, inheritance picker, base classes and inheritance, classes in projects. * Working with Printers PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes. * Database programming with ADO.NET Databases, ADO.NET, Data Adapters, Datasets, Bound & Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database. * Displaying HTML Documents Using IE IE Object, Internet Controls, IE Events. * Web Forms for Interactive Web Applications ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.

MYSQL SERVER ADMINS TRAINING COURSE DESCRIPTION This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. WHAT WILL YOU LEARN * Use MySQL Workbench. * Install and configure a MySQL Server . * Administer and tune a MySQL server. * Configure log files and interpret error messages.. * Secure the Server. * Administer a replication topology. MYSQL SERVER ADMIN TRAINING COURSE DETAILS * Who will benefit: Database administrators, Database developers and Technical consultants. * Prerequisites: Introduction to MySQL * Duration 5 days MYSQL SERVER ADMIN TRAINING COURSE CONTENTS * Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application * SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries * Build a database application Application components Create an application Create an application from a spreadsheet * Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats * Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file * Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms * Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values * Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons * Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches * Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults * Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees * State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development * Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files * Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action * Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application * Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection * Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects * Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace * Utility programs Import and export data Generate DDL statements View objects reports