Wahlberg - Excel 2022: From Basic to Advanced. The Most Exhaustive Guide to Become a Pro in Less Than 7 Days and Master All the Functions & Formulas. Includes Practical Examples and Step-by-Step Instructions

Mrft Excel

Microsoft Excel n ltrn spreadsheet. The wrkht, also knwn a rdht, can be ud to tr dt. Wh n u it t divide your dt into rw and columns? Wh can l u it t rfrm mathematical lultn quickly? It n hw data n th form f line grh, histograms, charts, and a mnml thr-dmnnl grhl dl.

Benefits f Exl

• The most fftv method f storing data.
• You n do calculations.
• All of the dt nl tools.
• Chrt mk it ml t vulz dt.
• Rrt are ml t print.
• Thr r mn free templates to h from.
• You n utmt b coding.
• Dt trnfrmtn and lnng

Context & Altn

• Entrng nd trng dt Exl is an xllnt tool for dt ntr and storage t its mt b lvl.
• Exl an xllnt tl fr dt entry and trg t t most basic lvl.
• Clltn and Vrftn f Bun Dt
• Administrative and mngrl dut
• Accounting and budgtng
• Dt Analysis
• Rrtng + Vulztn
• Frtng.

1. File

Whn you n a nw fl n Excel, the frt tab u wll File. Lk rfull - you m m t because t a different lur thn th other tb (depending on what lur hm your dkt is t n). Th Fl tab has jut wht u would thnk: tn related t th entire Fl, uh v, print, hr, and n.

2. Hm

The Hm tab has th mt mmnl ud ftur, ll rltd to mdfng text. In th Home tb, u can lt ur fnt, z, lur, attributes (bld, tl, undrln), nd lgnmnt (lft, ntr, right). Yu n l select a tl, a rdtrmnd text made t fit rtn document parts, uh as hdng, ubttl, nd text.

3. Insert

Under th Inrt tb, thr r vrl choices. There r mn t f vul d and hghlght you n dd t a fl t hl summarize nd present nfrmtn n an Excel dumnt. In the Inrt rbbn tb, u n find tn fr grh, charts, hyperlinks, g brk, hdr, footers, text bx, and rfrn nfrmtn, such date nd tm, comments, page numbr, nd bkmrk.

5. Pg Lut

The Pg Lut rbbn a vital tb to determine hw your dumnt lk. Th tb h th options t mdf mrgn, g rnttn, r z, lumn, ndnt, spacing, page brk, and the rrngng of n rt f the document, uh txt and grh r tbl.

8. Review

Here, you can find the track hng options, mmntng tools, language nd trnltn tl, and wht u mght xt t n a rvw tn: spell hk, thuru, wrd unt, etc.

9. Formulas

Th Frmul mnu whr you fnd all th number-crunching options. Exl comes wth mn frmul, including financial, lgl, text, dt & tm, lku & reference, and math & trigonometry.

10. Dt

The Dt mnu l ntn many ntl functions n Exl, including mrt and connections with dtb. On the Dt mnu, u also the sort, fltr, rmv dult, data vldtn, nldtn, gru, ungru, and subtotal functions.

11. Review

Erlr n th book, w mentioned Exl' ability to collaborate on rdht. The Review menu whr mn of th tasks take l. You n mk mmnt in cells for ur colleagues, check to spell, track changes, and rtrt rmn using tm in th Rvw menu.

12. Vw

On the Vw mnu, u utmz the way spreadsheets r on ur rn. Options nlud dlng grdln between ll, tgglng th formula br nd hdng, nd mr. Th mnu also gives you tn to vw nd record mr; mr lt u register mmn t you rfrm so you don't have t rt th same things rtdl!

13. Quk Access Toolbar

Th where wh can place ll th essential tl. Whn u start Exl fr th frt tm, it has nl three n (Sv, Und, Redo). But u can dd n ftur of Excel to Quk A Tlbr to easily it frm anywhere (hn th nm).

14. Rbbn

Rbbn is lk n expanded mnu. It dt ll th ftur of Excel n t understand frm. Sn Exl has 1000s of rt, they r grud into several rbbn. Th most critical rbbn are Hm, Inrt, Frmul, Pg Lut & Data.

15. Frmul Br

This is whr n lultn r frmul u write will r. Yu wll undrtnd the relevance f t once you trt buldng rdur.

16. Srdht Grd

Th where ll ur numbr, dt, charts & drawings wll go. Eh Exl fl n contain several ht. But the rdht grd hw a fw rows & lumn f th tv spreadsheet. Yu n u th scroll bars to th lft r t the bottom t more rw r lumn. If you wnt t access thr ht, lk n th sheet nm (r use th shortcut CTRL+Page U or CTRL+Page Dwn).

17. Sttu Br

This tells u wht gng n wth Exl t n tm. Yu can tll f Exl is bu lultng a frmul, rtng a vt rrt or rrdng a mr by jut looking t th ttu bar. Th status br l hw uk ummr f ltd cells (unt, um, average, minimum or maximum vlu). You n change th b right-clicking n it nd choosing which recaps t show.

18. A Worksheet r Sheet

I a ngl g n a fl created wth n ltrn rdht program such Microsoft Excel or Ggl Sht.

19. A Workbook

I the name given t n Exl file nd ntn n or mr wrkht. When you open an electronic spreadsheet program, it ld n empty wrkbk fl ntng of one r mr blank wrkht fr you t u.

20. Srdht

A spreadsheet a computer program tht can tur, dl nd manipulate dt rrngd in rows and lumn. Srdht are n f the mt ulr tl available with rnl computers.

21. Sorting

Srtng lists a tl spreadsheet task tht llw u to reorder ur dt ukl. The mt common t of rtng is alphabetical rdrng, which you n do n ndng r dndng rdr.

22. Grung

Grung is a uful Exl ftur tht ntrl how th nfrmtn is dld. It wuld help if you rtd bfr u n gru.

23. Frmul Audtng

Frmul udtng n Exl allows you to dl the rltnh btwn formulas nd ll. Th xml blw hl u mtr Frmul Audtng ukl nd l.

24. Fnd nd Rl n Exl

If w want t rh nthng n our wrkbk lk a specific number r txt trng, w n u th Fnd and Rl ftur n Excel. W have the tn of ltng th rh item fr rfrn r rlng t wth nthng else. We can nlud various wildcards in ur rh trm, uh trk, tides, utn marks, and numbr. W n rh b rw nd lumn, rh within vlu r comments, nd rh with a worksheet r ntr workbooks.

If w wrk with a lrg amount of data n Exl, fndng f nfrmtn n b challenging nd tm-numng. W m use th Find ftur t search ur wrkbk ukl, nd w n l u th Rl tn t hng the txt.

Whn working with lrg Exl rdht, it's critical to locate th information w nd t n gvn time ukl. Scanning hundrd f rw nd columns nt th best w t proceed, let's take a deeper look at wht Exl' Fnd nd Rl ftur ffr.

25. Frmul Br

Frmul Bar in Exl a section whr we can see vlu nd frmul trd. Th Frmul gnrll lrd n blw the mnu br. But if it nt thr, we can activate th from the Vw mnu tn under the Shw tn. Who can l trt it from the Excel Otn' Advnd tab? Apart frm showing th vlu nd Formula f n ll, Frmul Br also tll whh cell w have kt th cursor nd th Inrt Funtn option denoted by fx.

Th ntnt f th current ll r where the ltn ntd will b vbl n th frmul br. Vblt nlud:

• Current cell selection.
• Th Formula applied in the tv ll.
• Th rng f ll ltd n th xl.

26. Password Protection: Surt vs. Protection

Bfr dung Excel's wrd-rttn ftur, lt' lrf wht we mn by security. Althugh the trm security nd protection r bantered but interchangeably, feature-wise n Exl, th aren't th m thing. Surt lets you h wh gt n nd, undrdng , wh dn't; rttn lmt ur wh r already n. Surt but ; protection but maintaining integrity.

Enrt n Exl fl wth a password so tht t requires a wrd t n t. T wrd rtt an Excel file, xut th fllwng t.

• On n Excel fl.
• On th Fl tb, lk Sv A.
• Clk Brw.
• Click on th Tl buttn nd lk Gnrl Otn.
• In th Pwrd to open box, ntr a wrd nd lk OK.
• Reenter the password nd lk OK.
• Note: Th ftur l nrt your Excel fl. If you lose or frgt the wrd, t nnt be rvrd.
• Entr a file nm nd lk Sv.
• Clk Sv

27. How To Inrt Hdr nd Ftr In Mrft Exl

Yu can dd additional information t your Excel wrkht tht t ntnt thrughut th wrkbk wth hdr nd footers. It can b a g numbr, n image, or utm text u wnt to appear n ll pages.

Hw T Add Headers And Ftr n Mrft Exl

Fllw the blw t t add hdr nd ftr n Mrft Excel: