Udemy

Platform

English

Language

Other

Category

Excel Spreadsheets tips and best practice

Tips and spreadsheet best practice guidelines that can help you and your company avoid embarrassing and costly mistakes

4.86 (7 reviews)

Students

1.5 hours

Content

Jul 2021

Last Update
Regular Price

Topics


What you will learn

Excel best practice tips and guidelines for personal and professional use


Description

Excel is one of the most user-friendly software applications in the world, with billions of users.  But the qualities which make it so appealing - its easy of use, versatility and flexibility - also lead to Excel spreadsheets posing major risks to individuals and companies.

Spreadsheet errors, caused by carelessness or a lack of control around spreadsheets, cost individuals and companies billions of dollars every year.  Yet by implementing several intuitive and easy tips and best practice guidelines, many of these unintentional errors could be avoided.  This issue is becoming so prominent that many regulators around the world are implementing laws around End-User Computing (EUC), which encompasses Excel and other End-User Applications.

This course is the road safety guide to using Excel - just as we aren't allowed to drive without knowing some basic road safety rules, so too should no-one, from beginner to advanced users, be using Excel without some basic best practice training.

The lessons cover controls (versioning, change management, backup, input control, access control, documentation and checks) as well as general tips and best practice guidelines, which are easy to implement and solidify into good habits.  An example spreadsheet is included in the course materials and provides a template for anyone wishing to implement these controls in their own life and work.


Screenshots

Excel Spreadsheets tips and best practice
Excel Spreadsheets tips and best practice
Excel Spreadsheets tips and best practice
Excel Spreadsheets tips and best practice

Content

Introduction

Introduction: Best Practice for Excel Spreadsheets

Version Control, Change Control and Backup

Lesson 1: Version Control, Change Control and Backup

Input Control and Access Control

Lesson 2: Input control and access control

Documentation

Lesson 3: Documentation

Checks

Lesson 4: Checks

Structure, formatting and formulae

Lesson 5: Structure and format

Course Materials

Lesson 6: Course Materials


Reviews

B
Baveshan20 August 2021

Well structured, easy to follow course that helps to improve your spreadsheet management. Would highly recommend!

G
Gaby2 August 2021

I am a excel novice and I found this course informative and valuable. It was also easy to understand and follow along even as excel beginner.

R
Ryan25 July 2021

Very practical and interesting course. The lectures are easy to follow and well presented. A lot of useful tips and advice that I can use in all my spreadsheets.


4189886

Udemy ID

7/17/2021

Course created date

7/25/2021

Course Indexed date
Angelcrc Seven
Course Submitted by