167 Print courses in Ewell

Microsoft Project White Belt® 2013 This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work. What you Will Learn You'll learn how to: Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views Configure essential elements of a new schedule Enter and modify a task list Set dependencies between tasks Create a basic resource list and generate assignments Format targeted areas of the Gantt Chart view Prepare the schedule for printing Getting Started Introductions Course objectives Course outline Navigating the User Interface and Views Navigate and use the Ribbon Use and customize the Quick Access Toolbar Modify general and display options Become familiar with major elements on the Project screen Navigate Gantt Chart, calendar, and network diagram views Search for a help topic Setting up a New Schedule Create new schedules Create a new schedule using existing information Enter and modify the schedule start date Enter and modify exception days in the calendar Entering, Modifying, and Outlining Task Data Enter, edit, correct, and clear information Enter unscheduled tasks Enter duration estimates for a single task or multiple tasks Organize tasks Set up a multi-level outline Add notes to tasks Creating Dependencies by Setting Links Identify a critical path in a simple schedule Understand how scheduling software calculates a critical path Describe dynamic schedules and dependencies Create links using various methods Display the critical path Entering and Assigning Resources Plan for resources Create a list of available resources Assign resources Formatting Gantt Chart View Format text and Gantt Chart bars Format a collection of items Configure print options

Why Choose Photoshop Basics to Fundamentals Training Course? Our Photoshop Basics to Fundamentals Training Course offers a strong skills in Adobe Photoshop, equipping with essential skills. Learn to use layers, selection tools, layer effects, layers, masking, photos, typography, filters, and color theory. Learn features for confident Photoshop usage. Course Link Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm Course Highlights: Master Advanced Photoshop Skills: Develop expertise in professional image editing, retouching, and manipulation techniques. Hands-on Creative Projects: Engage in practical exercises to enhance real-world design skills. Explore Special Effects: Dive into advanced topics like layer effects, filters, and blending modes for stunning visual creations. Typography and Design Mastery: Learn typography styles, layout design, and color theory for compelling compositions. Build a Professional Portfolio: Receive guidance on crafting a portfolio showcasing your Photoshop expertise. Job Opportunities: Graphic Designer: Create captivating visuals for print and digital media. Digital Artist: Craft digital artwork for various applications, from illustrations to ads. UI/UX Designer: Design user interfaces and experiences for websites and apps. Web Designer: Develop visually engaging websites with expertise in Photoshop. Marketing Content Creator: Produce marketing materials, including banners and social media visuals. Freelance Designer: Offer design services independently to diverse clients. Advertising Creative: Design impactful ad visuals for creative campaigns. Print Production Specialist: Prepare print-ready materials, ensuring high-quality results. Photography Post-Processing Specialist: Enhance and retouch photographs for professional use. Module 1: Interface and Preferences Familiarize with the Photoshop Interface Customize Panels and Toolbars to suit your workflow Explore Photoshop Preferences for optimal settings Discover different Photoshop CC Workspaces for various tasks Get started with essential Keyboard Shortcuts Module 2: Image File Formats Understand various image file formats, including PSD, JPEG, PNG, and PDF Explore File Compression and its impact on image quality Module 3: Creating a New Document Set dimensions and size for new documents Understand media units for precise design specifications Explore Color Profiles and their importance Save presets for quick document setups Module 4: Placing Images Learn about Embedded vs. Linked images Introduction to Smart Objects for non-destructive editing Master the Selection tool for precise image placement Module 5: Image Size and Resolution Save images in different formats and compression settings Learn about Image Size and Resolution for various output requirements Module 6: Layers Introduction Organize your work using Layer management Master layer tasks such as reordering, renaming, grouping, locking, and hiding Module 7: Selection Tools Explore various Selection Tools like Marquee, Magic Wand, Quick Selection, and Lasso Understand Inverse Selection and Deselect for efficient editing Module 8: Layer Effects Apply captivating Layer Effects like Drop Shadow, Stroke, and Outer Glow Save and clone Effects Styles for quick application Combine multiple effects for creative designs Module 9: Introduction to Shapes Utilize the Shapes tool for basic design elements Create Custom Shapes for unique designs Understand Color principles and use the Properties Panel for adjustments Master the Direct Selection tool for precise shape editing Create a basic poster using provided examples Module 10: Type and Typography Work with Type and explore the Character and Paragraph Panel Utilize Styles Panel for consistent text formatting Save favorite fonts for easy access Apply Effects and Layer Styles on Type for impactful typography Learn about Leading, Tracking, and Kerning for optimal text spacing Module 11: Colors Understand RGB vs. CMYK color modes Select colors using the Eyedropper tool Save colors as Swatches for reuse Create gradients using the Gradient Tool Module 12: Creating a Clipping Mask Master the concept of Clipping Masks and its usage Apply Clipping Masks to Type, Images, and Shapes Combine Layer Effects with Clipping Masks for creative designs Module 13: Introduction to Masking Understand Masking and its importance in image editing Utilize the Brush tool for creating masks Learn Masking shortcuts and use Gradient Mask for smooth transitions Module 14: Adjustment Layers Explore Color and Gradient Adjustment Layers for image enhancements Master Curves, Levels, and Hue/Saturation Adjustment Layers for precise color control Convert images to Black and White using Adjustment Layers Combine Adjustment Layer Masks for targeted edits Module 15: Image Touch Up Master various touch-up techniques, including Red Eye Removal, Spot Healing Brush, and Patch Tool Utilize Content Aware Removal for seamless object removal Restore an old photo using Clone Stamp and Dodge/Burn tools Improve portraits by removing blemishes and whitening teeth Module 16: Filters Introduction Understand Smart Objects and Filter usage for non-destructive editing Explore the Filters Gallery and experiment with Blur and Vantage filters Module 17: Blending Modes Introduction Master the concept of Blending Modes and their impact on layer overlays Understand different types of Blending Modes, including Darken, Lighten, and Overlay Master the art of working with layers in Adobe Photoshop. Skillfully utilize various selection tools for precise editing and manipulation. Apply captivating Layer Effects to enhance your designs and visuals. Understand the functionality of Adjustment Layers, Masking, and Clipping Masks for advanced editing and compositing. Acquire the techniques to touch up and restore photographs effectively. Explore typography techniques to create visually appealing text designs. Gain an introductory understanding of Filters and their creative applications. Grasp the principles of Color Theory and its practical application in design.

Affinity Publisher Training Course for Beginners. Online Affinity Training with live instructors or face to face onsite. Learn to create and design layouts for flyers, brochures, newsletters, marketing documents and business stationery.

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. 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

Learn the Basic PhotoshopTraining Course Learn retouching, layers, color, correction, shapes, and symbols. Delve into graphic design, photo editing, and digital art. From beginner to pro, gaining expertise in UX strategies, ensuring your websites are impactful and user-friendly. Click here for more info: Website Duration: 10 hours Approach: 1-on1 sessions and Personalized guidance. Schedule: Customize your schedule by booking a convenient hour, available from Monday to Saturday between 9 am and 7 pm. Module 1: Interface and Preferences Familiarize yourself with the Photoshop Interface Customize Panels and Toolbars to match your workflow Explore Photoshop Preferences to optimize settings Discover various Photoshop CC Workspaces tailored for different tasks Begin with essential Keyboard Shortcuts Module 2: Image File Formats Understand diverse image file formats such as PSD, JPEG, PNG, and PDF Delve into File Compression and its influence on image quality Module 3: Creating a New Document Set dimensions and size for new documents Grasp media units for accurate design specifications Explore Color Profiles and their significance Save presets for swift document setups Module 4: Placing Images Differentiate Embedded vs. Linked images Introduction to Smart Objects for non-destructive editing Master the Selection tool for precise image placement Module 5: Image Size and Resolution Save images using various formats and compression settings Understand Image Size and Resolution for diverse output needs Module 6: Layers Introduction Organize your work with Layer management Master layer tasks such as reordering, renaming, grouping, locking, and hiding Module 7: Selection Tools Explore Selection Tools like Marquee, Magic Wand, Quick Selection, and Lasso Grasp Inverse Selection and Deselect for efficient editing Module 8: Layer Effects Apply captivating Layer Effects such as Drop Shadow, Stroke, and Outer Glow Save and replicate Effects Styles for quick application Combine multiple effects for creative designs Module 9: Introduction to Shapes Utilize the Shapes tool for fundamental design elements Create Custom Shapes for unique designs Understand Color principles and use the Properties Panel for adjustments Master the Direct Selection tool for precise shape editing Create a basic poster using provided examples Module 10: Type and Typography Work with Type and explore the Character and Paragraph Panel Utilize Styles Panel for consistent text formatting Save favorite fonts for easy access Apply Effects and Layer Styles on Type for impactful typography Learn about Leading, Tracking, and Kerning for optimal text spacing Module 11: Colors Understand RGB vs. CMYK color modes Select colors using the Eyedropper tool Save colors as Swatches for reuse Create gradients using the Gradient Tool Module 12: Creating a Clipping Mask Master the concept of Clipping Masks and their application Apply Clipping Masks to Type, Images, and Shapes Combine Layer Effects with Clipping Masks for creative designs Module 13: Introduction to Masking Understand Masking and its importance in image editing Utilize the Brush tool for mask creation Learn Masking shortcuts and use Gradient Mask for smooth transitions Module 14: Adjustment Layers Explore Color and Gradient Adjustment Layers for image enhancements Master Curves, Levels, and Hue/Saturation Adjustment Layers for precise color control Convert images to Black and White using Adjustment Layers Combine Adjustment Layer Masks for targeted edits Module 15: Image Touch Up Master various touch-up techniques, including Red Eye Removal, Spot Healing Brush, and Patch Tool Utilize Content Aware Removal for seamless object removal Restore old photos using Clone Stamp and Dodge/Burn tools Enhance portraits by removing blemishes and whitening teeth Module 16: Filters Introduction Understand Smart Objects and Filter usage for non-destructive editing Explore the Filters Gallery and experiment with Blur and Vantage filters Module 17: Blending Modes Introduction Master the concept of Blending Modes and their effects on layer overlays Understand different Blending Modes like Darken, Lighten, and Overlay Layer Mastery: Develop expertise in working with layers, mastering advanced techniques for seamless editing and design organization in Adobe Photoshop. Precision Editing: Skillfully employ a variety of selection tools, ensuring precise and meticulous editing, manipulation, and composition of images and elements. Creative Layer Effects: Apply captivating Layer Effects with finesse, enhancing your designs and visuals to achieve professional-grade aesthetics. Advanced Editing Techniques: Understand the functionalities of Adjustment Layers, Masking, and Clipping Masks, enabling you to perform advanced editing and compositing tasks with confidence and precision. Effective Photo Restoration: Acquire techniques to touch up and restore photographs effectively, ensuring professional-quality results in photo editing and retouching. Typography Expertise: Explore advanced typography techniques, enabling you to create visually appealing text designs that complement your overall compositions. Filter Applications: Gain an introductory understanding of Filters and their creative applications, enhancing your ability to add artistic effects and refine visuals. Practical Color Theory: Grasp the fundamental principles of Color Theory and apply them practically in your designs, ensuring harmonious and visually pleasing color schemes in your work. Course Highlights: Advanced Photoshop Skills: Learn intricate techniques for professional image editing, retouching, and manipulation. Creative Design Projects: Engage in hands-on projects to enhance your practical skills in real-world scenarios. Mastering Special Effects: Dive into advanced topics like layer effects, filters, and blending modes to create stunning visual effects. Typography and Design Principles: Explore typography styles, layout design, and color theory for compelling compositions. Professional Portfolio Development: Receive guidance on creating a professional portfolio showcasing your Photoshop expertise. Potential Job Roles: Graphic Designer: Craft visually appealing graphics for print and digital media. Digital Artist: Create digital artwork for various applications, from illustrations to advertisements. Photo Retoucher: Enhance and manipulate photos for professional use, including portrait retouching. UI/UX Designer: Design user interfaces and experiences for websites and applications. Web Designer: Develop visually engaging websites with expertise in Photoshop for web design. Marketing Content Creator: Produce marketing materials such as banners, brochures, and social media visuals. Freelance Designer: Work independently, offering design services to clients across different industries. Advertising Creative: Contribute to creative campaigns by designing impactful ad visuals. Print Production Specialist: Prepare print-ready materials, ensuring quality in printed products. Photography Post-Processing Specialist: Enhance and retouch photographs, optimizing them for professional use. Comprehensive Photoshop Proficiency: Develop a solid foundation in Photoshop, mastering essential tools and techniques vital for image editing and manipulation. Creative Editing Expertise: Learn advanced retouching, image enhancement, digital artwork creation, and graphic design using Photoshop's powerful features. Professional-Grade Results: Acquire skills for achieving professional-level outcomes in image editing, ensuring precise color correction, seamless retouching, and visually appealing compositions. Optimized Workflow: Discover time-saving tips, shortcuts, and efficient techniques to enhance your Photoshop workflow. Learn layer management, non-destructive editing, and automation for streamlined processes. Versatile Design Skills: Unlock creative possibilities by mastering text effects, digital collages, filters, and graphic design for diverse mediums. Access to Recorded Lessons: Revisit course material and reinforce learning through recorded lessons. Review specific techniques at your own pace, deepening your understanding of Photoshop. Lifetime Email Assistance: Benefit from continuous support with lifetime email assistance. Seek guidance, get answers to questions, and seek clarification even after completing the course.

Why Learn Adobe Illustrator Basic to Intermediate Training Course? Course Link With our Illustrator Intermediate Course take your vector graphics to the next level and bring your designs to life with advanced techniques and tools. Gain hands-on skills in creating shapes, patterns, and logos, and learn how to edit images with precision. Duration: 6 hrs. Method: 1-on-1 - Personalized attention Schedule: Schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. This course covers fundamental tools and features of Adobe Illustrator, aimed at beginners, to enable them to create and edit vector graphics efficiently and effectively. Adobe Illustrator is the industry-leading vector graphic software for working with vector graphics, providing a comprehensive set of tools for producing exceptional graphics for various media, including print, video, web, and mobile devices. Course Title: Adobe Illustrator  Course Outline: Mastering Advanced Drawing Techniques  In-Depth Curvature Tool Mastery Advanced Pen Tool Usage: Drawing Complex Paths Understanding Path, Anchor Points, and Handles Precision Editing with Direct Selection Tool Slicing and Dividing Paths using Scissors and Knife Tools Exploring Advanced Stroke and Path Options  Custom Width Profiles with the Width Tool Diverse Brushes Exploration in Brush Library Creating Scattered Objects with Scatter Brushes Applying Patterns along Paths with Pattern Brushes Crafting Custom Pattern Brushes Understanding Graphic Styles  Efficient Usage of Graphic Style Libraries Creating, Deleting, and Saving Graphic Styles with Graphic Style Panel Leveraging the Power of Graphic Styles Mastering Pattern Manipulation Techniques  Creating and Editing Patterns using Pattern Mode Modifying Pattern Elements with Precision Adjusting Spacing and Resizing Patterns using the Tile Tool Rectifying Background Errors with Overlap Options Saving and Exporting Custom Patterns Exploring Advanced Gradient Options  Gradient Styles Exploration Fine-Tuning Gradients with the Gradient Annotator Creating Free Transform Gradient Points and Lines Applying Single Gradient across Multiple Objects Gradient and Transparency Integration Creative Applications and Practical Projects  Applying Advanced Techniques to Real-World Projects Creative Problem-Solving Strategies Q&A Session and Feedback Gathering Note: Each section includes practical exercises and hands-on projects to reinforce learning. The course emphasizes practical application, ensuring participants leave with tangible skills and a deep understanding of advanced Adobe Illustrator concepts. Q: What will I learn in the London Design Training Course in Adobe Illustrator? A: In this course, you'll learn essential techniques for creating and editing vector graphics using Adobe Illustrator. The training covers drawing tools, shapes, layers, effects, styles, logo design, Image Trace, Live Paint, and integration into your design workflow. Q: What can I expect to achieve after completing the Illustrator training course? A: By the end of the course, you'll be proficient in Illustrator tools, create graphics for print, web, and mobile, design logos with special effects, and manipulate images. You'll receive an accredited Illustrator training certification and post-course support. Q: Is any prior knowledge of Illustrator required to attend the course? A: No, the course is designed for beginners, and no prior knowledge of Illustrator is necessary. Q: Which version of Illustrator will the training be based on? A: The training is primarily based on Illustrator 2023, but the techniques apply to recent releases. Q: Can I attend the course on either a Windows or Mac computer? A: Yes, Illustrator works identically on both Windows and Mac. Our training centers offer both platforms for your convenience.

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. 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? 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 Requirements General knowledge of the Windows OS 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 Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS 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 Certificates Certificates Certificate of completion Digital certificate - Included

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualisations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

During this 1 day intermediate level course you will learn how to utilise the powerful image editing capabilities of Adobe Photoshop. Building on the topics covered in our Introduction to Photoshop, you will learn how to work with multiple layers, use layer masks, learn how to use smart objects, add sophisticated filters. Re-touching and repairing, montages and image correction techniques are also covered.