Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Excel Trining
1
Excel Course
Some useful options
Definitions:
Macros
A macro is a series of commands used to automate a repeated task and can be run when you have to perform the task.
Make a document trusted to enable macros
-Enable or desable macro in Microsoft files
If you see a security warning when you open a document or try to run a macro, you can choose to make it a trusted document and enable macros. This example is on an Excel workbook.
1. Select Enable Content.
2. In the Security Warning dialog, select Yes to make the document trusted.
Macros are now enabled on this document. To revoke a trusted document, you need to clear all trusted
documents. For more info, see Trusted documents.
Change macro
security settings
You can change macro security settings in the Trust Center, unless a system administrator in your organization has changed the default settings to prevent you from changing the settings.
1. On the Developer tab, in the Code group, click Macro Security. To enable the Developer tab, see Show the Developer tab.
2. In the Macro Settings category, under Macro Settings, click the option that you want.
- Change macro security settings in Excel
- Create and save all yout Macros in a Single Workbook
When you first create a macro in a workbook, it works only in that workbook.
But what if you want to use the macro in other workbooks? To make your macros available every time you open Excel, you can create them in a workbook called Personal.xlsb. That’s a hidden workbook stored on your computer, which opens in the background every time you open Excel.
Create a macro. We’ll record a macro that does nothing, but will create the Personal Macro workbook.
You can learn more about creating macros in Quick start: Create a macro.
Run a Macro
- Run a Macro
Before you start working on macros you should enable the Developer tab.
- For Windows, go to File > Options > Customize Ribbon.
- Then, in the Customize the Ribbon section, under Main Tabs, check the Developer check box, and press OK.
Picture 1
Picture 2
Record a macro
- Create a macro
1. In the Code group on the Developer tab, click Record Macro.
2. Optionally, enter a name for the macro in the Macro name box, enter a shortcut key in the Shortcut key box, and a description in the Description box, and then click OK to start recording.
3. Perform the actions you want to automate, such as entering boilerplate text or filling down a column of data.
4. On the Developer tab, click Stop Recording.
Photos
Shortcuts & Tips
Many users find that using an external keyboard with keyboard shortcuts for Excel helps them work more efficiently
Shortcuts
& Tips
Text
Customize the Quick Access
ToolBar
Top 10
Ctrl+W Close a Spreadsheet
Ctrl+O Open a Spredsheet
Ctrl+S
Keyboard shortcuts for the File menu
-Press "alt"-
Pictures
Topic 3
Functions
Chart
Chart
Timeline
Timeline
YEAR
Topic 4
Formulas
Types of
column charts
Graphs
- Column chart
- Pie and doughnut charts
- Bar chart
- Area chart
- etc.