Syllabus

  • Exploring Premiere Pro Interface
  • What is Non-Linear Editing (NLE)?
  • Customising Premiere Pro Interface
  • Setting up a New Project
  • Setting up a Back-up Strategy
  • customizing Preferences
  • Importing Videos into Premiere Pro
  • Importing Images into Premiere Pro
  • Creating Bins
  • Organizing Assets into Bins
  • Creating New Sequences
  • Importing a Series of Videos and Images
  • Creating a Rough-Cut Storyboard
  • Creating a Slideshow of Videos/Images
  • Adding Clips to the Timeline
  • Editing Clips on the Timeline
  • Creating In and Out Points
  • Editing Clips in the Source Monitor
  • Creating Sub clips
  • Making Cuts on the Timeline
  • Using Selection tool
  • Using the Track Select Forward/Track Select Backward tool
  • Making Cuts on the Timeline with Razor tool
  • Implementing Ripple Edit tool and Rolling Edit tool in Your Edits
  • Exploring the Slide tool and Slip tool
  • Exploring Zoom and Hand tools for Faster Editing
  • Changing the Speed of the clip (Slow Motion / Fast Motion)
  • Implementing Rate Stretch tool for Slow / Fast Motion
  • Implementing Speed/Duration for Slow / Fast Motion
  • Creating Beautiful Hollywood-Style Super Slow Motion
  • Previewing Audio Clips in Premiere Pro before Importing Them
  • Importing Audio Clips into Your Project
  • Adjusting Audio Volume
  • Exploring Transitions in Premiere Pro
  • Creating Video Transitions
  • Editing Video Transitions
  • Exporting Your Sequence from Premiere Pro
  • Exporting Your Sequence with Media Encoder
  • Exploring Export Options such as MP4, MOV, AVI, and other formats
  • Exporting Video Frames as Images

Advanced Excel

Introduction to Advanced Excel | Excel sheet Creation, edit, save, Folder Creation | Project 1 

Conditional Formatting & Data Validation

Cell reference, Conditional formatting| Data validation| Important functions in Excel, Remove duplicate values, Hyperlink| Filter, Unique, Sort, SortBY, Sequence, Randarray Functions|

Logical & Statistical functions

Logical functions | Sum & Count if functions| Graphics, Print area setup , Camera tool project| Statistical functions, mathematical functions , Date related functions,  Financial Functions| Dsum, subtotal functions, Text functions, Insert object| Data extraction| Averageif& Averageifs.

Advanced Pivot Table

Classic pivot table and chart| Slicers, timelines and calculated fields| Building hierarchies in pivot tables| Advanced Pivot table data analysis

Advanced Formula for Data Analysis

Custom view, Header and footer, Text to column function| Goal seek, Solver, Scenario manager| Lookup| Project| Match and index function, Consolidating data

Advanced Formula for Data Analysis

Sparkline chart, People graph, Data forecast, Import text file| Mail merge, Consolidating data| Form data, Auditing tool, Web data, Speak cell | Macro, Password protection

Data Preparation and Cleaning

Importing data from various sources. | Handling missing values and duplicates. | Using Text-to-Columns and Flash Fill. | Data validation and error checking for quality assurance.|

Date and Time Analysis

Working with DATE, TIME, NETWORKDAYS, and EOMONTH. | Automating rolling date ranges for dynamic reports. | Calculating time differences in hours, minutes, and seconds. | Custom formatting for date and time (e.g., “MMM-YYYY”). | Dynamic date ranges and custom date logic with WEEKNUM, WORKDAY.INTL

Power Query (Get & Transform)

Importing and cleaning data from various sources| Merging and appending queries| Advanced filtering and transforming data

Introduction to Dashboard Design

Understanding the importance of dashboards | Planning a dashboard project| Data visualization best practices| Advanced Charts