Microsoft Excel 365 Formulas, Formatting and Printing

Excel is a very useful resource for creating budgets, listing information, or improving math accuracy. This material will cover the day-to-day operations of Excel . It will cover many Tips and Tricks to use Excel more efficiently. We will also discuss many Shortcut Keyboard commands to save time by reducing the number of clicks to execute a command. Understanding how to use Functions , manipulate Formulas , adjust Columns/Rows , create Worksheets , adjust the screen window with Large Worksheets , and Print without getting 20 blank pages will put you in the driver's seat to be more productive. After studying this group of chapters, students will experience a higher level of increased productivity and understanding of Excel .

Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. To see an example clip: www.elearnlogic.com

This Step-By-Step Workbook will cover three major Excel categories including Formulas , Formatting , and Printing. The following topics will be covered: Interface - This will provide an overview of the system, including cell manipulation, entering data into cells, Quick Access Toolbar , and Zooming capabilities. General Formulas - This will include Sum, Average , Minimum , Maximum , Count Functions , as well as other manually entered formulas. Also, it will cover formula manipulation techniques such as Fill Handle, Fill Down, Paste Special, and Copying a Formula. Row and Columns - This will include Insert , Delete , Hiding, and Auto-Adjust Columns/Rows . We will also cover ways to format and Auto-adjust multiple columns/rows at the same time. Worksheet Tabs - These are located at the bottom of the interface and will allow you to Insert , Delete , Rename , Move , Copy , and change the color of the Tabs . We will also cover how to manipulate information in cells and apply it to multiple sheets at the same time. Large Spreadsheet Management - This will cover View Workbooks Side-By-Side, Split , Freeze, Arrange All, and Arrange 2 Sheets Side-By-Side . Formatting - These chapters cover Font, Alignment, Number, Borders, Format Painter, Fill Cell Features, and Conditional Format. Printing - This chapter will cover Repeat Title, Print Area, and Print Selection as well as how to Scale a sheet to fit a typical-sized page. What’s in the Workbook? Click on the left side of the screen: Look Inside!
Enter one of the following keywords: Formulas, Formatting, Print, Worksheets, Zooming, Sum, Average, etc.

How the Workbook is Designed
This Workbook contains over 200+ step-by-step practice exercises to help you get up to speed quickly and understand each concept. The commands and features are very similar to previous versions of Excel and differences are documented where appropriate. The following link is a Video