Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel 2016: Customize Excel - Save Time & Be More Productive

Name: Excel 2016: Customize Excel - Save Time & Be More Productive
Rating: 4.7 (816 reviews)

Quickly learn how to customize Excel 2016 so that you don't have to waste time when creating new workbooks!

Created byBruce Myron

Last updated 3/2017

English

What you'll learn

Understand how to customize many Excel settings to save time.

Course content

10 sections • 26 lectures • 2h 13m total length

Introduction3:32

Introduction to THEMES4:34
Introduction to SHAPES4:30
Sizing Shapes and Adding Text5:22
Learn to size shapes and add text in Excel 2016 arrows, format typography, align text, and link text to cells, with rotation considerations and future word art options.
Using WORDART with Shapes4:32
Grouping Shapes and Custom Themes7:30
Group shapes and text to move, size, and rotate them together, then create a custom theme by adjusting colors, fonts, and effects, and save it for future use.
Add Website Images and Colors6:17
THEMES and SHAPES Quiz

How Cell Styles Can Save Time5:33
Learn how cell styles standardize titles, headings, and currency formatting across multiple sheets, saving time by creating and applying custom styles like my currency with two decimal points.
Introduction to Cell Styles5:36
Creating Custom Cell Styles7:42
Learn three methods to create custom cell styles in Excel 2016, including new cell style from the styles list, duplicating, and basing on current formats, with theme implications.
Merging Cell Styles Into Templates7:04
Merge custom cell styles from a workbook into the default template and other templates, with same-named styles overwriting, and save via custom office templates and sheet templates using prefixes.
CELL STYLES Quiz

Requirements

Students just need to have a general knowledge of working with Windows and have Microsoft Office 2010 or later installed.

Description

How much time do you waste setting up new files the same way over and over in Excel? Isn't it about time you learned how to customize Excel so you can make it work the way you want from the start?

This course could save you MANY HOURS of time every month!

If you are willing to take the time to go through this course and do the exercises, you could easily be much more productive with Excel in just a few hours!

This course is "hands on" and has exercise files for almost every section. This is not a course you just watch - you learn new techniques by watching each lecture step, then doing them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to use Excel. This is your opportunity to break away from the pack of people who struggle to get their work done using Excel. Stop being like everyone else and and learn how to use Excel MUCH more effectively than just about anyone else!

__________________________________________________________________________

If you have the right mindset and start getting rid of old inefficient habits by applying what you learn in this course, you will instantly be more productive than the vast majority of users of Microsoft Excel 2016

In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do myr best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It! AND it will be well worth it!

________________________________________________________________________

This course will not remain this price forever! It's time to take action!

Click the "take this course" button at the top right now!

...every hour you delay is costing you money...

See you in the course!

Sincerely,

Bruce Myron

Who this course is for:

This course is for anyone wanting to learn how to use Excel effectively.

Excel 2016: Customize Excel - Save Time & Be More Productive

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Make Your Own Default Book and Sheet Templates4 lectures • 16min

Customizing THEMES and SHAPES6 lectures • 33min

Customizing CELL STYLES4 lectures • 26min

Saving Custom Table Styles to Your Templates1 lecture • 5min

Customizing Filter Views2 lectures • 8min

Customize the Quick Access Toolbar2 lectures • 11min

Customize the Ribbon2 lectures • 10min

Creating and Using Simple Macros3 lectures • 19min

Conclusion1 lecture • 2min

Requirements

Description

Who this course is for: