222 тысяч подписчиков
168 видео
Excel Essential Skills Course - Session 2: Doing Useful Work with Excel
2-1: Enter and Edit Text and Numbers in an Excel Worksheet
2-2: Open and view two Excel workbooks at the same time
2-3: Use AutoSum to quickly calculate totals
2-4: Select a range of cells and understand Smart Tags
2-5: Speed Data Entry: Enter, Tab, Shift+Tab, Shift+Enter & Ctrl+Enter
2-6: How To Select Multiple Excel Rows and Columns
2-7: Select Non-Contiguous (Non-Adjacent) Cell Ranges
2-8: Keyboard Shortcuts to Select an Range Of Cells within a Block.
2-9: Automatically Re-size Multiple Excel Rows and Columns
2-10: Use AutoSum to sum a non-contiguous (non adjacent) range
2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.
1-10: How to Recover a Deleted, Unsaved or Lost Excel file
7-6: Insert, Move & Remove Excel Page Breaks Using Page Break Preview
4-11: Apply or Draw Borders around Excel cells
03-07 Excel Date and Time - Everything you need to know.
09-06 Use Excel CheckBox values in formulas without VBA
6-2: View Two Excel Workbooks Side By Side With Synchronous Scrolling
7-9: Different Excel Headers and Footers for First, Odd and Even Pages
4 -23: How To Rotate Text in Excel (Vertical, Horizontal and Angled)
4-4: Use Excel Custom Number Formats to apply ANY number format.
3-11: Print Excel Cell Comments at the End of, or Within a Worksheet
4-6: Join Two Cells into One With Excel Merge & Center (inc Wrap Text)
1-12: Show/Hide the Excel Ribbon and use Tabs, Groups and Commands.
7-4: Fit All Excel Columns on One Printed Page with Excel Scale To Fit
4-10: How To Add a Gradient Effect (Gradient Fill) to Excel Cells
Excel Expert Lesson 5-8: Filter a pivot table visually using slicers
4-1: Change Date Format in Excel (Apr-10-21, 04/10/21, 10/4/21 etc)
3-3: Cut, copy and paste includes Keyboard Shortcut Keys
7-10: Print Selected Cells from an Excel Worksheet (Set Print Area)
6-3: Split a Large Excel Worksheet Into Multiple (Separate) Worksheets
Excel 2007 Course: Lesson 2-3 Use AutoSum to quickly calculate totals
2-13: Create Any Excel Function Faster and Easier using AutoComplete
3-14: Understand Templates and Set a Custom Template Folder Location.
1-7: Understand Common Excel file formats (XLSX, XLSM, XLSB, XLS, PDF)
09-05 Add an Excel check box form control to a worksheet without VBA
5-16: Use Numbers on the X Axis of an Excel Chart
3-12: Understand Excel absolute ($A$1)and relative (A1) cell references
6-5: Hide and Unhide Excel Worksheets
5-14 Change Excel Chart Source Data using the Select Data Source dialog
5-21: Change Excel Chart Scale - Vertical (Y) Axis Start & End Values
7-8: Add Custom Headers and Footers to a Printed Excel Worksheet
7-11: Print Row and Column Titles on Every Page and Print Gridlines
1-17: Use Full Screen Views by Hiding the Formula Bar and Ribbon
4-16: Advanced Conditional Formatting Using the Rules Manager
7-7: Insert an Excel Header and Footer With Page Numbers on Every Page
3-19: Split the Excel window into multiple panes
4-18: Conditional Formatting with Formulas - Defining Custom Rules
4-15: Use Excel Conditional Formatting based on Dates, Values and Text
3-8: Use Undo and Redo (includes shortcut keys)
7-3: Perfectly Center an Excel Printout and Set Custom Margins
7-5: Insert and Delete Page Breaks without using Page Break Preview
3-2: Use AutoComplete, Pick from Drop Down List and Fill Down features
09-01 Add Group Box and Option Button form controls without VBA
09-12 Understand Macro Security, Trusted Folders and Trusted Documents
4-19: Insert Excel Sparklines - Line Type, Column Type and Win/Loss
