Unlocking MS Excel - Bridging Basics to Intermediate

Continuing Education Credits
Click or touch a Credit for more information
CPA
5.0 CPE
CPD-IES8
5.0 Hours
CMA
5.0 CPE
CFE
5.0 CPE
CIA
5.0 CPE
CRMA
5.0 CPE

Certified Public Accountant

Continuing Education Credit:
5.0 CPE Credit
Field of Study:
Computer Software & Applications
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
In accordance with the standards of the National Registry of CPE Sponsors, CPE credits have been granted based on a 50-minute hour.
More information about CPA CPE Credits
Back to Top

Chartered Accountant (IES8 CPD)

Continuing Education Credit:
5.0 Hour
Field of Study:
Computer Software & Applications
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-IES8 credit.
More information about CPD-IES8 Hours
Back to Top

Certified Management Accountant

Continuing Education Credit:
5.0 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
More information about CMA CPE Credits
Back to Top

Certified Fraud Examiner

Continuing Education Credit:
5.0 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
More information about CFE CPE Credits
Back to Top

Certified Internal Auditor

Continuing Education Credit:
5.0 CPE Credit
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.
More information about CIA CPE Credits
Back to Top

Certification in Risk Management Assurance

Continuing Education Credit:
5.0 CPE Credit
Field of Study:
Other activities contributing to professional competence
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.
More information about CRMA CPE Credits
Back to Top
Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  Basic Parts of Excel Window11:19
  How to Save0:36
  How to Page Setup & Print1:44
DATA ENTRY AND FORMATTING
  Items in Group Clipboard (Home Tab)10:21
  Items in Group Font (Home Tab)10:25
  Items in Group Alignment (Home Tab)5:48
  Items in Group Number (Home Tab)5:50
  Inserting Pictures, Shapes & Smart Art6:15
  Inserting Equation & Symbol2:25
  Insert a Dropdown List4:15
  Check Spelling0:51
  How to Hide Gridlines0:34
DATA MANIPULATION AND ANALYSIS
  Items in Group Editing (Home Tab)10:52
  Sum, Average, Rank, Max & Min13:26
  Count & Count A6:17
  Upper, Lower & First Letter Capital2:48
  Combine Word from Different Cells3:32
  Columns to Rows & Vice Versa3:07
  Group Ungroup Columns and Rows3:37
  Remove Duplicates4:00
  Splitting Data in a Cell2:11
  Converting Numbers into Words4:07
  Finding Number of Characters in a Cell0:41
  Using LEFT, RIGHT, and MID Functions3:18
  Removing Extra Spaces Inside a Cell0:49
DATA VISUALIZATION
  Working with Charts11:15
  Inserting Graphs Inside a Cell3:55
  Use of Slicer3:02
  Interactive Dashboard using Hyperlink12:28
  Pivot Tables22:05
DATA ORGANIZATION AND REFERENCE
  Items in Group Cells (Home Tab)9:39
  Items in Group Styles (Home Tab)10:44
  Freeze Rows & Columns4:56
  Relative, Absolute, and Mixed References8:43
  How to use VLOOKUP14:34
  How to use HLOOKUP6:05
  Using ISNA with VLOOKUP6:00
  Trace Precedents1:57
  Trace Dependents1:03
  Monitoring Cells with Watch Window2:04
ADVANCED EXCEL FUNCTION
  IF function3:04
  Eliminating Blank Rows7:50
  Adding Current Date and Time2:51
  Auto Time Using VBA2:24
  Locking Certain Cells in a Worksheet4:37
  Protecting a Workbook2:09
  Password Protect Excel File1:20
  Calculating Loan Installments3:13
  Using Scenario Manager for What-If Analysis3:34
  Implementing Goal Seek for Data Optimization2:34
  Using Match Formula2:10
  Basic Macro4:46
DATA INTEGRATION AND COLLABORATION
  Import Data Using Queries3:11
  How to use Smart Lookup0:52
  How to use Translate1:01
  How to use Comments0:43
  Finding Age1:18
  Finding Hours Worked1:42
  Workbook Statistics0:41
CONTINUOUS PLAY
  Unlocking MS Excel - Bridging Basics to Intermediate Part 12:52:06
  Unlocking MS Excel - Bridging Basics to Intermediate Part 22:05:22
SUPPORTING MATERIAL
  Slides: Unlocking MS Excel - Bridging Basics to IntermediatePDF
  Unlocking MS Excel - Bridging Basics to Intermediate Glossary/IndexPDF
  Activity Book: Unlocking MS Excel - Bridging Basics to IntermediateXLSX
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam