Excel: Cell Formatting and Worksheet Adjustments

Learning Objectives

• To describe how to move around in a spreadsheet
• To discuss how to select, cut, copy and paste data in seconds
• To describe how to add or delete rows and columns
• To describe how to adjust column width and row height
• To discuss how to hide or unhide rows and columns
• To describe how to move sheets across workbooks
• To describe how to move around in a spreadsheet
• To format texts and highlight them in order of relevance
• To make data attractive
• To print data 
• To format cells by conditions
• To align data in a worksheet

Course Description

There are many spreadsheet programs but from all of them, Excel is most widely used. 

People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.

It is a perfect tool for anyone working in the finance and accounting fields due to its versatility and specific financial applications. Mastery of Microsoft Excel is a must-have skill for accountants these days and a key to their professional growth. Whether you’re just starting or have been in the field for some time.

Join this excel CPE webinar to understand how to effectively adjust an excel worksheet by using keyboard shortcuts saving your time and effort.

But staring at Excel spreadsheets for hours on end can put a strain on accountants’ eyes. The good news is you don’t have to ramp up the font to a cartoonish size to get relief.

All the effort that you put into perfecting data would go in vain if the viewer finds it disinteresting and decide to stop halfway. An employer or client would prefer data that is well presented over data that lacks quality visualization.

How to make a visually pleasing worksheet?

• By formatting texts
• By creating attractive tables
• By aligning cells uniformly
• By highlighting important areas to grab the attention of the viewer.

This Excel CPE course also helps you to understand how to use functions in Excel that allow users to make the data much easier on the eyes.

You can learn different techniques and shortcuts to learn how to make an excel worksheet Visually Pleasing and:

• Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
• Work in Excel with ease by a much better presentation of data that in turn would impress your employer.
• Reduce the chances of client turnover by providing them with the most effective visually pleasing accurate data.

It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE webinar will work similarly in Excel for PC and Mac

Overview

• Moving the data in the Excel sheet

  2 mins
• How to delete columns and rows in the Excel sheet

  13 mins
• Hiding multiple rows and colums

  18 mins
• How to protect the structure of the workbook

  32 mins
• how to make formatting of the Excel sheet so that it looks pleasing to the eye

  41 mins
• How to apply format painter to the Excel Report

  51 mins
• Putting an outside border to the notes

  63 mins
• Applying custom conditions formatting to data set

  66 mins