7 подписчиков
145 видео
ON DEMAND SOFTWARE TRAINING VIDEOS
CERTIFIED ONSITE COMPUTER SOFTWARE TRAINING
EX-02-06 – Split Screen in Excel: View & Compare Data with Horizontal and Vertical Panes
EX-08-15 — Using Running Totals in Pivot Tables for Cumulative Analysis
EX-07-32 – Patterned Color Banding with Conditional Formatting Formulas
EX-07-53 — Moving Averages with AVERAGE Function in Excel
EX-10-17 — How to Create Excel Macros with ChatGPT: Multi-Action Text Tool
EX-08-29 — Manual Grouping of Field Items in Pivot Tables
EX-07-17 – Importing External Data from ASCII & Delimited Files into Excel
WD-01-27 — Mastering Tables: Templates, Conversions, and Advanced Table Design
EX-02-15 – Format Cells Dialog: Unlock Excel’s Full Visual Power in 6 Tabs
PR-01-11 — Advanced Task Management: Add, Move, and Inactivate Tasks in Microsoft Project
EX-02-10 – Clear Formatting, Contents & Comments in Excel: Reset Cells Without Breaking Layout
EX-01-05 – Test Score Spreadsheet in Excel: Build, Format & Calculate Averages
EX-07-50 — Frequency Distribution Using the FREQUENCY Function
EX-08-17 — Custom Grouping of Pivot Items Without Source Field Values
EX-07-31 – Excel Database Functions: Dynamic Filtering with Calculated Results
EX-10-15 — How to Create Excel Macros to Highlight Cells with Comments
EX-07-12 – Using the TEXT Function to Extract & Format Dates for Analysis
EX-07-24 – Sorting, Filtering & Visual Criteria: Data Control Through Color & Icons
EX-07-03 – Using TRANSPOSE to Reorient & Normalize Excel Data
EX-08-27 — Pivot Table Running Totals in Excel
EX-05-27 — IF Logic for Threshold Alerts & Return Controls
EX-02-03 – Custom Format Excel Cells: Dates, Numbers & Text Display Control
EX-07-20 – Exporting Excel Data to External File Formats
ON-01-01 — Create Your First Notebook in Microsoft OneNote with OneDrive Integration
