Find Jobs
Hire Freelancers

Create a Tutorial Video Series for Microsoft Excel 2016

₹12500-37500 INR

Færdiggjort
Slået op over 5 år siden

₹12500-37500 INR

Betales ved levering
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
Projekt-ID: 17728467

Om projektet

17 forslag
Projekt på afstand
Aktiv 6 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
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 have completed projects for market analysis for local business firms and technology training firms. Happy to hear from you about the project. There wont be any compromise in quality . please visit us at [login to view URL] for more details.
₹27.777 INR på 10 dage
0,0 (0 anmeldelser)
0,0
0,0
17 freelancers are bidding on average ₹26.101 INR for this job
Brug Avatar.
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/django. My area of expertise is building financial models (Stock Markets) , Image Processing and building models for food, healthcare and telecom sector, Classification/Prediction/Clustering, NLP and Chatbots. Specifically, I have worked for log on stock data and model building for the same. I understand the project requirement and will deliver the desired product within the time specified. I would like to hear from you. Thanks Shivam
₹35.000 INR på 10 dage
4,9 (49 anmeldelser)
6,4
6,4
Brug Avatar.
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.
₹13.888 INR på 6 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
best in word excel and you tube video creation. creative unique ideas in video making and power point presentation.
₹27.777 INR på 10 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 center agent before as a technical support and were taught excel basics since I started freelance jobs, I learned the basics and almost all the tricks about excel. I would love to offer my support and ideas towards video making. I have a youtube channel and is a youtuber too. I have worked full time organizing data's from video or audio to pdf files and organizing data's for the client. Please let me know if you would be interested to check all my details. All the best, Bevs
₹27.777 INR på 10 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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.
₹22.222 INR på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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
₹27.777 INR på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 myself. Philippine- licensed Mechanical Engineer, with excellent knowledge in mechanical engineering laws and principles in automotive, HVAC, refrigeration, machine design and general mathematics and statistics, determined to learn, improve and immediately make an impact to the team and the company. Aside from my academic background, I'm a tech-savvy that pays a great attention to detail and competitive in doing any job using all the skills on my arsenal into delivering the best results in the fastest time possible. I hope you consider working with me on this project and I look forward into working with you.
₹30.000 INR på 14 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
We are a team of certified IT professional with vast experience as professional trainers and content development.
₹27.777 INR på 10 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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). You have clearly defined the topics to be covered. However, it is unclear if your budget is for the total or for major parts. Covering full Excel properly needs time and effort and a lot of editing is also needed at times. We can give you ready videos based on the topics listed but am not sure if the work first the budget. Kindly clarify so that we may consider the work further. I'll provide a sample once we decide to move forward. Looking forward to hearing from you. Please feel free to ask any questions you may have. Thank you. Yours Sincerely, Inderjeet Singh Sodhi (jhjk11092018jmljk)
₹35.400 INR på 21 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for INDIA
India
0,0
0
Betalingsmetode verificeret
Medlem siden aug. 10, 2018

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.