Devam Ediyor

Create a Tutorial Video Series for Microsoft Excel 2016

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,


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,


- If Function

- Nested IF

- AND fucntion

- Not and If Error

- View Dependence & Precedence

- Name Range + Formulas

8) Cell referencing: Relative, Absolute & Mixed


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

Beceriler: Veri Girişi, Veri İşleme, Excel, Ses Yeteneği, Word

Daha fazlasını gör: create gpa calculator microsoft excel 2007, create live update microsoft excel tradestation, create invoices microsoft excel macros, excel tutorial pdf, best excel tutorial, microsoft excel advanced tutorial, excel tutorial for beginners, excel 2016 tutorial for beginners pdf, excel tutorial youtube, microsoft excel tutorial, excel 2016 tutorial pdf, create tutorial recorded video, create business contact list microsoft excel, create contact list microsoft excel, create lynda tutorial video, create tutorial video, video record microsoft excel, create a tutorial video, i need someone that can help me in copy typing and key in about 500 data in microsoft excel, microsoft excel 2007 tutorial

İşveren Hakkında:
( 0 değerlendirme ) India

Proje NO: #17728467



We are data analytics company with experienced professionals in data science, Data visualization, Machine learning, Python, predictive and exploratory analytics. We will deliver project on time and with quality. We h Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 27777%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)

Bu iş için 17 freelancer ortalamada ₹26101 teklif veriyor


I have a good hands on working with Advanced R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Applications using flask/ Daha Fazla

in %bids___i_period_sub_35% gün içinde35000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(48 Değerlendirme)
in %bids___i_period_sub_35% gün içinde12500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

i will provide you the tutorial series with perfection and accuracy. i assure you that the audio will be audible. since i am myself a computer science engineer you can trust me.

in %bids___i_period_sub_35% gün içinde13888%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde27777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

best in word excel and you tube video creation. creative unique ideas in video making and power point presentation.

in %bids___i_period_sub_35% gün içinde27777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello there! I have read your post and would love to offer my service to share my knowledge to your Online video streaming website. I am a blogger but I am working as a full-time freelancer. I have worked as a call Daha Fazla

in %bids___i_period_sub_35% gün içinde27777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde27777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello. I'm really experienced in Microsoft programs so I think I could make a really informational and professional looking video for your YouTube channel. Best, Isidora C.

in %bids___i_period_sub_35% gün içinde22222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Do not worry, I'm going to do it all in a very short time Relevant Skills and Experience Do not worry, I'm going to do it all in a very short time

in %bids___i_period_sub_35% gün içinde27777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I read the project details its done effectively as your expectation result will be given by [login to view URL] i very carefully completed this project at given time.

in %bids___i_period_sub_35% gün içinde27777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde33333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
in %bids___i_period_sub_35% gün içinde12500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, I'm Drex. I'm a tech-savvy that's highly proficient in Microsoft programs esp Excel. I also have great command in English language and also scored 80-82 WPM in several typing tests. Here is a little info about Daha Fazla

in %bids___i_period_sub_35% gün içinde30000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

We are a team of certified IT professional with vast experience as professional trainers and content development.

in %bids___i_period_sub_35% gün içinde27777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Dear Sir/Madam, Thank you for posting your requirement. My name is Inderjeet and I run a small It services firm based at Chandigarh, India. We have been into IT since 1994 (Lotus 123 was the spreadsheets then). Y Daha Fazla

in %bids___i_period_sub_35% gün içinde35400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am a finance professional from Sydney. I have extensive experience in financial modelling with two of the major banks in Australia. You can see my LinkedIn profile here: [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde26666%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)