30 Minutes (MS Office)
Excel in 30 Minutes: Getting Started
- Navigating the interface and moving around using the keyboard and mouse
- Accessing commands to perform common tasks
- Using Excel Help Online to answer your Excel questions
27m
0
0
Excel in 30 Minutes: Customizing Options
- Modifying options in the Backstage View
- Changing default and save preferences
- Editing new workbook settings
18m
0
0
Excel in 30 Minutes: Entering Data (Basics 2 of 10)
- Creating a new workbook
- Saving workbooks and exporting them as other file types
- Entering data into your spreadsheet and using copy, paste, undo, redo, and clear
26m
0
0
Excel in 30 Minutes: Calculations
- Creating basic formulas
- Inserting functions
- Using AutoSum and AutoFill
33m
0
0
Excel in 30 Minutes: Modifying Worksheets
- Adding and deleting rows and columns, and adjusting column width and row height
- Using the Hide & Unhide feature
- Finding, selecting, and replacing data
24m
0
0
Excel in 30 Minutes: Text and Number Formats
- Changing the color, style, and size of text
- Adding borders to cells
- Applying number formatting including dates, currency, and percentages
24m
0
0
Excel in 30 Minutes: Formatting Cell Contents
- Changing the alignment of text in a cell
- Rotating text diagonally and vertically
- Wrapping text onto multiple lines
23m
0
0
Excel in 30 Minutes: Conditional Formatting
- Using Conditional Formatting to analyze data and identify patterns and trends
- Applying Conditional Formatting to text, numbers, and dates to easily identify certain values or duplicates
- Applying Comparative Analysis Formatting to add Data Bars, Color Scales, and Icon Sets to your worksheets
28m
0
0
Excel in 30 Minutes: Printing and Page Layout (Basics 8 of 10)
- Accessing Print Options and Print Preview from Backstage View
- Modifying basic print settings
- Choosing rows and columns to repeat on printed pages
29m
0
0
Excel in 30 Minutes: Worksheets and Workbooks
- Managing your worksheets by learning to add, remove, rename, reorder, copy, and color-code them
- Hiding and unhiding sheets
- Creating Custom Views to save display and print settings and easily switch between them
33m
0
0
Microsoft Teams in 30 Minutes (2021)
- Creating a Team or a Channel
- Using the Chat function for private and group conversations
- Create online meetings or call and meet on the fly (with recording)
34m
0
0
Excel in 30 Minutes: Advanced Charting, Trendlines, and Graphics (Intermediate 9 of 11)
- Creating Dual-Axis and Combo charts
- Applying and modifying Trendlines on a chart
- Creating and applying Chart Templates
33m
0
0