Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel how to Design Presentation - Coggle Diagram
Excel how to Design Presentation
9 meo tang tinh Presentaion va Design cho Excel
Conditional Formating
Data bars
Data scales
Data sets
Hide and show column
Hide
Shift + Space chon row -> Ctrl + Shift + down -> chon tat ca row ben duoi -> hide
Ctrl + Space, chon column -> Ctrl + Shift + > de chon tat ca cac colum ben phai -> hide
Unhide
chon column cuoi cung -> unhide
chon row cuoi cung -> unhide
Hide Gridlines
Menu View -> uncheck Gridlines
Color Consistenly
with table -> Table Style -> chon mau cho table
Set mau cho Sheet Tab
vi du phan loai Summary 1, Summary 2, Analysis 1, Analysis 2, Data 1, Data 2... set 3 mau khac nhau cho 3 loai Sheet nay
Create Header
use 2 row ben tren lam Header
CellColor mau vang
Hang tren Heading, lam Title
Hang duoi giai thich tieu de
Vi du
Monthly cost overview
Fixed and variable cost by month
luu y, khong nen Merge Tilte, vi se gay ra cac van de ve sau
Use Section Dividers
Rename Sheet them vao >> de phan biet sheet type
Vi du Summary 1 >> , Summary 2 , Analysis 1 >> Analysis 2, Data 1 >> , Data 2
Cover Page
tao Cover Sheet
co cac thong tin nhu logo, project name, owner name, data of creation
tao Intro Sheet
Project name, logo, Objectives, Contacts, Legend, Contant and Links, change log...
Leave Space
Hay chua column A de canh le, khong su dung de show data -> presentation dep mat hon
Du lieu khong lien quan nen dua vao Sheet khac
Be consistent - tinh nhat quan
Vi du co 1 table, thay vi fix column bang cach chon tat ca column va double click len ben canh cot.
Table se consistent hon neu chon column lon nhat va keo rong ra cho tat ca cac column co dong rong nhu nhau va bang cot rong nhat
https://www.youtube.com/watch?v=QpAwkZZNzGg