filmov
tv
Excel 2013 Tutorial for Beginners #64: Formatting the Data, Type, Location, and Elements of a Chart
Показать описание
Excel 2013 Tutorial for Beginners #64: Formatting the Data, Type, Location, and Elements of a Chart
In this Excel tutorial we’ll discuss how to format the data, type, location, and/or elements of an existing chart within a Microsoft Excel workbook.
This is video 64 of 93 in our “Excel 2013 Tutorial for Beginners” Series.
For those of you interested, go ahead and…
Feel free to give us a thumbs up, a thumbs down, or leave a comment. Your feedback is much appreciated!!!
Cheers,
Tolan
Excel 2013 Tutorial for Beginners- Full Course (93 Lessons)
#01: What is Excel?
#02: Using Excels Menu System
#03: Using the Quick Access Toolbar
#04: The Structure of A Worksheet Or Workbook
#05: Using the Formula Bar
#06: Using the Status Bar
#07: Navigating Worksheets & Workbooks
#08: Shortcut Menus and the Mini Toolbar
#09: Using Excel's Built-in Help Function
#10: Creating New File; Saving That File
#11: Opening Existing File; Using Save As
#12: Entering Data
#13: Editing Data
#14: Undo & Redo
#15: Making Desired Selection
#16: Using the Fill Handle
#17: Autocomplete & AutoFill
#18: Entering Basic Math Formulas, Totals, and Averages in Excel
#19: Replicating Formula from a Near-by Cell
#20: Applying Varying Formulas Based on Cell's Context
#21: Quickly Remembering Order of Operations in with a Function
#22: Using Relative, Absolute, and Mixed References
#23: Exploring Basic Excel Functions – SUM
#24: Exploring Basic Excel Functions – AVERAGE
#25: Exploring Basic Excel Functions - MIN & MAX
#26: Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK
#27: Exploring Basic Excel Functions - PRODUCT
#28: Inserting and Deleting Columns & Rows
#29: Hiding and Unhiding Columns & Rows
#30: Changing the Widths and Heights of Columns & Rows
#31: Wrapping Text
#32: Merging Contents from Multiple Cells
#33: Adding, Modifying, and Removing Cell Borders
#34: Modifying Cell Font - Typeface, Size, Style, Color, Etc.
#35: Using Cell Alignment - Left, Center, and Right
#36: Using Cell Alignment - Top, Middle, and Bottom
#37: Using Cell Orientation - Angled, Horizontal, and Vertical
#38: Applying Different Number Formats
#39: Adjusting the Number of Decimals Displayed
#40: Using the Format Painter
#41: Using Paste Special for Formatting
#42: Clearing Cell Formatting
#43: Clearing Cell Contents AND Formatting
#44: Inserting & Using Shapes
#45: Inserting Pictures & Other Visual Elements
#46: Sorting Data
#47: Inserting Subtotals within Active Worksheet
#48: Filtering Data
#49: Data Tool: Text to Columns (Delimited)
#50: Data Tool: Text to Columns (Fixed Width)
#51: New to Excel 2013: Using Flash Fill
#52: Removing Duplicates from Selected Range
#53: Getting Started with Tables
#54: Inserting Tables & Understanding Contextual Tabs
#55: Modifying Table Formatting & Design
#56: Filtering a Table & Using the Search Functionality
#57: Adding Rows & Columns to a Table
#58: Converting a Table to a Range
#59: Getting Started with Charts
#60: Inserting Charts in Excel
#61: New to Excel 2013: Recommended Charts
#62: Understanding Chart Data & Chart Elements
#63: Modifying Chart Type
#64: Formatting the Data, Type, Location, and Elements of a Chart
#65: Modifying Chart Axis, Labels, Gridlines, Etc.
#66: Copying & Pasting Charts in Excel
#67: New to Excel 2013: Sparklines (In-Cell "Mini"Graphs)
#68: Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Worksheet)
#69: Dragging & Dropping Contents (between Multiple Worksheets)
#70: Cutting, Copying, and Pasting (in Same Worksheet)
#71: Cutting, Copying, and Pasting (between Multiple Worksheets)
#72: Using Paste Special for More than Formatting
#73: Finding & Replacing Cell Contents
#74: Using Spellcheck in Excel
#75: Adding Comments to a Worksheet
#76: Freezing & Unfreezing Panes in Active Sheet
#77: Splitting Screens in Excel (Horizontally & Vertically)
#78: Displaying Multiple Worksheets or Workbooks
#79: Renaming a Worksheet ; Coloring a Worksheet
#80: Inserting & Deleting Worksheets
#81: Moving, Copying, and Grouping Sheets
#82: Modifying Multiple Worksheets Simultaneously
#83: Print Setting, Print Preview, and the Print Menu
#84: Page Layout - Size, Orientation, and Margins
#85: Using Headers & Footers
#86: Using Print Titles
#87: Defining Print Areas
#88: Using Page Layouts & Understanding Page Breaks
#89: Locking & Unlocking Individual Worksheets within a Workbook
#90: Protecting Specific Cells within a Given Worksheet
#91: Assigning Passwords to Protect an Entire Workbook
#92: Sharing Workbooks
#93: Tracking changes within a Workbook
In this Excel tutorial we’ll discuss how to format the data, type, location, and/or elements of an existing chart within a Microsoft Excel workbook.
This is video 64 of 93 in our “Excel 2013 Tutorial for Beginners” Series.
For those of you interested, go ahead and…
Feel free to give us a thumbs up, a thumbs down, or leave a comment. Your feedback is much appreciated!!!
Cheers,
Tolan
Excel 2013 Tutorial for Beginners- Full Course (93 Lessons)
#01: What is Excel?
#02: Using Excels Menu System
#03: Using the Quick Access Toolbar
#04: The Structure of A Worksheet Or Workbook
#05: Using the Formula Bar
#06: Using the Status Bar
#07: Navigating Worksheets & Workbooks
#08: Shortcut Menus and the Mini Toolbar
#09: Using Excel's Built-in Help Function
#10: Creating New File; Saving That File
#11: Opening Existing File; Using Save As
#12: Entering Data
#13: Editing Data
#14: Undo & Redo
#15: Making Desired Selection
#16: Using the Fill Handle
#17: Autocomplete & AutoFill
#18: Entering Basic Math Formulas, Totals, and Averages in Excel
#19: Replicating Formula from a Near-by Cell
#20: Applying Varying Formulas Based on Cell's Context
#21: Quickly Remembering Order of Operations in with a Function
#22: Using Relative, Absolute, and Mixed References
#23: Exploring Basic Excel Functions – SUM
#24: Exploring Basic Excel Functions – AVERAGE
#25: Exploring Basic Excel Functions - MIN & MAX
#26: Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK
#27: Exploring Basic Excel Functions - PRODUCT
#28: Inserting and Deleting Columns & Rows
#29: Hiding and Unhiding Columns & Rows
#30: Changing the Widths and Heights of Columns & Rows
#31: Wrapping Text
#32: Merging Contents from Multiple Cells
#33: Adding, Modifying, and Removing Cell Borders
#34: Modifying Cell Font - Typeface, Size, Style, Color, Etc.
#35: Using Cell Alignment - Left, Center, and Right
#36: Using Cell Alignment - Top, Middle, and Bottom
#37: Using Cell Orientation - Angled, Horizontal, and Vertical
#38: Applying Different Number Formats
#39: Adjusting the Number of Decimals Displayed
#40: Using the Format Painter
#41: Using Paste Special for Formatting
#42: Clearing Cell Formatting
#43: Clearing Cell Contents AND Formatting
#44: Inserting & Using Shapes
#45: Inserting Pictures & Other Visual Elements
#46: Sorting Data
#47: Inserting Subtotals within Active Worksheet
#48: Filtering Data
#49: Data Tool: Text to Columns (Delimited)
#50: Data Tool: Text to Columns (Fixed Width)
#51: New to Excel 2013: Using Flash Fill
#52: Removing Duplicates from Selected Range
#53: Getting Started with Tables
#54: Inserting Tables & Understanding Contextual Tabs
#55: Modifying Table Formatting & Design
#56: Filtering a Table & Using the Search Functionality
#57: Adding Rows & Columns to a Table
#58: Converting a Table to a Range
#59: Getting Started with Charts
#60: Inserting Charts in Excel
#61: New to Excel 2013: Recommended Charts
#62: Understanding Chart Data & Chart Elements
#63: Modifying Chart Type
#64: Formatting the Data, Type, Location, and Elements of a Chart
#65: Modifying Chart Axis, Labels, Gridlines, Etc.
#66: Copying & Pasting Charts in Excel
#67: New to Excel 2013: Sparklines (In-Cell "Mini"Graphs)
#68: Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Worksheet)
#69: Dragging & Dropping Contents (between Multiple Worksheets)
#70: Cutting, Copying, and Pasting (in Same Worksheet)
#71: Cutting, Copying, and Pasting (between Multiple Worksheets)
#72: Using Paste Special for More than Formatting
#73: Finding & Replacing Cell Contents
#74: Using Spellcheck in Excel
#75: Adding Comments to a Worksheet
#76: Freezing & Unfreezing Panes in Active Sheet
#77: Splitting Screens in Excel (Horizontally & Vertically)
#78: Displaying Multiple Worksheets or Workbooks
#79: Renaming a Worksheet ; Coloring a Worksheet
#80: Inserting & Deleting Worksheets
#81: Moving, Copying, and Grouping Sheets
#82: Modifying Multiple Worksheets Simultaneously
#83: Print Setting, Print Preview, and the Print Menu
#84: Page Layout - Size, Orientation, and Margins
#85: Using Headers & Footers
#86: Using Print Titles
#87: Defining Print Areas
#88: Using Page Layouts & Understanding Page Breaks
#89: Locking & Unlocking Individual Worksheets within a Workbook
#90: Protecting Specific Cells within a Given Worksheet
#91: Assigning Passwords to Protect an Entire Workbook
#92: Sharing Workbooks
#93: Tracking changes within a Workbook
0:16:17
1:54:45
0:15:54
1:01:56
0:32:49
0:10:13
0:13:52
0:04:18
0:09:54
0:21:47
0:09:40
0:14:27
0:06:06
0:12:29
2:06:45
0:13:19
0:52:40
0:20:18
0:32:09
0:27:49
0:16:09
3:03:16
0:50:48
0:28:42