Главная
Клипы
Новинки
Тренды
Популярные
Лайки
Комментарии
Все категории
Музыка
Фильмы
Видеоигры
Транспорт
Животные
Спорт
Путешествия
Люди и блоги
Юмор
Развлечения
Политика
Хобби
Образование
Наука
Организации
Найти
09-06 Use Excel CheckBox values in formulas without VBA
The Smart Method
22 тыс. подписчиков
Скачать
168 видео с канала:
The Smart Method
09-06 Use Excel CheckBox values in formulas without VBA
Скачать
09-05 Add an Excel check box form control to a worksheet without VBA
Скачать
09-04 Use the Excel PMT function to create a mortgage calculator
Скачать
09-03 Set Cell Links for Excel Combo Box & Group Box (Option Buttons)
Скачать
09-01 Add Group Box and Option Button form controls without VBA
Скачать
03-07 Excel Date and Time - Everything you need to know.
Скачать
Lesson 03-06 Use the Excel SUMIF and COUNTIF functions
Скачать
03-24 Use a VLOOKUP function for an inexact lookup
Скачать
03-22 Use a VLOOKUP function for an exact lookup.
Скачать
03-05 Use the Excel IF function
Скачать
09-17 Run an Excel macro from a button control
Скачать
09-13: Implement Macro Security
Скачать
09-12 Understand Macro Security, Trusted Folders and Trusted Documents
Скачать
4-1: Change Date Format in Excel (Apr-10-21, 04/10/21, 10/4/21 etc)
Скачать
7-10: Print Selected Cells from an Excel Worksheet (Set Print Area)
Скачать
7-11: Print Row and Column Titles on Every Page and Print Gridlines
Скачать
7-13: Hide Error Messages in Excel Printouts, but Still Show on Screen
Скачать
7-12: Change The Excel Print Order (Down Then Over or Over Then Down)
Скачать
Excel Essential Skills Course - Session 4: Making Your Worksheets Look Professional
Скачать
8-6: OneDrive, Share Microsoft Office Files as Read Only or Read/Write
Скачать
8-5: Open a File Using Office Online (the FREE Office Version)
Скачать
8-3: A Simple Guide to Operating systems, Devices and Office Versions
Скачать
8-2: Open an Excel Workbook From a OneDrive
Скачать
8-1: Save an Excel Workbook to a OneDrive
Скачать
6-8: Excel Find and Replace - Expert Guide Covering All Features
Скачать
6-7: Select Multiple Worksheets to Create Excel 3-D Worksheet Groups
Скачать
6-6: How To Create Formulas That Reference Other Excel Worksheets
Скачать
6-5: Hide and Unhide Excel Worksheets
Скачать
6-4: Move and Copy Worksheets Between Workbooks (Merge and Combine)
Скачать
6-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets
Скачать
6-2: View Two Excel Workbooks Side By Side With Synchronous Scrolling
Скачать
6-1: View the Same Excel Workbook in Two Side-by-Side Windows
Скачать
7-9: Different Excel Headers and Footers for First, Odd and Even Pages
Скачать
7-8: Add Custom Headers and Footers to a Printed Excel Worksheet
Скачать
7-6: Insert, Move & Remove Excel Page Breaks Using Page Break Preview
Скачать
7-5: Insert and Delete Page Breaks without using Page Break Preview
Скачать
7-4: Fit All Excel Columns on One Printed Page with Excel Scale To Fit
Скачать
7-3: Perfectly Center an Excel Printout and Set Custom Margins
Скачать
Excel Essential Skills - Session 8: Cloud Computing - Introduction
Скачать
Excel Essential Skills Course - Session 7: Printing Your Work - Introduction
Скачать
Essential Skills - Session 6: Working With Multiple Worksheets and Workbooks
Скачать
7-1: Excel Paper Orientation (Portrait or Landscape) and Print Preview
Скачать
Excel Essential Skills - Session 5: Charts and Graphics
Скачать
5-27: Create an Excel Chart Template
Скачать
5-26: Add a Gradient Fill to an Excel Chart Area Background
Скачать
5-23: Add A Second Vertical (Y) Axis to an Excel Chart (Combo Chart)
Скачать
5-22: Excel Pie Chart Features - Rotate, Perspective, Pull Out Slice
Скачать
5-21: Change Excel Chart Scale - Vertical (Y) Axis Start & End Values
Скачать
5-20: Add an Excel Text Box and Arrow Shape to an Excel Chart
Скачать
5-19: Add Data Labels to an Excel Chart From a Cell Range
Скачать
5-18: Add and Format Data Labels and add a Data Table an Excel Chart
Скачать
5-17: Connect Empty Data Points or Show as a Gap in Excel Charts.
Скачать
5-16: Use Numbers on the X Axis of an Excel Chart
Скачать
5-15 Chart Non-Adjacent (Non Contiguous) Data by Hiding Columns & Rows
Скачать
5-14 Change Excel Chart Source Data using the Select Data Source dialog
Скачать
5-13: Understand Excel Chart Data Series and Excel Chart Categories
Скачать
5-12: Assign Data From Multiple Ranges (Non-Contiguous) to a Chart
Скачать
5-11: Change an Excel Chart Source Data (Select Data Source Dialog)
Скачать
5-10: Apply an Excel Chart Filter
Скачать
5-9: Move, Re-Size, Add, Position and Delete Excel Chart Elements
Скачать
5-8: Format Excel 3-D Elements and Add Drop Shadows
Скачать
5-7: Manually format an Excel chart element
Скачать
5-6: Use the Chart Styles Gallery to Apply a Chart Style and Color Set
Скачать
5-5: Add and Remove Chart Elements using Quick Layout
Скачать
5-4: Create an Excel chart using Recommended Charts & Quick Analysis
Скачать
5-3: Change Chart Style and Move, Re-Size, Copy & Name an Excel Chart
Скачать
5-2: Create an Excel Chart with Two Clicks
Скачать
5-1: Understand Excel Chart Types, Chart Layouts and Chart Styles
Скачать
4 -23: How To Rotate Text in Excel (Vertical, Horizontal and Angled)
Скачать
4-22: Two Ways to Use the Format Painter (Sticky and One-Time)
Скачать
4-21: Apply a Date Axis Type to an Excel Sparkline group
Скачать
4-19: Insert Excel Sparklines - Line Type, Column Type and Win/Loss
Скачать
4-18: Conditional Formatting with Formulas - Defining Custom Rules
Скачать
4-17: Insert Data Bars, Color Scales and Icon Sets into Excel cells.
Скачать
4-16: Advanced Conditional Formatting Using the Rules Manager
Скачать
4-14: Use an Excel Master Style Book to Merge Custom Styles
Скачать
4-13: Create Excel Custom Cell Styles
Скачать
4-12: Create Your Own Excel Custom Theme
Скачать
4-11: Apply or Draw Borders around Excel cells
Скачать
4-10: How To Add a Gradient Effect (Gradient Fill) to Excel Cells
Скачать
4-9: How To Use Excel Cell Styles to Create Beautiful Worksheets
Скачать
4-7: Vertical Alignment of Excel Cells. Top, Bottom, Middle, Justify
Скачать
4-6: Join Two Cells into One With Excel Merge & Center (inc Wrap Text)
Скачать
4-5: Excel Horizontal Alignment - Left, Right, Center, Justify, Fill
Скачать
4-4: Use Excel Custom Number Formats to apply ANY number format.
Скачать
4-3: Solve Excel Rounding Errors with the ROUND function.
Скачать
4-20: Apply a Common Vertical Axis and Formatting to a Sparkline Group
Скачать
Excel Essential Skills Course - Session 2: Doing Useful Work with Excel
Скачать
3-20: Check spelling in an Excel workbook
Скачать
3-19: Split the Excel window into multiple panes
Скачать
3-18: Freeze columns and rows (Freeze Panes)
Скачать
3-17: Add an Add-In (App) to an Excel workbook
Скачать
3-16: Use an Excel template
Скачать
3-14: Understand Templates and Set a Custom Template Folder Location.
Скачать
3-13: Understand mixed cell references (A&1, $A1).
Скачать
3-3: Cut, copy and paste includes Keyboard Shortcut Keys
Скачать
3-11: Print Excel Cell Comments at the End of, or Within a Worksheet
Скачать
3-10: Show and Hide Excel Comments (Create Sticky Comments)
Скачать
3-9: Insert cell comments
Скачать
3-8: Use Undo and Redo (includes shortcut keys)
Скачать
3-7: Use the Multiple Item Office Clipboard and Clipboard Task Pane
Скачать
3-6: Transpose a range
Скачать
3 5: Use Paste Values and increase/decrease decimal places displayed
Скачать
3-2: Use AutoComplete, Pick from Drop Down List and Fill Down features
Скачать
3-1: Insert and delete Excel rows and columns (inc shortcut keys)
Скачать
3 4: Cut, copy and paste using drag and drop (mouse & Ctrl key method)
Скачать
Excel Essential Skills - Session 3: Taking Your Skills to the Next Level
Скачать
Excel Essential Skills Course - Session 1: Basic Skills
Скачать
09-10: Record Your First Excel Macro (Short, Comprehensive Tutorial)
Скачать
Excel Expert Lesson 5-8: Filter a pivot table visually using slicers
Скачать
Excel Expert Lesson 6-9: Understand many-to-many relationships
Скачать
Excel Expert Lesson 6-1: Understand primary and foreign keys
Скачать
Excel Expert Lesson 8-10: Understand the three different ways to share a workbook
Скачать
09-02: Add a Combo Box (Drop-Down List) form control without VBA
Скачать
Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence.
Скачать
8-4: Microsoft Office Online (the FREE Office Version) 3 Minute Guide
Скачать
8-7: Edit a Workbook Simultaneously With Others Using Excel Online
Скачать
7-7: Insert an Excel Header and Footer With Page Numbers on Every Page
Скачать
4-2: Understand Date Serial Numbers and Date Arithmetic
Скачать
5-24: Create an Excel Custom Combo Chart Using Different Chart Types
Скачать
7-2: Use Page Layout view to adjust margins
Скачать
3-15: Create an Excel template
Скачать
5-25: Add a Trend Line and Moving Average to an Excel Chart
Скачать
4-15: Use Excel Conditional Formatting based on Dates, Values and Text
Скачать
3-12: Understand Excel absolute ($A$1)and relative (A1) cell references
Скачать
4-8: Excel Themes Tutorial (Font Set, Color Set and Effects Set)
Скачать
2-18: Use Excel Flash Fill to split Delimited Text
Скачать
2-16: Use Excel AutoFill Date options - Days, Weekdays, Months & Years
Скачать
2-23: Printing in Excel (ALL Backstage Print Options inc. Scaling)
Скачать
2-17: Create Custom AutoFill Lists (series) & other Autofill Pro Tips
Скачать
2-20: Use Flash Fill Artificial Intelligence (Expert Tutorial)
Скачать
2-21: Use Excel Flash Fill to Solve Real-World Business Problems
Скачать
2-15: How AutoFill Adjusts Cell References in Excel Formulas
Скачать
2-19: Use Flash Fill to Reformat A Phone Number (Expert Tutorial)
Скачать
2-22: Zoom In and Zoom Out of an Excel worksheet
Скачать
2-7: Select Non-Contiguous (Non-Adjacent) Cell Ranges
Скачать
1-11: How to recover an earlier version of an Excel workbook
Скачать
2-4: Select a range of cells and understand Smart Tags
Скачать
2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.
Скачать
1-12: Show/Hide the Excel Ribbon and use Tabs, Groups and Commands.
Скачать
1-2: Check that your Excel version is up to date
Скачать
2-12: Create Excel formulas the correct, professional way
Скачать
1-17: Use Full Screen Views by Hiding the Formula Bar and Ribbon
Скачать
1-10: How to Recover a Deleted, Unsaved or Lost Excel file
Скачать
2-14: Use AutoFill Excel Series (Months, Days, Dates, Numbers & Text)
Скачать
1-3: How To Change the Office Theme
Скачать
2-2: Open and view two Excel workbooks at the same time
Скачать
2-3: Use AutoSum to quickly calculate totals
Скачать
1-15: Use Keyboard Shortcuts for absolutely ANY Excel command.
Скачать
2-6: How To Select Multiple Excel Rows and Columns
Скачать
2-1: Enter and Edit Text and Numbers in an Excel Worksheet
Скачать
1-13: Understand Ribbon components
Скачать
1-6: How to save an Excel workbook to a local file
Скачать
2-10: Use AutoSum to sum a non-contiguous (non adjacent) range
Скачать
1-1: Open an Excel Workbook
Скачать
1-18: Use the help system * Now Deprecated *
Скачать
1-16: Excel Views - Normal, Page Break Preview and Page Layout
Скачать
2-5: Speed Data Entry: Enter, Tab, Shift+Tab, Shift+Enter & Ctrl+Enter
Скачать
1-4: Maximize, minimize, re-size, move and close the Excel window
Скачать
1-5: Navigate Large Excel Worksheets with Scroll Bars & Shortcut Keys
Скачать
1-8: Pin an Excel Workbook & Organize Files (File & Folder Management)
Скачать
2-13: Create Any Excel Function Faster and Easier using AutoComplete
Скачать
2-8: Keyboard Shortcuts to Select an Range Of Cells within a Block.
Скачать
1-7: Understand Common Excel file formats (XLSX, XLSM, XLSB, XLS, PDF)
Скачать
1-14: Customize the Quick Access Toolbar
Скачать
1-9: Excel Worksheet tabs - Everything There Is To Know
Скачать
2-9: Automatically Re-size Multiple Excel Rows and Columns
Скачать
Excel 2007 Course: Lesson 2-3 Use AutoSum to quickly calculate totals
Скачать
Канал: The Smart Method
09-06 Use Excel CheckBox values in formulas without VBA
Скачать
09-05 Add an Excel check box form control to a worksheet without VBA
Скачать
09-04 Use the Excel PMT function to create a mortgage calculator
Скачать
09-03 Set Cell Links for Excel Combo Box & Group Box (Option Buttons)
Скачать
09-01 Add Group Box and Option Button form controls without VBA
Скачать
03-07 Excel Date and Time - Everything you need to know.
Скачать
Lesson 03-06 Use the Excel SUMIF and COUNTIF functions
Скачать
03-24 Use a VLOOKUP function for an inexact lookup
Скачать
03-22 Use a VLOOKUP function for an exact lookup.
Скачать
03-05 Use the Excel IF function
Скачать
09-17 Run an Excel macro from a button control
Скачать
09-13: Implement Macro Security
Скачать
09-12 Understand Macro Security, Trusted Folders and Trusted Documents
Скачать
4-1: Change Date Format in Excel (Apr-10-21, 04/10/21, 10/4/21 etc)
Скачать
7-10: Print Selected Cells from an Excel Worksheet (Set Print Area)
Скачать
7-11: Print Row and Column Titles on Every Page and Print Gridlines
Скачать
7-13: Hide Error Messages in Excel Printouts, but Still Show on Screen
Скачать
7-12: Change The Excel Print Order (Down Then Over or Over Then Down)
Скачать
Excel Essential Skills Course - Session 4: Making Your Worksheets Look Professional
Скачать
8-6: OneDrive, Share Microsoft Office Files as Read Only or Read/Write
Скачать
8-5: Open a File Using Office Online (the FREE Office Version)
Скачать
8-3: A Simple Guide to Operating systems, Devices and Office Versions
Скачать
8-2: Open an Excel Workbook From a OneDrive
Скачать
8-1: Save an Excel Workbook to a OneDrive
Скачать
6-8: Excel Find and Replace - Expert Guide Covering All Features
Скачать
6-7: Select Multiple Worksheets to Create Excel 3-D Worksheet Groups
Скачать
6-6: How To Create Formulas That Reference Other Excel Worksheets
Скачать
6-5: Hide and Unhide Excel Worksheets
Скачать
6-4: Move and Copy Worksheets Between Workbooks (Merge and Combine)
Скачать
6-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets
Скачать
6-2: View Two Excel Workbooks Side By Side With Synchronous Scrolling
Скачать
6-1: View the Same Excel Workbook in Two Side-by-Side Windows
Скачать
7-9: Different Excel Headers and Footers for First, Odd and Even Pages
Скачать
7-8: Add Custom Headers and Footers to a Printed Excel Worksheet
Скачать
7-6: Insert, Move & Remove Excel Page Breaks Using Page Break Preview
Скачать
7-5: Insert and Delete Page Breaks without using Page Break Preview
Скачать
7-4: Fit All Excel Columns on One Printed Page with Excel Scale To Fit
Скачать
7-3: Perfectly Center an Excel Printout and Set Custom Margins
Скачать
Excel Essential Skills - Session 8: Cloud Computing - Introduction
Скачать
Excel Essential Skills Course - Session 7: Printing Your Work - Introduction
Скачать
Essential Skills - Session 6: Working With Multiple Worksheets and Workbooks
Скачать
7-1: Excel Paper Orientation (Portrait or Landscape) and Print Preview
Скачать
Excel Essential Skills - Session 5: Charts and Graphics
Скачать
5-27: Create an Excel Chart Template
Скачать
5-26: Add a Gradient Fill to an Excel Chart Area Background
Скачать
5-23: Add A Second Vertical (Y) Axis to an Excel Chart (Combo Chart)
Скачать
5-22: Excel Pie Chart Features - Rotate, Perspective, Pull Out Slice
Скачать
5-21: Change Excel Chart Scale - Vertical (Y) Axis Start & End Values
Скачать
5-20: Add an Excel Text Box and Arrow Shape to an Excel Chart
Скачать
5-19: Add Data Labels to an Excel Chart From a Cell Range
Скачать
5-18: Add and Format Data Labels and add a Data Table an Excel Chart
Скачать
5-17: Connect Empty Data Points or Show as a Gap in Excel Charts.
Скачать
5-16: Use Numbers on the X Axis of an Excel Chart
Скачать
5-15 Chart Non-Adjacent (Non Contiguous) Data by Hiding Columns & Rows
Скачать
5-14 Change Excel Chart Source Data using the Select Data Source dialog
Скачать
5-13: Understand Excel Chart Data Series and Excel Chart Categories
Скачать
5-12: Assign Data From Multiple Ranges (Non-Contiguous) to a Chart
Скачать
5-11: Change an Excel Chart Source Data (Select Data Source Dialog)
Скачать
5-10: Apply an Excel Chart Filter
Скачать
5-9: Move, Re-Size, Add, Position and Delete Excel Chart Elements
Скачать
5-8: Format Excel 3-D Elements and Add Drop Shadows
Скачать
5-7: Manually format an Excel chart element
Скачать
5-6: Use the Chart Styles Gallery to Apply a Chart Style and Color Set
Скачать
5-5: Add and Remove Chart Elements using Quick Layout
Скачать
5-4: Create an Excel chart using Recommended Charts & Quick Analysis
Скачать
5-3: Change Chart Style and Move, Re-Size, Copy & Name an Excel Chart
Скачать
5-2: Create an Excel Chart with Two Clicks
Скачать
5-1: Understand Excel Chart Types, Chart Layouts and Chart Styles
Скачать
4 -23: How To Rotate Text in Excel (Vertical, Horizontal and Angled)
Скачать
4-22: Two Ways to Use the Format Painter (Sticky and One-Time)
Скачать
4-21: Apply a Date Axis Type to an Excel Sparkline group
Скачать
4-19: Insert Excel Sparklines - Line Type, Column Type and Win/Loss
Скачать
4-18: Conditional Formatting with Formulas - Defining Custom Rules
Скачать
4-17: Insert Data Bars, Color Scales and Icon Sets into Excel cells.
Скачать
4-16: Advanced Conditional Formatting Using the Rules Manager
Скачать
4-14: Use an Excel Master Style Book to Merge Custom Styles
Скачать
4-13: Create Excel Custom Cell Styles
Скачать
4-12: Create Your Own Excel Custom Theme
Скачать
4-11: Apply or Draw Borders around Excel cells
Скачать
4-10: How To Add a Gradient Effect (Gradient Fill) to Excel Cells
Скачать
4-9: How To Use Excel Cell Styles to Create Beautiful Worksheets
Скачать
4-7: Vertical Alignment of Excel Cells. Top, Bottom, Middle, Justify
Скачать
4-6: Join Two Cells into One With Excel Merge & Center (inc Wrap Text)
Скачать
4-5: Excel Horizontal Alignment - Left, Right, Center, Justify, Fill
Скачать
4-4: Use Excel Custom Number Formats to apply ANY number format.
Скачать
4-3: Solve Excel Rounding Errors with the ROUND function.
Скачать
4-20: Apply a Common Vertical Axis and Formatting to a Sparkline Group
Скачать
Excel Essential Skills Course - Session 2: Doing Useful Work with Excel
Скачать
3-20: Check spelling in an Excel workbook
Скачать
3-19: Split the Excel window into multiple panes
Скачать
3-18: Freeze columns and rows (Freeze Panes)
Скачать
3-17: Add an Add-In (App) to an Excel workbook
Скачать
3-16: Use an Excel template
Скачать
3-14: Understand Templates and Set a Custom Template Folder Location.
Скачать
3-13: Understand mixed cell references (A&1, $A1).
Скачать
3-3: Cut, copy and paste includes Keyboard Shortcut Keys
Скачать
3-11: Print Excel Cell Comments at the End of, or Within a Worksheet
Скачать
3-10: Show and Hide Excel Comments (Create Sticky Comments)
Скачать
3-9: Insert cell comments
Скачать
3-8: Use Undo and Redo (includes shortcut keys)
Скачать
3-7: Use the Multiple Item Office Clipboard and Clipboard Task Pane
Скачать
3-6: Transpose a range
Скачать
3 5: Use Paste Values and increase/decrease decimal places displayed
Скачать
3-2: Use AutoComplete, Pick from Drop Down List and Fill Down features
Скачать
3-1: Insert and delete Excel rows and columns (inc shortcut keys)
Скачать
3 4: Cut, copy and paste using drag and drop (mouse & Ctrl key method)
Скачать
Excel Essential Skills - Session 3: Taking Your Skills to the Next Level
Скачать
Excel Essential Skills Course - Session 1: Basic Skills
Скачать
09-10: Record Your First Excel Macro (Short, Comprehensive Tutorial)
Скачать
Excel Expert Lesson 5-8: Filter a pivot table visually using slicers
Скачать
Excel Expert Lesson 6-9: Understand many-to-many relationships
Скачать
Excel Expert Lesson 6-1: Understand primary and foreign keys
Скачать
Excel Expert Lesson 8-10: Understand the three different ways to share a workbook
Скачать
09-02: Add a Combo Box (Drop-Down List) form control without VBA
Скачать
Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence.
Скачать
8-4: Microsoft Office Online (the FREE Office Version) 3 Minute Guide
Скачать
8-7: Edit a Workbook Simultaneously With Others Using Excel Online
Скачать
7-7: Insert an Excel Header and Footer With Page Numbers on Every Page
Скачать
4-2: Understand Date Serial Numbers and Date Arithmetic
Скачать
5-24: Create an Excel Custom Combo Chart Using Different Chart Types
Скачать
7-2: Use Page Layout view to adjust margins
Скачать
3-15: Create an Excel template
Скачать
5-25: Add a Trend Line and Moving Average to an Excel Chart
Скачать
4-15: Use Excel Conditional Formatting based on Dates, Values and Text
Скачать
3-12: Understand Excel absolute ($A$1)and relative (A1) cell references
Скачать
4-8: Excel Themes Tutorial (Font Set, Color Set and Effects Set)
Скачать
2-18: Use Excel Flash Fill to split Delimited Text
Скачать
2-16: Use Excel AutoFill Date options - Days, Weekdays, Months & Years
Скачать
2-23: Printing in Excel (ALL Backstage Print Options inc. Scaling)
Скачать
2-17: Create Custom AutoFill Lists (series) & other Autofill Pro Tips
Скачать
2-20: Use Flash Fill Artificial Intelligence (Expert Tutorial)
Скачать
2-21: Use Excel Flash Fill to Solve Real-World Business Problems
Скачать
2-15: How AutoFill Adjusts Cell References in Excel Formulas
Скачать
2-19: Use Flash Fill to Reformat A Phone Number (Expert Tutorial)
Скачать
2-22: Zoom In and Zoom Out of an Excel worksheet
Скачать
2-7: Select Non-Contiguous (Non-Adjacent) Cell Ranges
Скачать
1-11: How to recover an earlier version of an Excel workbook
Скачать
2-4: Select a range of cells and understand Smart Tags
Скачать
2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.
Скачать
1-12: Show/Hide the Excel Ribbon and use Tabs, Groups and Commands.
Скачать
1-2: Check that your Excel version is up to date
Скачать
2-12: Create Excel formulas the correct, professional way
Скачать
1-17: Use Full Screen Views by Hiding the Formula Bar and Ribbon
Скачать
1-10: How to Recover a Deleted, Unsaved or Lost Excel file
Скачать
2-14: Use AutoFill Excel Series (Months, Days, Dates, Numbers & Text)
Скачать
1-3: How To Change the Office Theme
Скачать
2-2: Open and view two Excel workbooks at the same time
Скачать
2-3: Use AutoSum to quickly calculate totals
Скачать
1-15: Use Keyboard Shortcuts for absolutely ANY Excel command.
Скачать
2-6: How To Select Multiple Excel Rows and Columns
Скачать
2-1: Enter and Edit Text and Numbers in an Excel Worksheet
Скачать
1-13: Understand Ribbon components
Скачать
1-6: How to save an Excel workbook to a local file
Скачать
2-10: Use AutoSum to sum a non-contiguous (non adjacent) range
Скачать
1-1: Open an Excel Workbook
Скачать
1-18: Use the help system * Now Deprecated *
Скачать
1-16: Excel Views - Normal, Page Break Preview and Page Layout
Скачать
2-5: Speed Data Entry: Enter, Tab, Shift+Tab, Shift+Enter & Ctrl+Enter
Скачать
1-4: Maximize, minimize, re-size, move and close the Excel window
Скачать
1-5: Navigate Large Excel Worksheets with Scroll Bars & Shortcut Keys
Скачать
1-8: Pin an Excel Workbook & Organize Files (File & Folder Management)
Скачать
2-13: Create Any Excel Function Faster and Easier using AutoComplete
Скачать
2-8: Keyboard Shortcuts to Select an Range Of Cells within a Block.
Скачать
1-7: Understand Common Excel file formats (XLSX, XLSM, XLSB, XLS, PDF)
Скачать
1-14: Customize the Quick Access Toolbar
Скачать
1-9: Excel Worksheet tabs - Everything There Is To Know
Скачать
2-9: Automatically Re-size Multiple Excel Rows and Columns
Скачать
Excel 2007 Course: Lesson 2-3 Use AutoSum to quickly calculate totals
Скачать