About Us:
We are an Online Video Streaming Platform, and we create a huge array of content for our YouTube Channel. We are looking for professional content creators to join us for our endeavour.
We are looking for someone to make a complete tutorial video series for Microsoft Excel 2016.
Reference video - [login to view URL]
- Format: Screen-Recording with Voice-over & Text
- Language: English
- Please ensure audio is both clear and audible. Please minimize background noise & echo.
- Please ensure video text doesn't merge into the background. Also, please choose a legible font.
Below is a list of topics which we want you to cover. Each topic should be covered in a seperate video.
1) Basics of Excel Interface:
e.g. Quick Access Toolbar, Tabs,
Ribbon, Tell Me Box, Formula Bar,
Sheets, etc.
2) Customizing Excel's Interface (e.g. tabs & groups)
3) Basic of Cells and Sheets (Can be grouped into 2/3
videos as well)
- Insert, delete, drag & drop cells
- Cut, copy, paste & special paste functions
- Fill, Advanced Fills (e.g. fill drag numbers,drag
months, days, custom list, down, right, up, left), Fill
Series, Flash Fill
- Undo, Redo, Edit Text
- Find & Replace
- Transpose
- Insert, Delete, Resize
4) Modify & Format Rows, Columns, Cells & Numbers
(e.g. Font, Alignment, Number, Headers & Footers)
5) Working with Multiple worksheets
- insert, delete, rename, copy, move, hide,
unhide worksheets
- Change sheet colour
- Formatting wokrsheets after grouping
- Name Range
- Hyperlinks
6) Crash Course on Functions with Examples,
seperate short video for each --> Explain what the
function does, and when & why it is used; Seperate
video for popular functions like Count, Vlookup,
Hlookup)
i) Financial
ii) Date & Time
iii) Math & Trig
iv) Statistical
v) Lookup & Reference
vi) Database
vii) Text
viii) Logical
ix) Information
x) Engineering
xi) Cube
7) Creating simple and complex
formulas (including nested functions)
- Basic Formulas - Add, subtract, multiply, divide,
BODMAS
- If Function
- Nested IF
- AND fucntion
- Not and If Error
- View Dependence & Precedence
- Name Range + Formulas
8) Cell referencing: Relative, Absolute & Mixed
Reference
9) Working with Excel Data
i) Sorting Data
ii) Filtering Data (Basic & Advanced)
iii) Summarizing Data
iv) Creating Tables (Basic and Advanced)
v) Creating Visualizations (Column/Bar/Pie/Line/
X-Y Scatter/Sparklines/Pivot Charts)
vi) Conditional Formatting (Basic & Advanced) -->
Highlighting Cells, Top/Bottom Rules, Clear Rules,
Data Bars, Colour Scales, Icon Sets, Clear Rules
viii) Subtotals
ix) Data Validation --> Whole Numbers, Text Length,
Date, Drop Down List ; Circling Invalid Data,
Custom Error Messages
x) Error Checking & Data Monitoring
xi) Freezing Rows & Columns
9) View Options
(e.g. Hide, Unhide, Freeze Pane, Split
Windows, Custom View, View Side by Side,
Sync Scrolling)
10) Track Changes & Comments (e.g. Insert, Edit,
Delete, Show all Comments)
11) Inspecting & Protecting Workbooks (e.g. Protect
cells, sheets, workbook & file; Hiding formulas)
12) Pivot Tables (Basic & Advanced)
- Grouping
- Slices
- Timeline
13) What if Analysis?
14) Consolidation
- 3DSum
- Static Same/Different Data
- Linked Same/Different Data
15) Importing
- Live Data from Web
- Creating & Importing Objects (e.g. PowerPoint,
Videos, PDFs)
16) Exporting
- e.g Printing --> printing page setup, margins,
orientation, page size, print area, break, background,
print titles
17) Dependent Drop Down List
18) Tips & Tricks to Boost your Excel + Misc. Functions
- Speak Cells
- Text to Columns
- Dictionary
- Custom Background Images"
19) Top 10 most useful Shortcuts in Excel
20) Balance Formulas of Excel