- technology article
- software article
- Articles about Microsoft products
- excel article
Book:excel workbook for dummies
excel workbook for dummies
discover bookbuy on amazon
Execute Excel File Menu Commands with Useful Shortcut Keys
Excel shortcut keys are activated by pressing the Alt key before typing the various mnemonic sequences. The mnemonic letter for all Excel File menu commands in Backstage view is F (for File). So, in the table below, you only need to focus on the second letter in the File menu shortcut key sequence.
Unfortunately, not all of these second letters are as easy to combine and remember as Alt+F. For example, notice the account option shortcut key sequence - Alt+FD - where the second mnemonic (D) is nowhere in the option name!
|Hotkeys||Excel ribbon command||Function|
|Alt+FH||Fechai→Startseite||Shows the launcher where you can choose a template or open a recent or pinned workbook|
|Alt+UNO||Fechai→Neu||Displays the Available Templates panel in the Backstage View panel, where you can open a blank workbook or one from a template|
|Alt+FO||Fechai→Öffnen||Displays the Open dialog box in normal sheet view, where you can select a new Excel workbook to open for editing or printing.|
|Alt+FI||Fechai→Info||Shows the information panel in Backstage view, where you can view the current worksheet along with statistics about the workbook and protect the workbook, check the file for compatibility issues, and manage different versions created by the AutoRecover feature|
|Alt+FS||Datei→Speichern||Save changes to a workbook. When you first choose this command for a new workbook, Excel displays the Save As dialog box|
|Alt+FA||File→Save As||Displays the Save As dialog box in normal spreadsheet view, where you can change the file name, file location, and the format in which the file is saved.|
|Alt+FA||Archive→View a copy||For a OneDrive file, displays the Save a Copy screen in Backstage view, where you select the OneDrive folder to save a copy of the file, the file name, and the format in which to save the file|
|Alt+FP||Fechai→Drucken||Displays the Print pane in Backstage view, where you can change print settings before sending the current worksheet, workbook, or cell selection to the printer.|
|Alt+FH||File → Share||Displays the Share window in Backstage view, allowing you to send the current workbook as an email attachment or Internet fax, attach it to an email as a PDF file, save it a in a new file format or save it online on your company's SharePoint site or your own Windows Live SkyDrive|
|Alt+FE||Datei→Exportadores||Displays the Export screen in Backstage view, where you can change the workbook's file type or convert it to an Adobe PDF or Microsoft XPS document|
|Alt+FU||Datei→Veröffentlichen||Allows you to load all or part of your workbook into Microsoft Power BI (Business Intelligence), a standalone program that allows you to create advanced visual reports and dashboards on your Excel data|
|Alt+FC||Fechai→Schließen||Close the current workbook without exiting Excel|
|Alt+FD||Fechai→Konto||Displays the Accounts screen in Backstage view, where you can change your user information, choose a new wallpaper and theme for all Office programs, add connected storage services, and get your product ID and other version information from Office|
|Alt+FK||Datei→Comentários||Displays the Feedback screen in Backstage view, where you can send feedback to Microsoft about Excel features you like and dislike, suggest new features, and make other improvements.|
|Alt+FI||Data→Opções||Displays the Excel Options dialog box in normal sheet view, where you can change the default program settings, change the Quick Access Toolbar buttons, and customize the Excel ribbon.|
|Alt+FX||Arquivo→Excel Excel||Exits the Excel program and closes all open workbooks after prompting you to save|
Common Excel shortcut keys for executing formula commands
All shortcuts for selecting the most common formula-related commands in Excel start with the sequence Alt+M, as M was the only mnemonic left in forMulas (F was already assigned to the File menu commands).
|Hotkeys||Excel ribbon command||Function|
|Alt+MF||Formulas→Insert function||Opens the Insert Function dialog (equivalent to clicking the Insert Function button in the formula bar)|
|Alt+MOUSE||Formeln→AutoSumme→Summe||Select the occupied area over the cell cursor and enter the SUM formula to total the area|
|Alt+BUY||Formeln→AutoSumme→Durchschnitt||Select the occupied range over the cell cursor and enter the AVERAGE formula to average the total in the range|
|Alt+MUC||Formulas→Autosume→Count numbers||Select the occupied area over the cell cursor and enter the COUNT formula to count the number of values in the area|
|Alt+MI||Formeln→Finanzen||Opens a drop-down list listing all financial functions - click on the name to insert the function into the current cell|
|Alt+I||Formulas→Date and time||Opens a drop-down list listing all date and time functions - click on the name to insert the function into the current cell|
|Alt+MN||Formeln→Namensverwaltung||Opens the Name Manager dialog with all range names in the workbook, where you can add, edit, and delete names|
|Alt+MMD||Formulas→Define Name||Opens the New Name dialog where you can name the cell selection or define a new constant|
|Alt+MS||Formulas→Use in Formula||Shows a drop-down list of range names in the workbook that you can click to insert into the current formula|
|Alt+MC||Formulas→Create from selection||Opens the Create Names From Selection dialog box, where you specify which rows and columns to use for naming the selection of cells.|
|Alt+MH||Formulas→Show Formulas||Show and hide all formulas in worksheet cells|
|Alt+MXA||Formeln→Optionen→Automatisch||Reactivate automatic recalculation|
|Alt+MXE||Formulas→Options→Auto except data tables||Turns automatic recalculation back on for all parts of the worksheet except areas containing data tables|
|Alt+MXM||Forme→Opções→Handbuch||Enable manual recalculation|
|Alt+MB||Formulas→Calculate Now||Recalculates formulas in the entire workbook when manual recalculation is enabled|
|Alt+MJ||Formulas→Calculate Arguments||Recalculates formulas in the current worksheet when manual recalculation is enabled|
Excel display commands via shortcut keys
The mnemonic letter for all display-related commands in Excel is W (the last letter you see in Vista).
|Hotkeys||Excel ribbon command||Function|
|Alt+WL||Ansicht→Normal||Returns the worksheet to normal page layout view or page break view|
|Alt+WP||View → Page Layout||Places the worksheet in page layout view and displays the page|
Pauses, margins and rules
|Alt+WI||Ansicht→Seitenumbruchvorschau||Places the worksheet in page break view and shows page breaks that you can customize|
|Alt+WO||Ansicht→Vollbild||Puts the worksheet in full screen mode, which hides the file menu, quick access toolbar, and ribbon; press Esc to restore the previous view|
|Alt+WVG||View → Gridlines||Hide and show the row and column grids that make up the cells in the worksheet area|
|Alt+GT||View→Zoom to selection||Enlarges or reduces the worksheet area for magnification|
Percentage needed to show cell selection only
|Alt+WJ||Anzeigen→100%||Resets the worksheet area to the default magnification percentage of 100%.|
|Alt+WN||Ver→Nova ventana||Insert a new window into the current workbook|
|Alt+WA||View→Organize all||Opens the Arrange dialog where you can choose how the workbook windows are displayed on the screen|
|Alt+WF||Ver→Congelar ventana||Opens the Freeze Window drop-down menu, which lets you choose how rows and columns are frozen in the worksheet area: Freeze Window (to freeze all rows and columns to the left of the cell cursor); Freeze the top row; or freeze the first column|
|Alt+WS||View → Share||Divide the worksheet into four areas on the top and left|
Cell cursor border as vertical and horizontal division
Lines - press hotkeys again to remove all windows
|Alt+WH||Anzeigen→Ausblenden||Hide the current worksheet or workbook window|
|Alt+WU||Ansicht→Einblenden||Opens the Show dialog where you can select the window or workbook to redisplay|
|Alt+WB||Exhibit→Display side by side||Place two open windows or workbooks side by side for comparison - press the hotkey again to restore the original full windows|
|Alt+WW||View → Change Window||Opens the Switch window drop-down menu, where you can select the open window or workbook to be activated.|
Excel shortcut keys for editing commands
The mnemonic for all editing commands is H (for Home) because all these commands are conveniently located on the Home tab of the ribbon.
But even if you remember to associate editing with the Home tab, and remember that Alt+H is always the starting point, you're still not free because the remaining letters on the shortcut keys aren't as easy to remember as you might think. . . as.
Fortunately, the most common editing commands (cut, copy and paste) still respond to the old Ctrl+ keyboard shortcuts (Ctrl+X, Ctrl+C and Ctrl+V, respectively), which are much faster than the Ctrl+ equivalents. +H if you are already familiar with them and use them regularly.
|Hotkeys||Excel ribbon command||Function|
|All+PVC||Início→Einfügen→Einfügen||Pastes the currently copied or cut cell selection or graphic object onto the worksheet|
|Alt+HX||Home → Schnitt||Cuts the selection of cells or selected graphic objects from the workbook and places them on the Windows clipboard|
|Alt+HC||Inicial→Kopieren||Copy selection of selected cells or graphic objects to the Windows clipboard|
|Alt+HFP||Startseite→Copy format||Turn on the Format Painter|
|Alt+HFO||Home→Clipboard Dialog Launcher||Show and hide the clipboard task pane|
|Alt+HII||Home→Insert→Insert Cells||Opens the Insert dialog box so you can specify the direction to move existing cells to make room for those to be inserted.|
|All+HERE||Home→Insert→Insert worksheet rows||Insert blank rows equal to the number of rows in the cell selection|
|Alt+HERE||Home→Insert→Insert worksheet columns||Insert empty columns equal to the number of columns in the cell selection|
|Alt+BE||Home→Insert→Insert worksheet||Insert a new worksheet into the workbook|
|alt+disk||Home→Delete→Delete cells||Opens the Delete dialog box so you can specify the direction to move existing cells to replace the ones being deleted.|
|Alt+HDR||Inicial→Löschen→Blattzeilen||Remove rows equal to the number of rows in cell selection|
|Alt+HDC||Início→Löschen→Blattspalten||Remove columns equal to the number of columns in cell selection|
|Alt+HDS||Inicial→Löschen→Blatt||Clears the current worksheet after warning you about data loss if the worksheet contains cell entries|
|Alt+OK||Home→Delete→Delete All||Clears cell selection content, formatting, and comments|
|Alt+HEF||Home→Delete→Delete formats||Clears cell selection formatting without removing content and comments|
|Alt+HEC||Home→Delete→Delete Content||Clears cell selection content without removing formatting and comments|
|Alt+BOM||Home→Delete→Delete comments||Clears all comments in cell selection without removing formatting and content|
About this article
This article is from the book:
- excel book for laymen,
About the authors of the book:
Pablo McFedriesis a technical writer who has been writing computer books since 1991 and has over 100 books under his belt. These books includeAlexa for Dummies, Amazon Fire TV for Dummies, Yline cutting for mannequins. You can visit Paul on the web at www.mcfedries.com.
His love of teaching translated into an equal love of writing.paramaniacsBooks are obviously her favorite writers because they allow her to write for her favorite audience, the beginner. They also allow you to use humor (a key element to success in the classroom) and, best of all, offer an opinion or two on the subject.
Pablo McFedriesis a technical writer who has been writing computer books since 1991 and has over 100 books under his belt. These books includeAlexa for Dummies, Amazon Fire TV for Dummies, Yline cutting for mannequins. You can visit Paul on the web at www.mcfedries.com.Greg Harveyhas written tons of computer science books, the most recent beingExcel 2007 for Beginners, Windows Vista Quick Start Guide for Beginners,YExcel Book for Dummies.He began training corporate users to use IBM personal computers and associated computer software in the dark days of DOS, WordStar and Lotus 1-2-3 in the mid-1980s. With independent training, he taught courses in bank management software and spreadsheets at Golden Gate University in San Francisco for one semester.
You can find this article in the category:
- standing out,
- Excel keyboard shortcuts for data entry
- Excel 2003 program window
- Excel 2003 Formatting Toolbar
- Excel 2003-Standardsymbolleiste
- Excel editing keyboard shortcuts
- Show all articles in the book
You can brush up on your Excel knowledge through an online course or boot camp that teaches both fundamental and advanced skills. For someone new to Excel, a boot camp offers learners a flexible educational experience to learn Excel as part of their coursework in as short as a few months.Is there a cheat sheet for Excel? ›
Have the basics of formulas, operators, math functions and more at your fingertips. Welcome to our Excel Basics Cheatsheet! Whether you're new to the program or just need a quick refresher, this guide will help you master the essential skills needed to navigate and utilize the powerful features of Excel efficiently.How to use Excel step by step? ›
- Click an empty cell. For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.
- Type text or a number in the cell.
- Press Enter or Tab to move to the next cell.
The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.How can I learn Excel fast for free? ›
- Useful Excel for Beginners [Udemy] ...
- Everyday Excel, Part 1 [Free Coursera Course] ...
- Microsoft Excel — Improve your skills quickly [Udemy] ...
- Easy Excel Basics for Beginners — Get Started with Excel [Udemy]
Although it's possible to gain a basic understanding of Excel's interface and core functions in just a few hours, it can require additional time and study to master its more complex capabilities. It takes most Excel users approximately 18-20 hours to fully learn this spreadsheet application.How difficult is Microsoft Excel? ›
Excel can be a challenging tool to master if you're a beginner and have no experience in data or spreadsheets. However, learning the basics is a straightforward process that only takes a short amount of time, especially if you get some help from online courses.What are the 5 functions in Excel? ›
- IF function;
- LOOKUP function;
- VLOOKUP function;
- HLOOKUP function;
- MATCH function;
- CHOOSE function;
- DATE function;
- Worksheet - rectangular grid of rows (numbers) and columns (letters)
- Cell - intersection of row and column.
- Cell reference - unique address, coordinates of the intersection of a column and row (B7)
- Gridlines - horizontal and vertical lines.
A workbook is a spreadsheet program file that you create in Excel. A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows.
- Post Balances in Trial Balance Columns. ...
- Post Adjusting Entries in Adjustment Columns. ...
- Complete Income Statement Columns. ...
- Determine Net Loss or Net Income. ...
- Complete Balance Sheet Columns.
These topics are pretty time consuming but easy to learn. So, it all depends on you. If you practice every day and dedicate around 2-3 hours every day to learn the concepts, then you can learn it within four weeks. But, to master the concepts in Excel, you need to use the tricks and formulas on a daily basis.Can I learn Excel in an hour? ›
Within 1 hour, you can use Excel the way a working professional would use. 1. Excel is powerful. Microsoft tries to make Excel as relevant to anyone as possible.Is there free Excel training online? ›
Frequently Asked Questions About Online Excel Courses. Alison offers free online Excel courses on its platform. There is a wide range of courses for everyone - from beginners or intermediate users, core Excel skills for accounts, or most useful formulas to master the tool.What are the hardest things to learn in Excel? ›
- VBA, Macros & Automation. VBA is the most struggling area of Excel. ...
- Writing Formulas. Excel has hundreds of functions. ...
- Making Charts. ...
- Pivot Tables. ...
- Conditional formatting. ...
- Array Formulas. ...
- Dashboards. ...
- Working with data.
Learn how to use all 300+ Excel formulas and functions including worksheet functions entered in the formula bar and VBA functions used in Macros.What does Ctrl F means in Excel? ›
Notes: To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words. If an action that you use often does not have a shortcut key, you can record a macro to create one.What does Ctrl D do in Excel? ›
Excel – Use CTRL-D to duplicate the data from the cell above you have selected. You can highlight multiple cells to fill them all too!What does Ctrl R do in Excel? ›
Ctrl + R: Fills the selected cells with the contents of the cell to the left. 14. Ctrl + S: Saves the active workbook.What is the hardest thing to do in Excel? ›
What is the hardest thing to learn in Excel? VBA is Excel's most difficult area. Most people indicate they have difficulty writing macros, automating parts of their work, comprehending VBA, and designing Excel apps.
The difference between hidden and very hidden sheets in an Excel workbook is the ability to find and unhide them. Very hidden sheets are not exposed when you select Unhide. You do not even have the option from the tab to make a sheet very hidden in the first place.What is Microsoft Excel for dummies? ›
Excel for Dummies is your Excel bible for learning basic Excel skills. Sometimes Excel books expect you to already know things about Excel, which make them hard to follow. However, this free Excel training article will start with the basics to help you get up and running.Can I master Excel in a day? ›
It's impossible to learn Excel in a day or a week, but if you set your mind to understanding individual processes one by one, you'll soon find that you have a working knowledge of the software. Make your way through these techniques, and it won't be long before you're comfortable with the fundamentals of Excel.How many days will it take to learn Excel? ›
You will require a minimum of 20 – 24 hours to learn the basics. 30-45 days to learn intermediate-level Excel. Around 3 months of dedication are required to advance your skills in Excel Software.What are the 4 reasons people should learn Excel? ›
- Creating budgets.
- Organizing revenue statements.
- Tabulating profit and loss details.
- Monitoring supplies and inventory.
- Helping others to understand data with visualizations such as charts and graphs.
SUM functions. Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers—but it doesn't just sum. It also subtracts, multiplies, divides, and uses any of the comparison operators to return a result of 1 (true) or 0 (false).What are the 7 common uses for Excel? ›
- Data Entry and Storage. At its most basic level, Excel is an excellent tool for both data entry and storage. ...
- Collection and Verification of Business Data. ...
- Administrative and Managerial Duties. ...
- Accounting and Budgeting. ...
- Data Analysis. ...
- Reporting + Visualizations. ...
Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division. In addition to these, you can find out averages and calculate percentages in excel for a range of cells, manipulate date and time values, and do a lot more.What are the two most commonly used functions in Excel? ›
- SUM: This is probably Excel's most basic and commonly used formula. ...
- AVERAGE: As the name suggests, this formula returns the average of a range of cells. ...
- COUNT: This formula counts the number of cells in a range that contains numbers.
- Principle 1: Be client ready. ...
- Principle 2: Begin with the end in mind. ...
- Principle 4: Separate the data. ...
- Principle 5: Highlight and limit and hard coding. ...
- Principle 6: Break down large complex formulas. ...
- Principle 8: Ask for help or look online. ...
- Principle 9: Use Keyboard Shortcuts.
A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.What are five 5 types of data that can be stored in an Excel cell? ›
In a Data Model, each column has an associated data type that specifies the type of data the column can hold: whole numbers, decimal numbers, text, monetary data, dates and times, and so on.What is the bar at the top of Excel called? ›
The Excel Workbook Window. Menu Bar. The Menu Bar at the top of the screen gives you access to different commands that are used for such tasks as opening and closing files, printing documents, formatting data, and other operations.What are the 6 Excel functions? ›
- Text / string functions.
- Logical functions.
- Math functions.
- Statistical functions.
- Lookup and reference functions.
- Financial functions.
- Date functions.
- Time functions.
By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. For more information, see Change the number of worksheets in a new workbook. You can also add and remove worksheets as needed.What is an example of a workbook and worksheet? ›
In Microsoft Excel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called "Sheet1" in an Excel workbook file called "Book1." Our example also has the "Sheet2" and "Sheet3" sheet tabs, which are also part of the same workbook.What is a workbook used for? ›
Meaning of workbook in English. a book used in school containing text and questions and sometimes having spaces for a student to write answers in: There's a workbook to accompany the textbook.What is written on the three line heading on a work sheet? ›
*The heading consists of 3 lines and contains the name of the business, the name of the report, and the date of the report.What are the three components of a worksheet? ›
- Cells. Cells are the individual blocks created by the intersection of the horizontal and vertical lines on worksheets. ...
- Rows and columns. Rows are the horizontal lines of cells on worksheets. ...
- Names (named ranges). Rows and columns have names. ...
- Usedcellrange and getusedcellrange.
- Write your company's name. ...
- Create column titles. ...
- Place the unadjusted trial balance. ...
- Enter your adjustments. ...
- Identify your adjusted trial balance. ...
- Record the income statement. ...
- Complete the balance sheet. ...
- Write your closing entries.
- Master the Shortcuts.
- Import Data from a Website.
- Filter Your Results.
- Calculate the Sum.
- AutoCorrect and AutoFill.
- Display Formulas.
- Manage Page Layout.
- Excel Keyboard Shortcuts Every Analyst Must Know.
- VLOOKUP Function and Its Uses.
- HLOOKUP Function and Its Uses.
- MID Function and Its Uses.
- OFFSET Function with Examples.
- CHOOSE Function and Its Uses.
- Handle Wrapped Text in Excel.
- Hide zeros in range in Excel.
Even tech-savvy professionals can find Excel difficult because it has its own programming language, Visual Basic for Applications (VBA), which is used to create macros, or pre-saved automations that run an action or a set of actions.What is the fastest way to improve Excel skills? ›
- Master keyboard shortcuts. Excel comes with a slew of keyboard shortcuts to help you work faster and more productively. ...
- Conditional formatting. ...
- Macros. ...
- PivotTables. ...
- Charts. ...
- Filters/ AutoFilter. ...
- COUNTIF. ...
- Flash Fill.
The #### error is one of the most common errors when using Excel, and it's easy to fix. Excel prints this error message when the width of a column is not wide enough to display all the characters within that cell. This error can also occur when Excel displays a negative time and date.What are the 5 powerful Excel functions that make work easier? ›
- VLookup Formula.
- Concatenate Formula.
- Text to Columns.
- Remove Duplicates.
- Pivot Tables.
Common Excel Confusion – Numbers appear when certain letters are pressed. This can be one of the most frustrating of the common Excel confusions. If numbers appear when the letters J, K, L, U, I, O or M are being pressed, the user may have inadvertently activated NumLock.What are the levels of Excel skills? ›
There are three levels of Excel skills – basic, intermediate and advanced. The basic Excel skills include cell references, styles, showing formulas, keyboard shortcuts, basic spreadsheet formatting and data ranges.