Intro to Excel Macros Part 1 هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

In this course Excel expert David Ringstrom, CPA, helps you get started with Excel's Macro Recorder. Most users are unaware of the automation possibilities that macros present, and so this course is designed to show you how to automate simple repetitive tasks in your daily work. The course focuses on Excel's Macro Recorder and storing macros in the Personal Macro Workbook for future use. You'll also learn how to create a shortcut on Excel's Quick Access Toolbar for one click access to your most frequently used macros.

David teaches from Excel 2010 but provides handouts with numbered steps that are specific to Excel 2003, Excel 2007, Excel 2010, Excel 2013, and 2016.

Topics covered in this Excel macros for beginers course include:

• Learn what a macro is in Excel.
• Use Excel's Macro Recorder to create simple macros without any programming knowledge required.
• Determine when to use Relative References when using Excel's Macro recorder.
• Recover from making mistakes when recording macros.
• Understand the nuances of Excel's Personal Macro Workbook and why you may wish to use it.
• Create an icon on your Quick Access Toolbar so that you can launch frequently used macros with a mouse click or keyboard shortcut.

Although each course ay be taken individually, this is part 1 of 4.

1. Intro to Excel Macros Part 1

2. Intro to Excel Macros Part 2

3. Intro to Excel Macros Part 3

4. Intro to Excel Macros Part 4