3812 Office Skills courses in Dunfermline delivered Online

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

The Admin, Secretarial & PA - Mega Bundle online course is a comprehensive and tailored program designed to enhance your skills and knowledge in the field of administrative support. Whether you're aspiring to become a professional administrator, a skilled secretary, or a proficient personal assistant, this course provides you with the essential tools and techniques to excel in your role. This Mega Bundle course offers a wide range of modules that cover various aspects of administrative responsibilities. You'll delve into the fundamentals of office management, including organizing schedules, coordinating meetings, and maintaining effective communication channels. Additionally, you'll learn vital skills such as record-keeping, data management, and file organization, ensuring efficiency and productivity in your daily tasks. The course also focuses on honing your interpersonal and communication skills, as these are crucial in providing exceptional support to executives and teams. You'll gain insights into effective communication strategies, professional etiquette, and how to handle challenging situations with tact and diplomacy. Moreover, the Admin, Secretarial & PA - Mega Bundle online course goes beyond the traditional administrative roles by incorporating modules on project management, event planning, and even digital marketing. This allows you to expand your skill set and become a valuable asset in today's fast-paced and dynamic work environments. As an online course, it offers the flexibility to learn at your own pace and convenience. You can access the course materials from anywhere, at any time, making it ideal for busy professionals or individuals seeking to upgrade their skills while juggling other commitments. Upon completion of the Admin, Secretarial & PA - Mega Bundle online course, you'll have gained a comprehensive understanding of the administrative field, acquired practical skills, and developed the confidence to excel in your chosen career path. Whether you're looking to start a new career or enhance your existing role, this course provides the knowledge and tools necessary to thrive in the world of administration and support. Contains: Admin, PA and Secretarial Certification PA Telephone Skills Certification Touch Typing and Shorthand Executive Admin & PA Certification Level 3

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

FREE Certification:QLS Endorsed + CPD Accredited | Instant Access | Round-the-Clock Tutor Support | All-Inclusive Cost

Level 7 Diploma(FREE QLS Endorsed Certificate)| 11 CPD Courses+11 PDF Certificates| 150 CPD Points|CPD & CiQ Accredited

Level 4 Diploma (FREE QLS Endorsed Certificate) | 11 CPD Courses & PDF Certificates | 225 CPD Points | CPD Accredited

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our 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. Tailored in company 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. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Requirements Requirements 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 Career path 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

Get ready for an exceptional online learning experience with the Executive Management, Mini MBA, Office Administration & Legal Secretary bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Executive Management, Mini MBA, Office Administration & Legal Secretary is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Executive Management package has something for everyone. As part of the Executive Management, Mini MBA, Office Administration & Legal Secretary package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Executive Management bundle to confidently navigate your career path or personal development journey. Enrol our Executive Management bundletoday and start your career growth! This Executive Management Bundle Comprises the Following CPD Accredited Courses: Developing Strategic Executive Management Administrative Management Mini MBA Office Administration Legal Secretary and Office Skills Diploma Business Law Online Meeting Management Diary Management Document Control Minute Taking Course Personal Assistant Business Writing Touch Typing Essentials Workplace Confidentiality Mastering Organizational Chaos Communication Skills Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Learning Outcome: By completing the Executive Management, Mini MBA, Office Administration & Legal Secretary course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Executive Management Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Executive Management Bundle. Build a strong knowledge base in your chosen course via the Executive Management Bundle. Benefit from the flexibility and convenience of online learning. With the Executive Management package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Executive Management, Mini MBA, Office Administration & Legal Secretary, a rich anthology of 15 diverse courses. Each course in the Executive Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Executive Management, Mini MBA, Office Administration & Legal Secretary bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Executive Management, Mini MBA, Office Administration & Legal Secretary bundle offers you the flexibility and convenience to learn at your own pace. Make the Executive Management package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Executive Management, Mini MBA, Office Administration & Legal Secretary bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Executive Management, Mini MBA, Office Administration & Legal Secretary course. Career path Unleash your potential with the Executive Management, Mini MBA, Office Administration & Legal Secretarybundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Executive Management bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Duration 1 Days 6 CPD hours This course is intended for The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones. Overview #NAME? This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates. 1 - An Introduction to Power Automate What is Microsoft Power Automate? The benefits of automation How to get to Power Automate Lab 1: Setup your tenant Setup Office 365 Download Course Files Customise your App Launcher Create accounts for colleagues After completing this module, students will be able to: Know what Microsoft Power Automate is The Benefits of using Power Automate to automate processes How to access a Power Automate 2 - Getting Started with Power Automate Using Power Automate templates Navigating in Power Automate Editing a Power Automate Publish and trigger a Power Automate Turn off or delete a Power Automate Lab 1: Building processes in Office 365 Create a Team with a channel Build an absence business process Testing the absence process Optional: Create Feedback Form Optional: Power Automate to Notify of Bad Ratings Optional: Test your Form and Power Automate After completing this module, students will be able to: How to use Power Automate tempaltes How to navigate around Power Automate How to edit Power Automates How to publish and trigger Power Automates How to turn off or delete Power Automates 3 - Power Automate Logic Adding conditions Designing switches Using apply to each Configuring do until logic Adding a scope Lab 1: Scheduling documentation reviews Setup a policy library in SharePoint Design a policy review schedule Testing the policy review process Optional: Notify if a file nears review After completing this module, students will be able to: How to add condtions in a Power Automate How to design switches for a Power Automate How to use apply to each How to configure do until logic How to add a scope 4 - Integration Standard and premium connectors Connecting to web services Using Power Automate with on-premises data Lab 1: Using Power Automate and SQL to Review Sales Create a new orders list Designing the price check process Testing the price check process Optional: Update with managers After completing this module, students will be able to: How to use Standard and Premium connectors How to connect to web services How to using Power Automate with on-premises data 5 - The Mobile App Downloading the mobile app Signing in and account management Building and managing Power Automates Creating buttons Feeds and approvals Lab 1: Optional: Using the Power Automate mobile app Setting up the Power Automate mobile app Create a new Power Automate in the mobile app Using Power Automate buttons in the app Uninstall the Power Automate mobile app After completing this module, students will be able to: How to download the mobile app How to sign into the mobile app How to build and manage Power Automates in the mobile app How to create buttons in the mobile app How to feed and use approvals in the mobile app 6 - Administration and Maintenance Maintaining a Power Automate View history and analytics Sharing a Power Automate Export and import Power Automates Office 365 administration for Power Automate Environments Data policies Data integration Lab 1: Maintaining your Power Automates Share a Power Automate with a colleague Disabling an active Power Automate Deleting a Power Automate After completing this module, students will be able to: How to maintain a Power Automate How to view history and analytics for a Power Automate How to share a Power Automate How to export and import Power Automates How to administrate a Power Automate in Office 365 How to use data policies in a Power Automate How to use data integration in a Power Automate

***24 Hour Limited Time Flash Sale*** Executive PA, Legal Secretary & Communication- 3 QLS Course Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Navigate through the corporate world with finesse and precision with our 'Executive PA, Legal Secretary & Communication' course bundle. This comprehensive suite of 8 courses unravels the many facets of corporate operations and communication. Take advantage of the 3 QLS-endorsed courses that masterfully delve into the roles of an Executive PA, a Legal Secretary, and the art of Effective Communication Skills - each one equipped with a hardcopy certificate. The journey doesn't stop there! Amplify your theoretical understanding with our 5 CPD QS accredited courses in Office Administration, Document Control, Legal Office Administration, Online Meeting Management, and Business Writing. Each course has been curated to enhance your corporate skillset and set you on the path to success. Equip yourself with our 'Executive PA, Legal Secretary & Communication' course bundle and rise above the competition! Key Features of the Executive PA, Legal Secretary & Communication- 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Executive PA, Legal Secretary & Communication- 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Executive PA QLS Course 02: Legal Secretary QLS Course 03: Effective Communication Skills 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Office Administration Course 02: Document Control Course 03: Legal Office Administration Course 04: Online Meeting Management Course 05: Business Writing In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Executive PA, Legal Secretary & Communication- 3 QLS Course courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the roles and responsibilities of an Executive PA and a Legal Secretary. Enhance your effective communication skills. Gain an understanding of office administration and document control procedures. Learn about legal office administration tasks. Develop skills in online meeting management and business writing. Understand the principles of professional document control. Develop strategies for efficient online meeting management. The 'Executive PA, Legal Secretary & Communication' course bundle offers a comprehensive theoretical foundation on crucial corporate roles and communication techniques. This bundle is designed to provide a deep understanding of the responsibilities of an Executive PA and a Legal Secretary. Moreover, it offers insight into effective communication skills that can enhance your workplace interactions. The course bundle also comprises CPD QS accredited courses on Office Administration, Document Control, Legal Office Administration, Online Meeting Management, and Business Writing. These courses will equip you with a deeper understanding of office procedures, document management, online meetings, and professional writing. By completing this bundle, you'll be well-prepared to excel in your professional life. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals looking to work as an Executive PA or Legal Secretary. Those keen on improving their communication skills. Office Administrators aiming to enhance their skills. Professionals looking to better manage online meetings and business writing. Career path Executive PA: (£25,000 - £35,000) Legal Secretary: (£20,000 - £30,000) Office Administrator: (£18,000 - £24,000) Document Controller: (£20,000 - £30,000) Legal Office Administrator: (£22,000 - £32,000) Business Writer: (£20,000 - £35,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included