MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Microsoft Excel 2013 Course Beginners/ Intermediate Training

Course Summary

Learn to Master Microsoft Excel In Easy To Follow Step-By-Step Training Course. Comes With Extensive Working Files

• +

Course Syllabus

• 01. Start Here
• 0101 Let's Get Started With Excel 2013
• 0102 The Excel Workbook Explained
• 0103 Signing Up For Your Own Free SkyDrive
• 0105 Using The Included Working Files
• How to obtain your Certificate of Completion for this Infinite Skills course.
• 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
• 205 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
• 0901 Enhancing Worksheets Using Themes
• 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
• 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
• 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

Course Fee:
USD 99

Self-Study

Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: