What you’ll learn

Workbooks & Cells Entry

• Row / column adjustments, text inputs, and automatic cell data handling.

Editing Techniques & Data Cleansing

• Paste special options, clearing contents, cell editing shortcuts
• Fixing broken formatting from text/number system exports

Formulas & Engine Notation

• Mathematical arithmetic operators (+, -, *, /, ^), and .
• Universal operations (SUM, AVERAGE, MAX, MIN, COUNT, IF)
• Relative/absolute cell addressing notation ($A$1)

File Exchange Management

• Importing data feeds, file type conversions, and layout formatting.

Standard Charting & C-Suite Layout Distribution (Integrated)

• Building column, bar, and line charts, axis parameter adjustment, and data series updates.
• Professional Page Setup properties
• Configuring print titles (repeating row/column headers),
• Using Scale-to-Fit setting, setting custom page breaks, defining specific print areas
• Setting custom page breaks, defining specific print areas
• Exporting to clean business PDFs

Formatting Techniques & Page Layouts

• Number formatting, currency styles, thousand separators, percentages
• Border lines, text alignments, and grid patterns

Database Management

• Sorting records by criteria (Multi-level, Color sets, Icon arrangements)
• Auto-fill automation, dragging techniques, and deploying data filters