-
Excel Tutorial
- Excel HOME
- Excel Introduction
- Excel Get Started
- Excel Overview
- Excel Syntax
- Excel Ranges
- Excel Fill
- Excel Move Cells
- Excel Add Cells
- Excel Delete Cells
- Excel Undo Redo
- Excel Formulas
- Excel Relative Reference
- Excel Absolute Reference
- Excel Arithmetic Operators
- Excel Parentheses
- Excel Functions
Excel Formatting
- Excel Formatting
- Excel Format Painter
- Excel Format Colors
- Excel Format Fonts
- Excel Format Borders
- Excel Format Numbers
- Excel Format Grids
- Excel Format Settings
Excel Data Analysis
- Excel Sort
- Excel Filter
- Excel Tables
- Excel Conditional Format
- Excel Highlight Cell Rules
- Excel Top Bottom Rules
- Excel Data Bars
- Excel Color Scales
- Excel Icon Sets
- Excel Manage Rules (CF)
- Excel Charts
Table Pivot
Excel Case
Excel Functions
- AND
- AVERAGE
- AVERAGEIF
- AVERAGEIFS
- CONCAT
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- IF
- IFS
- LEFT
- LOWER
- MAX
- MEDIAN
- MIN
- MODE
- NPV
- OR
- RAND
- RIGHT
- STDEV.P
- STDEV.S
- SUM
- SUMIF
- SUMIFS
- TRIM
- VLOOKUP
- XOR
Excel How To
Guided Projects
- Introduction to Excel
- Learn Data Calculations
- Learn Data Visualization
- Learn to Create a Budget
- Learn to Create a Timeline
- Learn to Style in Excel
Excel Examples
Excel References
Excel Case: Poke Mart Shop Cart, Styling
This case is about helping the Poke Mart merchant to style the shop cart overview. You will practice the skills that you have learned in the chapters about formatting and styling
Case: Poke Mart, Styling
This case is about helping the Poke Mart merchant to style the shop cart overview. You will practice the skills that you have learned in the chapters about formatting and styling.
Did you solve the first case about the Shop Cart? We will reuse that data. Check it out here.
You do not need the calculations to complete the case. Type the following data:
Merchant: Oh boy! I am glad that you are here to help. This colorless Shop Cart has been declining our sales. Let's give it a lift!
To complete this case you need to:
Start by removing the grids
Like this:
Make space for the heading by creating a new row 1.
1
1.
Make space for the header, increase the row height to 40 pixels.
Note: You will see the border size box which indicates the pixels when you start to drag the border.
Merge A1:D1 to create one big cell for the header.
A1:D1
Type Poke Mart in the merged range A1:D1
A1:D1(click the merged range)
The header font is a bit small, huh?
Change the header font to size 20 and make it Bold
A1:D1 (the merged range)20
That's the way! The header looks better now.
For all cells, change the font to Arial and align text for A2:F14 to Center.
A2:F14
A2:F14 to the Center.
It's time to get some colors in there.
A2:D4 (the merged cells)D2:D42a75bbD3:D9255 203 5ffcb05
The two last colors used are the same. Same color, HEX and RGB are different.
Note: Coloring the input fields can be helpful for those who will use the spreadsheet. In this case we marked the input fields with the yellow color: ffcb05.
Next, change text colors
A1:D4A2:A4
Change the Number formats for the prices to Currency and remove the decimals.
B3:C14
Add borders to make the numbers more readable.
B11: UnderlineB14: Double bottom borderE12:F12: Thick outside bordersB11B14E12:F12
Do the final calculation for total and add the final Bold fonts.
B14=B11-B12A14:B14A2:D2
Add test values:
D3(5)D4(2)D6(5)D9(10)
Before and After
Before styling:
After styling:
function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Excel spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }