Microsoft Excel 365 Formulas, Formatting and Printing
Description:... This Workbook is a valuable resource for beginners understanding of core concepts as well as advanced comprehension of the "in's and out's" of Excel. In short, everyone who uses this Workbook will learn a new variety of shortcuts and time-saving tricks to enhance spreadsheet use. And, 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. See sample clips at 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, Absolute Reference, 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 on 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 them 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, and Fill Cell Features.
- 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 Clip explaining how the courseware has been designed and how to use it most effectively.
www.elearnlogic.com/media/coursewareexplanation.mp4
Show description