Scribd
Upload
21 views1 page

Excel 62

The document is an index listing various topics related to software functionalities, including macros, KPIs, charting, and data management. It provides page references for specific features such as undoing actions, linking data, and using Visual Basic Editor. Additionally, it covers keyboard shortcuts and dialog interactions within the software.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views1 page

Excel 62

The document is an index listing various topics related to software functionalities, including macros, KPIs, charting, and data management. It provides page references for specific features such as undoing actions, linking data, and using Visual Basic Editor. Additionally, it covers keyboard shortcuts and dialog interactions within the software.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Index

Print, 294 M
Redo, 426
Replace, 56 Macro dialog, 313, 433
restoring actions, 59 macros
ribbon, 427 accessing through buttons, 328
Save, 363, 426 assigning, 325
Save As dialog, 7 assigning to icons, 320–321
spelling checker, 59–60 assigning to Quick Access Toolbar buttons,
tables with default formatting, 65 318–319
Undo, 426 assigning to shapes, 320–321
undoing actions, 59 creating and modifying, 315–317, 333
Visual Basic Editor, 313–314 deleting, 317
Zoom in and out, 426 editing, 317
KPIs (key performance indicators) enabling and examining, 333
defining and displaying, 412–415, 423–424 examining, 312–315
explained, 443 explained, 444
using, 403 recording, 315
running, 317–322, 333–334
security levels, 309–312
L security settings, 311
stepping through, 313–314
Label form control, 323
using, 308–309
labels
magnification level, changing for worksheets,
setting apart, 104
35–36
using with worksheets, 21
mailto hyperlink, 444
landscape mode, 443
map charts, 222–226
languages, translating words in, 58–59, 61
mathematical equations, inserting, 248
LARGE operation, 146–147
mathematical operations, 76–78
line charts, 218–219, 233
Matrix SmartArt graphics, 239
linear forecasting, 404, 407
MAX function, 78, 146
linking
maximizing windows, 433
to charts, 346–347, 350
measures, defining and managing, 410–412, 423, 444
to data, 185–188, 191
MEDIAN function, 146
to documents or presentations, 336–338
menus, opening, 427
to files, 337–338
Merge and Center, 444
links, explained, 443
merging and unmerging cells, 20–22, 40, 112
list box, explained, 443
Microsoft 365 app keyboard shortcuts. See also
List Box form control, 323, 326–327
keyboard shortcuts
list rows, selecting randomly, 149. See also custom
actions, 439
lists
Backstage view, 436
List SmartArt graphics, 239
dialogs, 435–436
Live Preview feature, 49, 443
edit boxes within dialogs, 435–436
location data, tagging entries as, 224–225
finding and replacing, 439
location statistics, adding, 225–226
help, 440
locked cell, explained, 444
keyboard focus, 437–438
locking and unlocking cells, 358, 360
Open and Save As dialogs, 436
looking up data, 176–184, 191
panes and galleries, 438–439
ribbon, 437
tables, 438
windows, 434

453

You might also like