Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 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. 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel 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
Indesign face to face training customised and bespoke. One to One Online or Face to Face
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
Why Choose AutoCAD Architecture Training Classes? Course info Master architectural design tools and workflows. Create precise floor plans, elevations, and sections. Utilize BIM for intelligent 3D modeling. Access recorded lessons and lifetime email support. Enroll for in-person or online sessions. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD Architecture 3D Course Outline: Introduction to AutoCAD Architecture Understanding the difference between AutoCAD Architecture and AutoCAD LT Familiarization with the user interface and 3D viewing Wall Construction and Modification Adding walls to the model Creating curtain walls for specialized designs Modifying walls to fit specific requirements Joining walls together to form complex structures Adding and modifying wall openings for doors and windows Ceiling Plans (Reflected) Creating ceiling grids and construction detailing Modifying ceiling grids to match design needs Inserting ceiling fixtures and construction detailing Structural Design and Analysis Working with structural members and online resources Creating column grids and detailing columns Modifying column grids and annotations Annotating column grids and detailing for clarity Stairs Creating stairs in the model Modifying stairs to suit design specifications Adding railings to stairs and construction detailing Modifying railings and construction detailing Floors and Slabs Creating floor slabs and construction detailing Modifying floor slabs to align with the design Editing slabs using Slab Tools and construction detailing Roofs and Construction Detailing of Roofs Creating roofs for the building Designing roof slabs for specific areas Modifying roofs and roof slabs as needed Using Roof Slab Tools for precise detailing Annotation Detail drawing for scale and annotation Adding text, leaders, and comments to the model Dimensioning in AutoCAD Architecture for accurate measurements Utilizing other annotation tools for clarity Equipment and Furnishings Adding interior and exterior furnishings to the design Incorporating blocks and online 3D models for realistic representations Utilizing Tool Palettes and Autodesk Seek resources Model Views Ready for Print PDF Creating callouts for specific views Designing elevations, sections, and construction detailing Modifying callout objects for better visualization Implementing live sections and elevations Generating reports and managing project resources Schedules Adding door and window labels to the model Editing label data for accuracy Creating schedules for better project management Modifying schedules to suit specific requirements This AutoCAD Architecture 3D course covers a comprehensive range of topics, providing participants with the skills to create detailed 3D architectural models, implement construction detailing, and manage project resources efficiently. The course enables participants to produce professional-grade architectural designs using AutoCAD Architecture software.
“You don't take a photograph. You make it" - Ansel Adams Photography For Parents - Editing In Lightroom Next course starts 11 March 2024 Editing is an essential skill for anyone with even just a passing interest in photography. Much as we try, we can't always get everything right in camera and editing tools help us bring our vision to life, help correct problems and allow our images to look beautifully polished. We teach how to do all these things in Adobe Lightroom because it's a powerful, intuitive and affordable tool used by Pros around the world for that very reason. KEY COURSE INFO: Course type: Instructor-led Course duration: 4 weeks + prep module Course format: Online course with interactive edit-along live classes, feedback on your learning and support group WHAT YOU LEARN: From being able to correct issues such as over/under exposure, issues with colour or graininess to bringing your vision to life, creating mood and tone to your images, knowing how to use editing software is a must. But good and purposeful editing goes way beyond just slapping on a preset or a filter - in our course we teach you all about the tools - not just what all of them do but how, and we teach you how to know what to use and when to achieve certain effects.everything you need to allow you to style your photos, confidently use the software and fix common problems. editing to correct common photo problems creating good editing workflow using powerful precision tools editing to achieve beautiful skin tones using light and colour creatively editing to bring out a mood of a feel THIS IS THE COURSE FOR YOU IF : Love taking photos but want them to look more polished - with colours that pop and light that's perfectly balanced You want to be able to fix common issues such as under- or overexposure, white balance or colour casts so that you never need to bin an image just because it wasn't right straight out of camera You want to get more creative with light and colour to make the images look just like the moment felt. Bring on the moody edits or sun soaked edits or light kissed skin tones or creative black and white conversions You want to confidently use the editing techniques so you can bring your vision to life every time, without guesswork You want to be able to prepare your images for print so that your walls can beam with pride at the beauty that you captured Next Editing in Lightroom course starts 11 March 2024 4 core course modules plus prep module Support Facebook group Weekly edit-along live webinar Practice files to learn on Feedback on your images HERE IS WHAT YOU WILL LEARN in this course : Our Photo Editing in Lightroom course guides you through the photo editing process in Adobe Lightroom from start to finish – from setting it up correctly, organising your collections and creating a workflow that works for you, through learning the capabilities of all the editing tools - such as adjusting exposure, colours, light or sharpening the images; all the way to printing and creating photo books. We’ll show you how to create specific artistic effects ( high impact Black and white, vintage, light and airy, dark and moody etc ), and how to fix common photography problems ( grainy images, underexposed images, wrong colours etc). At the end of the course you will be able to confidently manage your photo collection with Lightroom, achieve desired artistic effects and make your photos truly stand out. Getting around in Lightroom and Lightroom Classic - shooting in full manual - but with clarity and purpose Correcting common problems - whether your photo started too dark or too bright, your child's face was in a shade, the white balance and colours were off, the grain was heavy, the light looked dull - you can fix it all within a couple of clicks in Lightroom Using Lightroom's super powerful intelligent masking tools to quickly and efficiently edit specific parts of your image - from brightening up the eyes to rescuing overblown skies Enhancing and adding beautiful light - light makes images stand out, but it can be hard capturing the atmosphere it creates in camera at times. Lightroom is where you can bring light to life and make your images feel how what you saw in real life Knowing how to shoot in camera so you can get the most in editing - photographers will often purposefully under or overexpose images in camera so that they have more chance of balancing the image just they way they want in Lightroom. INSIDE THE MODULES - aka WHAT DO YOU LEARN? Module 0: Getting set up in Lightroom This module is released a week before the course starts to give you a chance to fully familiarise yourself with the layout, structure and the best way of working in Lightroom Classic, including guidance of creating a smooth selection and culling process that helps you see and keep the best of your images, without getting bogged down with 100s near duplicates. Module 1: Getting Started In Lightroom - Global Edits In this module we introduce you to Lightroom's most powerful tools - the global edits. We help you understand how to tweak your images to achieve the effects you're after quickly - from adjusting over and under exposure, to correcting white balance in a few different ways, to having a play with my favourite Lightroom tool - the tone curve. Major Takeaways: At the end of the module you will have gained full control of lightroom key global tools and will be able to use them to correct any global - as in affecting the whole image - issues with your images. This includes perfecting your exposure, balancing your colour and white balance, sharpening and creating clarity and more. Module 2: Targeted Edits - Masks! Lightroom allows us to apply edits to selected parts of the image through a range of its very powerful, intelligent and manual masks. This means you can now effortlessly select your subject from the photo to adjust them separately with just one click, you can pick only the sky, the subject's eyes or only colour green or any other element and treat them differently to the rest. Major Takeaways: You will be able to use the full range of masks in lightroom and apply your edits exactly where they are needed, and nowhere else. This includes working with with the new AI powered masks which can detect a person's individual features and allow you to selectively edit them in a few simple steps, as well as those more manual tools, that allow you to literally paint with light and colour on your photographs. Module 3: Creative Editing in Lightroom This is a brand new module in our course where we take all the tools introduced in Modules 1 and 2 and actually use them to achieve different effects on our photos. Wer show you how to be guided by light when editing, how to achieve a light and airy or a moody edit on your images, how to add light and how to convert to black and white, as well as how to edit skin in Lightroom! This module is all play! Major Takeaways: You will learn how to create yoru own editing process - from knowing where to start and to understanding what elements of your photograph may need or benefit from adjusting and knowing how you can do so to achieve different outcomes. You will also learn how to edit your skin tones so they look delightful - no matter what your subject's complexion. Module 4: After the edits We close the course with a module centered around all the things you might want to do after the edits - from preparation for print, creating photo books, but also sharing your images online and syncing them between different machines and adobe workplaces. PLUS there is a little Photoshop intro so you get a glimpse at how it's different and what it can do. Major Takeaways: You will learn how to connect all of your Adobe ecosystem and sync and share your images across multiple devices. You will learn how to prepare your images for print so they look their very best and how to create photobooks. Next course starts 11 March 2024 Absolutely, without a doubt book Editing. I was very unsure at first. My interest in photography is to capture those memories so it felt like it was 'cheating' to edit. I can honestly say it's like magic.To finish off the pictures you love and just give you complete control over the exposure, colours to make them perfect, to rescue the disasters etc. I learnt so much in those few weeks and it made the biggest difference to my photos. Kerry White Editing in LIGHTROOM Book your space now: COURSE STARTS : 11 March 2024 ( 4 weeks + 1 prep week)COURSE COST : £179 ( payment plans available ) What’s included: 4 weekly modules with step by step illustrated tutorials and videos + prep module weekly edit along class online class ( also recorded) - on Wednesday evenings feedback and advice on your edits private support group PDF workbook and downloadable videos Practice images to learn on Join our next group to really bring life to your images and make them look sleep, polished and full of light COURSE PREREQUISITES: Lightroom or Lightroom Classic CC software installed on your computer or tablet. RECOMENDED : Lightroom Photography Plan 25GB – a monthly subscription at approx £9pm – including Lightroom CC, Lightroom Classic CC and Photoshop. This plan can also be occasionally purchased at a lower price via Amazon or Groupon if you purchase a year’s worth of subscription in one go ( average savings – around 2-4 months worth depending on the deal) Please note that Adobe also has a Lightroom Plan with 1TB of storage – we do not recommend this plan as it restricts you to one version of software only. The increased Cloud storage can always be purchased as an add on or your plan can be switched from Photographer plan to CC only at a later stage if you prefer.
About this Training Course This 3 full-day training course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data. The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they've learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn't be able to do what they need to do. This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries. Training Objectives Upon completion of this training course, participants will be able to: Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis Combine data sources together and gain an introductory understanding of the M language Write formulas using the DAX language for generating custom columns, measures and tables Design reports and dashboards using a wide range of both built-in and custom visuals Publish reports and dashboards to PowerBI®.com Share reports and dashboards with others using PowerBI®.com Customize reports and dashboards so that different user groups automatically see their own personalized views Target Audience This training course is intended for: Financial Analysts Accountants Budgeting and planning specialists Treasury Risk Managers Strategic Planners This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Course Level Basic or Foundation Trainer Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years' experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings. He has trained delegates from a wide variety of Oil & Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions. Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm. He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. Highlights from his oil and gas experience include: Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets. Auditing and further development of life of project models for Chevron's Strategic Planning Division analysing their North West Shelf assets. Development of business plan and budgeting models for multinational oil & gas assets. Development of cash flow and taxation models for a variety of oil gas companies. Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' 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 in formulas + vlookup and shortcut keys. Jenny Price - Acer 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 classroom, one to one, tailored and bespoke courses. Tailored 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel 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
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. 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. 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
Photoshop pay per hr training flexible time weekend evening