Please enable JavaScript.
Coggle requires JavaScript to display documents.
MS Excel (Advanced Formatting Techniques (13-Essential numeric formatting…
MS Excel
Advanced Formatting Techniques
03-Adjusting fonts, font sizes, and font colors
04-Applying underline, strikethrough, subscript, and superscript formatting
02-Using the exercise files
05-Applying border styles and adjusting gridlines
01-Welcome
06-Using fill color and patterns for cell backgrounds
07-Adjusting horizontal and vertical cell alignment
08-Creating angled text variations for greater variety and readability
09-Indenting data and dollar signs
10-Simplifying title adjustments with the Merge & Center button
11-Controlling titles and headings with the Wrap Text and Shrink to Fit options
12-Working with numeric formatting options
13-Essential numeric formatting keystroke shortcuts
see once again
14-Setting special formats for dates, times, phone numbers, ZIP codes, etc.
again
15-Building custom numeric formats
16-Building custom date formats
17-Creating value-based formatting using logical operators
18-Creating value-based formatting using data bars, color scales, and icons
19-Creating formats based on formulas
20-Conditional formatting in PivotTables
21-Working with tables
22-Using styles and themes for consistent formatting
23-Adjusting single and multiple row heights and column widths without commands
24-Working with rows, columns, and sheets
25-Working with the Hide and Unhide options
26-Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar
27-Applying different formatting styles within the same cell
28-Copying formats quickly with dragging techniques and the Format Painter
29-Formatting text from Word or the web with the Justify feature
30-Setting up data for outlining
31-Using outlining symbols and levels
32-Formatting picture styles
33-Adding borders and effects to pictures
34-Formatting sparklines for optimum impact
35-Using WordArt for formatted titles and headings
36-Hiding repeating titles in a column to clarify printed output
37-Restoring missing title data in a column
38-Displaying large values without using formulas
39-Creating linked worksheet images
40-Formatting column and row titles
41-Formatting a list for double-spaced printing