Excel Tutorial: Excel: Excel 2013 Beginner - Intermediate

Skillfeed will be shutdown on September 30. Please view additional details here.

Lessons
Comments ()

Videos		Duration

Chapter 1: Introduction
Course overview		5 min
Going over the Ribbons and their Functions		14 min
Going over the Ribbons and their Functions		8 min
Chapter 2: Excel workbooks and worksheets
How to plug in a formula within an excel spreadsheet		7 min
How to add and remove worksheets, and How to rename, copy, and mo		10 min
How to navigate an excel workbook		5 min
Chapter 3: How to enter and edit data in the cell
How to enter text, numbers, and dates in an excel workbook. How t		9 min
How to edit the contents of a cell, and also how to undo and redo		7 min
How to cut, copy, and paste in a workbook, and How how to drag an		9 min
How to use the fill handle of Microsoft excel		8 min
How to insert, and delete cells, columns, and rows.		6 min
How to change column width and row height		4 min
How to hide and unhide columns and rows		6 min
Chapter 4: Basic mathematical operations and functions
Basic Math Formulas		5 min
Order of Operations with BODMAS and Intro to Basic Formulas		9 min
Coying and Pasting Formulas and Functions		6 min
Displaying Formulas on a Worksheet		5 min
Chapter 5: Worksheet formatting and editing
Selecting Cells For Formatting and Modifying Typeface Font, Size,		9 min
Merging And Wrapping Cell Contents		7 min
Using Number Formats		3 min
Cell Content Alignment, Orientation, Adding And Removing Borders		7 min
Applying a date		7 min
Finding And Replacing Formats		5 min
Clearing Cell Contents Vs Clearing Cell Formatting		5 min
Chapter 6: Managing workbooks and worksheets
Worksheet Navigation And Coloured Worksheet Tabs and Moving Or Co		7 min
Viewing And Scrolling Multiple Workbooks At The Same Time and Hid		6 min
Modifying More Than One Worksheet At A Time		3 min
Chapter 7: Setting up the page formatting for printing
Using Print Titles And Print Areas		7 min
Paper Size, Orientation, Margins, And Scaling Options		7 min
Creating Headers and Footers		7 min
Using The Page Break And The Page Layout Views		4 min
Printing A Range Of Cells and Running the Spell Checker		6 min
Controlling Most Print Settings In One Place		3 min
Chapter 8: Formulas and functions
The Sum Function		8 min
Copying Formulas And Functions		6 min
Useful Count Functions		4 min
Absolute Referencing Explained		8 min
Formulas Across Worksheets		8 min
3D Referencing		7 min
Making Use Of Named Cells And Ranges		9 min
Chapter 9: More complicated formatting
Creating Your Own Autofill List		9 min
Converting Data To A Table For Formatting		5 min
Enhancing Worksheets Using Themes and Adding, Editing, And Deleti		6 min
Chapter 10: Protection and security
Activating And Deactivating Worksheet Protection		5 min
Protecting Part Of A Worksheet To Aid Data Entry		5 min
Password Protecting The Whole Workbook		3 min
Ready to use templates		3 min
Chapter 11: Graphical figures and objects
Obtaining And Inserting Online Images		4 min
Using Graphical Objects And Mathematical Formulas		5 min
Inserting Shapes And Screenshots		6 min
Formatting Graphical Objects		6 min
The Stacking Order		7 min
Grouping Multiple Objects Together		7 min
Using Graphical Objects And Mathematical Formulas		5 min
Chapter 12: Charts and how to use them
The New Recommended Charts Option		4 min
Create A Chart Using The Long Or The Short Method and Formatting		9 min
Modifying The Chart Type and Formatting Chart Elements		8 min
Adding A Trendline		3 min
Mini Graphs Sparklines		10 min
Mini Graphs Sparklines		7 min
Chapter 13: Excel and how to use it as a database
Fixing On Screen Rows And Columns		7 min
Fixing Print Rows And Columns and Sorting Data In Excel		10 min
Filtering Data To Reduce Dataset Size		7 min
Removing Duplicate Entries In The Data and Adding Subtotals To A		6 min
Using Text To Columns Effectively		6 min
Linking To Data On A Webpage		4 min
Chapter 14: Advanced and a bit complicated formulas
Using An If Formula		5 min
Use Of The If Function To Hide Excel Error Messages		6 min
Datedif A Useful But Hidden Formula		5 min
Text Manipulation Using Functions		6 min
Use The Text Function To Format Numbers and Date Manipulation Fun		8 min
Introducing Sumif, Countif, And Averageif		6 min
Use Of Rank To Calculate Placings		5 min
Flash Fill		3 min
Chapter 15: More formatting
Altering Cell Appearance Based On The Cell Value		6 min
Displaying Data Bars, Color Scales, Or Icon Sets and Using Top		7 min
Creating A Formatting Rule From Scratch		4 min
Managing The Conditional Formatting Rules		4 min

Overview

The course teaches Microsoft Excel 2013 from the very basics into an intermediate level. As a result the user reaches the level of an intermediate level user. Topics covered such formatting, functions, formulas and advanced tasks with the worksheets are delivered in various sections for detailed description and peculiarities of their usage. By the end of the course you will turn into an Intermediate Microsoft Excel user, capable of using the software in everyday personal or business tasks.

Lessons:	78
Duration:	7 hr 31 min
Subject:	Business
Language:	English
Software:	Excel 2013
Level:	Beginner
Keywords:	excel 2007 , excel charts , excel 2010 , microsoft excel for beginners , excel for prossionals , microsoft excel , microsoft excel 2013 , excell , excel class , excel tutorial , excel course , microsoft excel class , microsoft excel tutorial , microsoft excel training , excel training , excel 2013 professional , microsoft office 2013 more
Released:	08/19/14

Project Files:

About the Instructor

Serop Serop

Optimum is a leading educational center specialized in the IT field. We have over 3 years of experience in teaching different subjects. The study groups have been developed and taught based on specific practical syllabuses. Our center has around 850 graduates, who have successfully completed our courses in the physical location of our center. Developing and advancing our programs, currently we are bringing our experience to the global market. We guarantee that you will be delivered the most up to date and practical content provided by our professional instructors. Optimum IT Center is: - High-level educational center specialized in IT (Information Technologies) sphere - Professional training and re-training center for the professionals of the IT sphere - A chaining element between the Job Market of IT sphere and potential employees delivering practical knowledge - A team consisting of experienced professionals in the relevant fields.

Related Courses

Excel: Excel 2013 Beginner - Intermediate

Get unlimited access now