JPL IT Training Limited
JPL IT Training Limited
  • Видео 120
  • Просмотров 78 471
Inserting Process SmartArt Diagrams in PowerPoint
In this video you will learn about inserting process SmartArt diagrams in PowerPoint, including:
- Two ways in which you can insert a process SmartArt diagram into a slide
- How to edit the text in the SmartArt diagram
- How to format the SmartArt diagram once it's inserted
SmartArt is a feature that you can use in pretty much all of the Office 365 packages but is often used more in PowerPoint due to it being a more visual feature. There are a wide variety of SmartArt diagrams that you can choose from and we will be looking at a few of these that you can use, starting off with the process one. This diagram can be used to visually describe a step by step process going from left to right. This ...
Просмотров: 17

Видео

Excel Missing Numbers in a Sequence
Просмотров 1122 месяца назад
In this video you will learn about Excel missing numbers in a sequence, including: - Functions that you can use alongside each other to work out if there are any numbers missing in a sequence - What the two functions are and how to use them both - An example spreadsheet showing both being used NOTE: this 'fix' mentioned in the blog post and video only works on pure numbers Spreadsheets contain ...
Inserting Charts in PowerPoint
Просмотров 232 месяца назад
In this video you will learn about inserting charts in PowerPoint, including: - Two ways in which you can insert a chart into a slide - How to add in chart elements like axis titles - How to format the chart once created Charts are a very useful feature that are normally talked about in Excel, but they can also be used and inserted into presentations in PowerPoint! Charts can be a great way to ...
Inserting Tables in PowerPoint
Просмотров 213 месяца назад
In this video you will learn about inserting tables in PowerPoint, including: - Three ways in which you can insert a table into a slide - How you can edit the table once inserted PowerPoint is a great package used by many for creating presentations. Although text will feature heavily in these, there are other items that you can insert into them with one of these being tables. Tables are a good ...
Inserting Shapes in PowerPoint
Просмотров 864 месяца назад
In this video you will learn about inserting shapes in PowerPoint, including: - Three ways in which you can insert a shape into a slide - How you can edit the shapes once inserted PowerPoint is a useful tool for putting together presentations. It has lots of features to make this process easier, with one of them being shapes. Shapes allow you to add something extra to your slides to go alongsid...
Nested VLOOKUPs in Excel
Просмотров 725 месяцев назад
In this video you will learn about Nested VLOOKUPs in Excel, including: - What a nested VLOOKUP function looks like - How to create a nested VLOOKUP - A couple of examples on how to use one in your spreadsheets VLOOKUPs are used by people on a daily basis and its no wonder why as they are so useful! Sometimes though your data might not be laid out in a way so that you can actually create a stan...
VLOOKUPs in Excel
Просмотров 787 месяцев назад
In this video you will learn about VLOOKUPs in Excel, including: - What the VLOOKUP function looks like - The different parts to a VLOOKUP - A couple of examples on how to use one in your spreadsheets The VLOOKUP function is a useful and popular function used by many in Excel. It is always a firm favourite with all of our attendees on our courses. The VLOOKUP function allows you to bring inform...
Date Reformatting in Excel
Просмотров 247 месяцев назад
In this video you will learn about date reformatting in Excel, including: - Common formats of dates using . and / - How to use a formula to reformat dates to enable them to be used in formulas Dates are used all the time in Excel. Often companies import data into spreadsheets from other software packages which can save a lot of time. However unfortunately sometimes dates aren't copied over in t...
Copy Paste Macro in Excel
Просмотров 2948 месяцев назад
In this video you will learn about copy paste macro in Excel, including: - How to set up data validation - What code in a Macro means - How to edit the code - An example of where you might use it Macros are a useful feature in Excel that often get overlooked due to being seen as 'complicated'. Due to macros being linked to coding a lot of people don't want to venture onto the Developer Tab and ...
Excel Conditional Formatting with Dates
Просмотров 2989 месяцев назад
In this video you will learn about Excel conditional formatting with dates, including: - How to use conditional formatting with dates - An example of where you might use it Conditional formatting is a feature in Excel that is used by many due to its ability to visually show patterns. A lot of people know and use it with numbers in a spreadsheet but you can also use conditional formatting with d...
TEXTJOIN Function in Excel
Просмотров 5711 месяцев назад
In this video you will learn about the TEXTJOIN function in Excel, including: - What the TEXTJOIN function does - What the different parts of it are for - A worked example of how to use it Excel is used by many around the world, especially for it's extensive range of functions available. There are lots that you can use but some can be missed, one that might get missed is TEXTJOIN. We see this f...
Word Shortcuts Part 6
Просмотров 23Год назад
In this video you will learn about some Word shortcuts part 6, including: - The F3 function key alongside the Shift Key and what it does - The F6 function key alongside the Ctrl Key and what it does - The keyboard shortcut Ctrl Alt S for inserting a split into a Word Document window - The keyboard shortcut Ctrl Enter Key for inserting a page break - The keyboard shortcut Ctrl Shift Enter Key fo...
Word Navigation Shortcuts Part 4
Просмотров 19Год назад
In this video you will learn about some Word navigation shortcuts part 4, including: - The End Key with the Ctrl Shift keys and what it does - The Home Key with the Ctrl downShift keys and what it does - The keyboard shortcut for selecting one word to the left of the cursor - The keyboard shortcut for selecting one word to the right of the cursor - The keyboard shortcut for selecting one paragr...
Word Shortcuts Part 5
Просмотров 20Год назад
In this video you will learn about some Word shortcuts part 5, including: - The F6 function key and what it does - The F8 function key and what it does - The keyboard shortcut Ctrl M for indenting a paragraph - The keyboard shortcut Ctrl Shift M for removing a paragraph indent On a daily basis, Word is a package that is used by many for editing and creating documents. What a lot of people don't...
Excel Shortcuts Part 5
Просмотров 50Год назад
In this video you will learn about Excel shortcuts part 5, which includes: - F9 function key - Ctrl F9 function key - Keyboard shortcut to apply the strikethrough formatting - Keyboard shortcut to apply currency formatting - Keyboard shortcut to apply percentage formatting Carrying with our Excel Shortcuts series, this week brings you part 5 in our shortcut videos. In this video we are looking ...
Word Navigation Shortcuts Part 3
Просмотров 37Год назад
Word Navigation Shortcuts Part 3
Video of Excel conditional formatting and IF Statements
Просмотров 408Год назад
Video of Excel conditional formatting and IF Statements
Word Shortcuts Part 4
Просмотров 54Год назад
Word Shortcuts Part 4
Excel Shortcuts Part 4
Просмотров 49Год назад
Excel Shortcuts Part 4
Word Navigation Shortcuts Part 2
Просмотров 21Год назад
Word Navigation Shortcuts Part 2
Word Shortcuts Part 3
Просмотров 24Год назад
Word Shortcuts Part 3
Excel Shortcuts Part 3
Просмотров 33Год назад
Excel Shortcuts Part 3
Word Navigation Shortcuts Part 1
Просмотров 35Год назад
Word Navigation Shortcuts Part 1
Word Shortcuts Part 2
Просмотров 44Год назад
Word Shortcuts Part 2
Charts from data with Error Messages in Excel
Просмотров 54Год назад
Charts from data with Error Messages in Excel
Creating a Chart from Hidden Rows in Excel
Просмотров 302 года назад
Creating a Chart from Hidden Rows in Excel
PowerPoint Aligning and Sizing Shapes
Просмотров 9 тыс.2 года назад
PowerPoint Aligning and Sizing Shapes
New Excel Status Bar Feature Coming Soon: Copying from the Status Bar
Просмотров 602 года назад
New Excel Status Bar Feature Coming Soon: Copying from the Status Bar
UNIQUE Function in Excel
Просмотров 412 года назад
UNIQUE Function in Excel
Automatically Updating Styles in Word
Просмотров 4,1 тыс.2 года назад
Automatically Updating Styles in Word

Комментарии

  • @ugeo8812
    @ugeo8812 2 месяца назад

    Trying to use excel alerts for stock prices - however sound keeps on playing - how can we limit sound to only play once and then disarm unless price goes below a certain level then re-arm. For example - Apple stock alert me when price is above 200 - so if Apple trades above 200 for the next 3 hours - I do not want to constantly hear the sound - but if price goes below 200 then rearm so sound will come on if it goes above 200 (and will play only once)

  • @pratikghanekar6593
    @pratikghanekar6593 3 месяца назад

    How to select 2 months together to get data

  • @Aishwaryaaa777
    @Aishwaryaaa777 6 месяцев назад

    Simple and straight to the point, Thank you!

  • @auxanelabanane
    @auxanelabanane 10 месяцев назад

    weird, why doesn't it shoes any of my .word documents but only .dotm documents?

  • @andyl2177
    @andyl2177 10 месяцев назад

    Well this is just fantastic

  • @Duketangled
    @Duketangled Год назад

    thanks

  • @Becozitslikethat
    @Becozitslikethat Год назад

    Thank you so much 😃 It worked 👍🏻

    • @JPLITTrainingLimited
      @JPLITTrainingLimited 5 месяцев назад

      You're very welcome! I'm glad that it worked for you and helped

  • @deepanshchaudhary5094
    @deepanshchaudhary5094 Год назад

    Thank you Miss.

  • @latoyamartin3698
    @latoyamartin3698 Год назад

    Thank you so much. I always assumed the triangles were all true errors, but they are also for informational purposes.

    • @JPLITTrainingLimited
      @JPLITTrainingLimited 5 месяцев назад

      You're very welcome. Yes sometimes the default can be to assume it is a true error if something comes up, but in this case it isn't always the case!

  • @LinkSquish
    @LinkSquish Год назад

    Thanks, I was clicking text box & it wasn't doing anything. I didn't realize you had to draw it out, lol

  • @amitshukla8901
    @amitshukla8901 Год назад

    sir, What was the role of "As string" here?

  • @toritovalenzuela
    @toritovalenzuela Год назад

    Looked for this answer for 30 minutes! Thank you!

  • @samyang6306
    @samyang6306 Год назад

    Thank u

  • @carlosjackson4474
    @carlosjackson4474 Год назад

    Great Information, Thank you!

  • @j.4903
    @j.4903 2 года назад

    My numbers are not from a formula. Just a informative voucher number.

  • @spiromlb
    @spiromlb 2 года назад

    Thank you . What I need to know is how to get back into a Textbox to Edit it! I have yet to see someone on RUclips teach this critical skill. Editing a text box is as critical as starting one. Cheers.

  • @itsnoorswarbair
    @itsnoorswarbair 2 года назад

    Thank You so much

  • @TubeYouDavidpearce
    @TubeYouDavidpearce 2 года назад

    Thanks John, I didn't know that one.

    • @JPLITTrainingLimited
      @JPLITTrainingLimited 2 года назад

      Thanks Dave It was fairly new to us too!. We are looking to share new functions in Excel 365 as they are announced. Some still in beta test mode

  • @TubeYouDavidpearce
    @TubeYouDavidpearce 2 года назад

    Thanks John, I have used outlook for years and didn't realise you could do this.

  • @CletoClips
    @CletoClips 2 года назад

    I have several macros that run 30-90 seconds. I would like to add a beep when the macro is done running, rather than staring at the screen. Is there a way to do this?

    • @JPLITTrainingLimited
      @JPLITTrainingLimited 2 года назад

      Hi Bob. Did you find the RUclips video helpful?

    • @CletoClips
      @CletoClips 2 года назад

      @@JPLITTrainingLimited It's a little bit over-my-head, but I'm trying to figure it out. I was hoping I could just (1) open a new macro. (2) and paste some "beep code" at the end of it. That may be what you are showing me but I just haven't figured it out yet.

    • @JPLITTrainingLimited
      @JPLITTrainingLimited 2 года назад

      @@CletoClips I researched my video Bob and the simple macro code is in it. It is linked in an IF statement which I show. It may be too simple but perhaps replicate mine to start with then see how you go

    • @CletoClips
      @CletoClips 2 года назад

      @@JPLITTrainingLimited Thank You. The IF formula in the bar is too small to read. Would you place it in the comments? I tried enlarging the screen but it is still too blurry.

    • @JPLITTrainingLimited
      @JPLITTrainingLimited 2 года назад

      @@CletoClips Of course, the IF formula in the bar in the spreadsheet is as below: =IF('Testing the Beep'!E1="UK",BeepMe(),"") Hope this helps and let us know how you get on!

  • @JAYS040787
    @JAYS040787 2 года назад

    Thank you very much. This was very helpful. I am in the process of learning Word, Excel and PowerPoint.

  • @davidpearce6501
    @davidpearce6501 3 года назад

    Very informative and well delivered.

  • @staceyadmensah2418
    @staceyadmensah2418 3 года назад

    Great video 😊