Private Employee LMS

Excel for Beginners – Level 1

This video tutorial will show you how to use Microsoft Excel for beginners. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Click on the timestamp to be taken directly to that part of the video.

33 minutes


0:00
Start

1:07 Starting up

1:27 Recent documents and pinning documents

1:54 Templates

2:34 Layout – Tabs, ribbons, and groups in Microsoft Excel

3:48 Rows, Columns, Cells and Ranges

5:49 Worksheets in Microsoft Excel

6:52 View and zooming

7:30 Inputting Data

10:56 Formatting Data

13:38 Wrapping Text

14:22 Insert Row/ Merge & Center cells

15:41 Currency formatting

16:20 Print view

17:02 Add cell borders and colors

18:18 Basic formulas in Microsoft Excel

21:17 Copy formula

23:45 Freeze Pane

24:52 Basic Microsoft Excel functions

28:59 “Tell Me” in Microsoft Excel

29:43 Inserting charts in Microsoft Excel

Premiere Pro – Video Editing – Over Existing Slides

This covers how to edit a combined audio and video file over existing slides (no green screen to filter). For audio presets, please refer to that lesson.

#2 tells you to drag and drop the audio effects preset. If you do not have that saved in your Premiere settings, go and set them up by via the lesson titled Premiere Pro – Grandy’s Standard Audio Effects.

You can view the pdf below by using the scrolling bar, or click on the title underneath the pdf where it will open it up on a separate tab for a larger view. You can also download it from there or print it.

Premiere Pro – Grandy’s Standard Audio Effects

These are Grandy’s suggested effects that can be applied to all audio clips, regardless of who is speaking.

The end of the pdf also shows you how you can save these effects as a standard “preset” to make editing easier for the future. As a preset, you can then drag and drop ALL of the effects at ONCE, and have all of them apply to the clip.

You can view the pdf below by using the scrolling bar, or click on the title underneath the pdf where it will open it up on a separate tab for a larger view. You can also download it from there or print it.

Premiere Pro – Audio Editing

This is written for the audio portion ONLY. If you recorded an audio and video clip together that you want to keep, simply start at #3 of the document.

#3 also tells you to drag and drop the audio effects preset. If you do not have that saved in your Premiere settings, go and set them up by via the lesson titled Premiere Pro – Grandy’s Standard Audio Effects.

You can view the pdf below by using the scrolling bar, or click on the title underneath the pdf where it will open it up on a separate tab for a larger view. You can also download it from there or print it.