2013
Infinite Skills
Guy Vaccaro
7:45
English
In this Microsoft Excel 2013 training course, veteran trainer Guy Vaccaro takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but Guy breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel or spreadsheets is required to get the most out of this Excel beginners video training.
You will start with the absolute basics, creating and saving a new workbook. Guy proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.
By the time you have completed this video training course for Microsoft Excel 2013, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training video.

01. Start Here
0101 Getting Started With Excel 2013
0102 The Excel Workbook Explained
0103 Signing Up For Your Own Free SkyDrive
0104 Customize The Quick Access Toolbar
0105 Using The Included Working Files
0106 About The Author
02. Managing Excel Workbooks And Worksheets
0201 Creating And Saving A New Workbook
0202 Opening Workbooks And Save As Options
0203 Saving And Opening SkyDrive Files
0204 Navigating An Excel Workbook
0205 Adding And Removing Worksheets
0206 Renaming Copying And Moving Worksheets
03. Entering And Editing Data In Cells
0301 Entering Text, Numbers, And Dates
0302 Entering Numbers As Text
0303 Editing The Contents Of A Cell
0304 Undo And Redo Actions
0305 Cut, Copy, And Paste
0306 Dragging And Dropping Cells
0307 The Fill Handle
0308 Inserting And Deleting Cells Columns And Rows
0309 Changing Column Widths And Row Heights
0310 Hiding And Un-Hiding Columns And Rows
0311 Searching For Values In A Workbook
04. Math Basics
0401 Getting Started With Basic Math Formulas
0402 Order Of Operation With BODMAS
0403 Introduction To Basic Formulas
0404 Copying Formulas And Functions
0405 Displaying Formulas On A Worksheet
05. Formatting Worksheets
0501 Selecting Cells For Formatting
0502 Modifying Typeface Font, Size, And Colour
0503 Merging And Wrapping Cell Contents
0504 Using Number Formats
0505 Cell Content Alignment And Orientation
0506 Adding And Removing Borders From A Selection
0507 Applying A Date Format To A Cell Or Range
0508 The Format Painter
0509 Finding And Replacing Formats
0510 Clearing Cell Contents Vs. Clearing Cell Formatting
06. Workbook And Worksheet Management
0601 Worksheet Navigation And Coloured Worksheet Tabs
0602 Moving Or Copying Worksheets Within And Between Workbooks
0603 Viewing And Scrolling Multiple Workbooks At The Same Time
0604 Hiding And Un-Hiding Sheets
0605 Modifying More Than One Worksheet At A Time
07. Page Setup And Printing
0701 Using Print Titles And Print Areas
0702 Paper Size, Orientation, Margins, And Scaling Options
0703 Creating Headers and Footers
0704 Using The Page Break And The Page Layout Views
0705 Printing A Range Of Cells
0706 Running The Spell Checker
0707 Controlling Most Print Settings In One Place
08. Mathematical Formulas
0801 The Sum Function
0802 Copying Formulas And Functions
0803 Other Mathematical Functions: Average, Min, And Max
0804 Useful Count Functions
0805 Absolute Referencing Explained
0806 Formulas Across Worksheets
0807 3D Referencing
0808 Making Use Of Named Cells And Ranges
09. Advanced Formatting
0901 Enhancing Worksheets Using Themes
0902 Adding, Editing, And Deleting Comments
0903 Creating Your Own Autofill List
0904 Converting Data To A Table For Formatting
10. Security
1001 Activating And Deactivating Worksheet Protection
1002 Protecting Part Of A Worksheet To Aid Data Entry
1003 Password Protecting The Whole Workbook
11. Excel 2013 Templates
1101 Using The 2013 Templates
1102 Creating And Using Your Own Template
12. Graphics Objects
1201 Obtaining And Inserting Online Images
1202 Using SmartArt Graphics
1203 Inserting Shapes And Screenshots
1204 Formatting Graphical Objects
1205 The Stacking Order
1206 Grouping Multiple Objects Together
1207 Using Graphical Objects And Mathematical Formulas
13. Using Charts In Excel
1301 The New Recommended Charts Option
1302 Create A Chart Using The Long Or The Short Method
1303 Formatting A Chart With The 2013 Shortcut Options
1304 Modifying The Chart Type
1305 Formatting Chart Elements
1306 Adding A Trendline
1307 The Pie Chart In Detail
1308 Mini Graphs: Sparklines
14. Excel As A Database
1401 Fixing On Screen Rows And Columns
1402 Fixing Print Rows And Columns
1403 Sorting Data In Excel
1404 Filtering Data To Reduce Dataset Size
1405 Removing Duplicate Entries In The Data
1406 Adding Subtotals To A Worksheet Of Data
1407 Using Text To Columns Effectively
1408 Linking To Data On A Webpage
15. Advanced Formulas
1501 Using An If Formula
1502 Use Of The If Function To Hide Excel Error Messages
1503 Datedif: A Useful But Hidden Formula
1504 Text Manipulation Using Functions
1505 Use The Text Function To Format Numbers
1506 Date Manipulation Functions
1507 Introducing Sumif, Countif, And Averageif
1508 Use Of Rank To Calculate Placings
1509 Flash Fill: The Magic Touch
16. Conditional Formatting
1601 Altering Cell Appearance Based On The Cell Value
1602 Displaying Data Bars, Color Scales, Or Icon Sets
1603 Using Top And Bottom Rules For Formatting
1604 Creating A Formatting Rule From Scratch
1605 Managing The Conditional Formatting Rules
17. What's Next
1701 The New Office Apps For Excel 2013
1702 Ready To Go Advanced

http://www.infiniteskills.com/training/learning-microsoft-excel-2013.html

Download File Size:1.15 GB

---