Instructor for this course
more
Enrolled:
501
Duration: 1 Hour
Level: Foundational
Access This Course: Instant Access to Course Library

Excel Efficiency: Intro to Macros Part 1

Continuing Education Credits
Click or touch a Credit for more information

Certified Public Accountant

Continuing Education Credit:
1 CPE Credits
Field of Study:
Accounting
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
cpe/qas logo
Illumeo is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State Boards of Accountancy have the final authority on the acceptance of individual course for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890

Continuing Professional Development

Continuing Education Credit:
1 Hours
Field of Study:
Accounting
CPE Delivery Method:
Self-Study
Program Location:
Online
Your specific provider of Continuing Professional Development accreditation has final authority on the acceptance of individual courses for CPD credit.

Certified Management Accountant

Continuing Education Credit:
1 CPE Credits
Field of Study:
Accounting
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Fraud Examiner

Continuing Education Credit:
1 CPE Credits
Field of Study:
Specialized Knowledge
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Government Financial Manager

Continuing Education Credit:
1 CPE Credits
Field of Study:
Computer Science
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Internal Auditor

Continuing Education Credit:
1 CPE Credits
Field of Study:
Computer science
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal


Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.

Certification in Risk Management Assurance

Continuing Education Credit:
1 CPE Credits
Field of Study:
Computer science
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal

Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Course Syllabus
INTRODUCTION AND OVERVIEW
Intro to Macros Part 1
  7:52Automating Center Across Selection
  11:31Running a Macro, Creating a Shortcut
  10:19Personal Macro Workbook; Deleting Macros
  8:06Macro Recorder Shortcut; Contact Info Macro
CONCLUSION
  4:45Relative References in Macros; Closing Comments
Continuous Play
  52:40Excel Efficiency : Intro to Macros Part 1
SUPPORTING MATERIALS
  PDFSlides: Intro to Macros Part 1
  PDFIntro to Macros Part 1 Glossary/Index
  XLSExcel Efficiency Intro to Macros Part 1-Excel 2003
  XLSXExcel Efficiency Intro to Macros Part 1-Excel 2007-2016
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM