Excel 365 Part 13 – Table and range names
In this video, we will cover the difference between a Range and a Table. A Table is a module that sits on top of Excel, similar to a chart, and has additional formatting capabilities. Tables can be used as input to a Chart or PivotTable. A Range uses the cells in an Excel sheet. Typing data in a Blank worksheet is an example of a normal range of cells.
Video Series Part 13 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch4.mp4
- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.
Courseware: Excel 365 - Formulas, Charts, And PivotTables
Courseware is available on Amazon at: https://www.amazon.com/dp/1660221943
Chapter 4 - Datasheets And Tables
In this chapter, the difference between a Range and a Table must be clearly understood. A Table is a module that sits on top of Excel, similar to a chart, and has additional formatting capabilities. Tables can be used as input to a Chart or Pivotable. A Range uses the cells in an Excel sheet. Typing data in a Blank worksheet is an example of a normal range of cells.
Chapter Contents:
Section 1: Excel Range Feature
This is a normal Excel Range containing numbers of letters in cells located on a worksheet. This is what we normally use to create data in a worksheet. The concepts that can be used in a range are Sort, Custom Sort, Filter, Advanced Filter (AND operation), Advanced Filter Criteria, Advanced Filter (OR operation), Clear, and Subtotals capabilities.
Section 2: Table Features
This is an object that sits on top of an Excel worksheet similar to a Chart. It is an object that contains additional functionality in a defined area. When used for a Chart or PivotTable, it will allow updates to occur if the data area changes. It will allow several ways to format the entire area quickly and seamlessly. One important feature is to create banded rows which will be reapplied if the data is sorted differently. The following features of a Table will be covered: Create A Table, Modify A Table, Table Style Options, Table Sorting, Text Filters, Table Styles, Insert Column, Delete Row, and Convert To Range
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
47
views
Excel 365 Part 12 – Lookup Functions
Lookup functions will lookup information from a database and return an answer from a different column in the database. They can be used to look up part numbers, Employee IDs, or any field that is unique in the database. If there are many duplicate Lookup Values, it will usually return the first value in the list. There is also a new function called XLookup that allows you to return the first or the last value found. Other Database functions covered that will look up and total information based on certain criteria. These Database functions work similar to the Countif, SumIF and Average If functions, but Database functions consider the entire database when it pulls information.
Video Series Part 12 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch3-sec2.mp4
- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.
Courseware: Excel 365 - Formulas, Charts, And PivotTables
The courseware is available on Amazon at: https://www.amazon.com/dp/1660221943
Section 2: Lookup Functions
The Lookup functions will lookup information from a database and return an answer from a different column. They can be used to look up part numbers, employee IDs, or any field that is unique in the database. If there are many duplicate lookup values, the Lookup Function total will usually return the first or last value. There are also new functions such as XLookup, that allows you to return the first or the last value. The following functions will be covered in the workbook: VLookup, HLookup, Lookup, Match, Index, MatchIndex, XLookup, and Offset functions.
Section 3: Database Functions
Database functions will look up and total information based on certain criteria, Database functions work similar to the CountIF, SumIF and AverageIF functions, but Database functions consider the entire database when it pulls information. The following Database functions will be covered in the workbook: DCount, DSum, DAverage, DGet, DMax, and DMin functions.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
71
views
Excel 365 Part 11 – Logical Functions
Logical Functions are very useful in identifying and providing multiple outcomes. They can evaluate data and determine several possible answers in making decisions. These decisions relieve you from making mistakes and will allow you to duplicate the formula to many rows. "If" conditions include operators such as Greater Than, Greater Than/Equal To, Less Than, Less Than/Equal To, Equal To, and Not Equal To. The results of these conditions are either true or false. Another set of Logical Functions that are covered will add up many fields based on input criteria such as CountIF, SumIF, and AverageIF functions.
Video Series Part 11 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch3-sec1.mp4
- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.
Courseware: Excel 365 - Formulas, Charts, And PivotTables
The courseware is available on Amazon at: https://www.amazon.com/dp/1660221943
Chapter 3 - Logical and Lookup Functions
Section 1: Logical If Functions
Logical Functions are very useful in identifying and providing multiple outcomes. They can evaluate data and determine several possible answers in making decisions. These decisions relieve you from making mistakes. "If" conditions include operators such as Greater Than, Greater Than/Equal To, Less Than, Less Than/Equal To, Equal To, and Not Equal To. The result of these conditions is either true or false. Another set of Logical Functions that are covered will add up many fields based on input criteria such as CountIF, SumIF, and AverageIF functions. The following functions will be covered: IF Statement, Nested IF, IFError, AND, OR, NOT, IFS, Switch, SumIF, CountIF, AverageIF, SumIF 3 Parameters, MAXIFS, MINIFS, SumIFS, AverageIFS, and CountIFS functions.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
56
views
Excel 365 Part 10 – Formula Programming
In this video, we will learn how to manipulate dates using formulas and text formulas. Students will learn how to extract attributes from a date using Today, Now, Proper Case, Weekday functions. Also, they will learn to patch text strings in cells together and split a single cell into two columns. We will then extract characters from the left or right side using text manipulation capabilities. Text manipulation can be used with mail lists and other text-intensive databases to straighten out information that might be improperly displayed. This section will also review Financial, Informational, and Math functions.
Video Series Part 10 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch2.mp4
- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.
Courseware: Excel 365 - Formulas, Charts, And PivotTables
The courseware is available on Amazon at: https://www.amazon.com/dp/1660221943
Excel 365 Chapter 2 – Formula Programming
This chapter reviews a wide range of Formula capabilities including Date, Time, Text, Financial, and Math functions
Chapter Contents:
Section 1: Date/Time Functions
In this video, Students will learn how to manipulate dates using formulas to accomplish a final result. They will also learn how to extract attributes from a date using Today, Now, Proper Case, or Weekday functions. The following functions will be covered: Today, Now, Year, Month, Day, Weekday, Choose, Workday, Date, Days, Networkdays, ISOWeekNum, and Time functions.
Section 2: Text Functions
In this section, students will learn to patch text strings in cells together and split a single cell into two columns. They will then extract characters from the left or right side using text manipulation capabilities. Text manipulation can be used with mail lists and other text-intensive databases to straighten out information that might be improperly displayed. The following functions will be covered: Left, Mid, Right, Concatenate, Concat, & Character, Proper, Upper, Lower, Len, Char, Trim, Text To Columns, Text, Find, Value, Substitute, and TextJoin functions.
Section 3: Financial Functions
Some students may need to better understand the capabilities of Financial functions. Students will learn to use the Insert function (Fx) to manipulate and understand formula structure. Financial formulas require several unique parameters to generate a final result and this section will explain a few commonly used Financial formulas such as Future Value (FV), PMT, IPMT, and PV functions.
Section 4: Information Functions
This section will extract information from cells to better understand and make necessary changes. The result will allow you to determine if an answer is valid or if it produces an error. These functions can be used in IF statements to further make valuable decisions about the accuracy of a spreadsheet. The following are a few functions that will be covered: IfError, ISBlank, and ISError functions.
Section 5: Math Functions
This will review math manipulation Formulas such as Product, Value, NumberValue, Round, RoundDown, RoundUp, Rand, and Randbetween functions. These Math Functions will be able to adjust the accuracy of results.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
64
views
Excel 365 Part 9 – Standard Formula Features
In this video, the foundation will be laid for creating and naming a range of cells used to manipulate a formula. These names will then be used to create functions across worksheets. We will also cover 3D Formulas and Statistical Formulas.
Video Series Part 9 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch1.mp4
- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.
Courseware: Excel 365 - Formulas, Charts, And PivotTables
The courseware is available on Amazon at: https://www.amazon.com/dp/1660221943
Chapter 1 – Standard Formula Features
In this courseware, the foundation will be laid for creating and naming a range of cells used to manipulate a formula. These names will then be used to create functions across worksheets. We will also cover 3D Formulas and Statistical Formulas.
Chapter Contents:
Section 1: Range Names
Excel Named Ranges enable you to define one cell, a group of cells, or a name other than the default name of A1, or A2:B5 for a range of cells. This can be used in formulas, selection, and navigation between sheets. The following concepts will be covered: Name Box, Single Cell, Range Of Cells, Goto Range Name, Name Manager, Use In Formulas, Define Name, Create From, Selection, Apply Name, Hidden Range Name
Section 2: 3D Formulas Across Worksheets
A 3D formula in Excel refers to referencing and adding up cell values across worksheets. A single worksheet is considered two-dimensional such as Rows vs Columns; however 3D will cross over worksheets. You can also use formulas across worksheets or use standard math operations. This capability can also be done across workbooks. The following concepts will be covered.: References, Manual Addition, Sum Across Sheets,
Section 3: Statistical Functions
In this chapter, we will look at several Statistical Functions that can be used to look at a range of cells and produce a new result. These are sometimes called Aggregate functions because they look at a group of cells or ranges. The following are a few examples of Statistical Functions covered: Sum, Average, Count, Counta, Countblank, Max, Min, Median, Stdev.d, and Mode Functions.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
62
views
Excel 365 Part 7 – Printing A Spreadsheet
In this video, we will demonstrate how to use the Printing interface to Print Excel spreadsheets. Often, spreadsheets do not fit on a single 8-1/2 x 11 page. However, Excel has the features to ensure everything will fit perfectly. This chapter will cover the Page Layout Ribbon, Print Preview Screen, Page Setup, and Headers/Footers.
Video Series Part 7 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch7.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 7 – Printing A Spreadsheet
Chapter Contents:
Section 1: Page Layout Ribbon Tab
This will adjust the Document/Page Layout prior to Actual Printing.
Section 2: Print Preview
This is the standard Print Preview screen showing how documents will fit on a page. It will include changing the “Printer Properties” and “Print the Selected Area.”
Section 3: Page Setup
This dialog box can be displayed from the Page Layout Ribbon Tab (clicking the small arrow in the lower-left corner of the Page Setup Group). You will find some commonly used setups such as margins, backgrounds, and sizes. The Page Setup Dialog Box can also be opened in the File TabPrint screen on the bottom.
Section 4: Header/Footer
There are several ways to add Header and Footers.
102
views
Excel 365 Part 8 – Options and Final Project
Application Options will adjust the behavior of the program and the final projects will provide some hands on experience with Excel. The following Application options will be covered: User Interface Options, New Workbook, Calculation Options, Autocorrect, Dictionary, Auto-Recover, Default Location, Developer Tab, Update Properties, Show Document Panel, Mouse Roller, AutoFill Smart Tag, and Turn Off Green Marker. The following Final Projects will be covered: Creating a Budget, Yearly Budget, Business Income/Expense, and Home Inventory.
Video Series Part 8 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-cha.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Appendix A – Application Options
The following concepts will be covered: User Interface Options, New Workbook, Calculation Options, Autocorrect, Dictionary, Auto-Recover, Default Location, Developer Tab, Update Properties, Show Document Panel, Mouse Roller, AutoFill Smart Tag, and Turn Off Green Marker.
Appendix B - Final Project
The following Final Projects will be covered: Creating a Budget, Yearly Budget, Business Income/Expense, and Home Inventory.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
129
views
Excel 365 Part 6 - Formatting
Once Formulas are entered, the spreadsheet must be formatted to look presentable. The Font Group contains some of the most commonly used font and character commands. There are some very unique and extremely useful commands in the Alignment Group available to effectively format a worksheet. Also, the Number Group will allow you to fine tune number and date styles.
Video Series Part 6 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch6.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 6 - Formatting
Chapter Contents:
Chapter Contents:
Section 1: Font Group
The Font Group contains some of the most commonly used font and character command. The following concepts will be covered: Dynamic Preview, Font Type, Font Size, Font Increase, Font Decrease, Bold, Italics, Underline, Font Color, Format Painter, and Font Effects.
Section 2: Alignment Group
There are some very unique and extremely useful commands in the Alignment Group available to effectively format a worksheet. The following concepts will be covered: Merge And Center, Word Wrap, Vertical Alignment, Horizontal Alignment, Rotation, Rotation At Any Angle, Indent, Hard Return, and Center Across Selection.
Section 3: Number Group
The Number Group will allow you to fine tune number and date styles.
The following concepts will be covered:General Format, Number Format, Currency Format, Accounting Format, Short Date Format, Long Date Format, Time Format, Percent, Decimal Points, Fraction Format, Scientific Format, Text Format, and More Number Options.
Section 4: Border & Fill Cells
The following concepts will be covered: Border & Fill Format, All Border, Thick Outside Border, Border Outline, Border Color, Border Edge, Border Style, Border Placement, Fill, More Colors, Custom, and Conditional Formatting.
62
views
Excel 365 Part 5 – Worksheets
It is important to know how to create a New Sheet within a Workbook (or file). Worksheets are oftentimes referred to as Sheets. It is valuable to be able to easily manipulate Rows and Columns which are located on the top and left side of the interface. Also, there are many ways to manipulate and adjust Large Worksheets, as well.
Video Series Part 5 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch5.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 5 - Worksheets (Sheets)
Chapter Contents:
Section 1: Worksheet (Sheet) Tabs
In this section, we will explore how to manipulate Sheets located on the bottom of the interface. The following concepts will be covered: Insert Sheet, Delete Sheet, Rename, Move, Copy, Move/Copy To Workbook, Tab Color, Hide Sheet, Unhide Sheet, Navigation Arrows, View Navigation, Select Multiple, and Select Sheets.
Section 2: Column And Row Manipulation
It is valuable to be able to easily manipulate Rows and Columns which are located on the top and left side of the interface. Here, we will explore how to manipulate Columns and Rows. The following concepts will be covered: Insert Row/Column, Delete Row/Column, Clear Contents, Select Rows/Columns, Manual Row/Column Width, Row/Column Width, Evenly Space Columns / Rows, Hide/ Column Or Row, Unhide Column Or Row.
Section 3: Large Worksheets (Sheets)
In this section, we will explore different techniques to manage Large Documents. The following concepts will be covered: Freeze Panes, Split, Hide Columns, View Side-By-Side, Reset Window Position, View Two Sheets Side-By-Side, Switch Windows, Hide Workbook, Create Data List Outline, and Clear Outline.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
72
views
Excel 365 Part 4 - Formula Manipulation
Once a Formula or Function is created, you may want to copy or move the result to a new location. You can also complete one formula and Copy it to other cells in order to complete a group using the Fill Handle, Fill Down or Copy/Paste techniques. Therefore, this chapter will discuss Cut, Copy, Fill Handle, Paste Special, Drag/Drop, and Absolute/Relative references.
Video Series Part 4 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch4.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 4 - Formula Manipulation
Chapter Contents:
Section 1: Formula Manipulation
The techniques in this section can be used to duplicate a completed formula to multiple cells using the following concepts: Copy, Paste, Cut, Drag-and-Drop Editing, Drag-and-Drop Copy, Undo/Redo, Multiple Cells, and Inconsistent Formula.
Section 2: Fill Handle
The techniques in this section can be used to duplicate a completed formula to multiple cells and creates common patterns for text using the following concepts: Fill Down Formulas, Fill Handle Formulas, Double Click, Fill Handle Text, Fill Handle Options, Learned Pattern, Flash Fill, and Flash Fill Button.
Section 3: Paste Special
This will Copy and Paste Special attributes of a cell. One very useful command is the Paste Special Values option that can be used to paste the value of a formula which eliminates the formula code.
Section 4: Relative And Absolute Referencing
This will allow a single cell to remain fixed when copied. The following concepts will be covered: Relative / Absolute References.
253
views
Excel 365 Part 3 – Formulas and Functions
Formulas are one of the most important aspects of Excel. The most commonly used Formulas are covered in this video. This includes Sum, Average, Min, Max, and Count Numbers, as well as manually entered formulas. Functions are a combination of formulas and mathematic operators (such as: +, -, /, *) used in combination.
Video Series Part 3 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch3.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 3 - Formulas And Functions
Chapter Contents:
Formulas are one of the most important aspects of Excel. The most commonly used Formulas are covered in this manual. This includes Sum, Average, Min, Max, and Count Numbers, as well as manually entered formulas. Functions are a combination of formulas and mathematic operators (such as: +, -, /, *) used in combination.
In this book the following concepts will be covered: Formula Corrections, Accept Formula, Operators (_, -, *, /), Order of Operations, Autosum ∑ Icon, Manually Entering Formulas, Manual Addition, Autosum ∑ Pull-Down Option, Check Formulas, Range Borders, Autocalculate, Feature Located in the Status Bar, Autocorrect Math Errors, Edit Formula, Autocomplete Formula, and Insert Function Fx.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
65
views
Excel 365 Part 2 – Data Entry Techniques
This video will focus on Data Entry techniques. It will provide details to type data quickly within cells in order to be more organized. Keyboard commands can also be used to speed things up by using a single key or combination of keys which would otherwise require multiple menu clicks. Overall, this video will provide shortcut tips and tricks to reduce time and be more productive.
Video Series Part 2 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch2.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 2 - Data Entry Techniques
Chapter Contents:
Section 1: Cell Manipulation
This chapter will focus on Data Entry techniques. It will provide details to type data quickly within cells in order to be more organized. This includes Autocomplete, entering text, and selection techniques. The following concepts will be covered: Autocomplete, Pick From Dropdown List, Tab Enter, Entering Text, Select Enter Text, Select Using The Keyboard, and Adjacent Selection.
Section 2: Keyboard Commands
Keyboard commands can be used to speed things up by using a single key or combination of keys which would otherwise require multiple menu clicks. This includes keys to format cells, manipulate data, cell movement, file commands, formula, window, and worksheet manipulation.
119
views
Excel 365 Part 1 - Overview Of The Interface
In this video, we will demonstrate how to use the Excel interface in order to navigate, zoom, and switch screen layouts. Also, we will discuss location of commands in the Quick Access Toolbar, File Menu, and other screen layouts.
Video Series Part 1 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-1-ch1.mp4
Click + Rumble or +Like if the video was helpful.
Click Subscribe so you won’t miss out on any new videos.
Click the Share button so you can help others expand their skills.
If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com
Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video. The courseware is available on Amazon at: https://www.amazon.com/dp/1660217326
Courseware: Excel 365 - Formulas, Formatting, And Printing
Chapter 1 - Overview Of The Interface
Chapter Contents:
Section 1: Interface
In this section, we will review the Interface and Navigation techniques, along with the following concepts: Dialog Box Launcher, Formula Bar, Contextual Ribbon Tab, Gallery, Format Shape, Zoom Features, Zoom Slider, Formula Bar, Status Bar, Minimize/Maximize/Close, Buttons, Hide Ribbon, Quick Access Toolbar, Dynamic Preview, Office Theme, Text Box, and Take A Screenshot.
Section 2: Cell References
In this section, we will cover Cell Reference capabilities, Range Manipulation, Mini Toolbar, Context Menu, Find, Replace, Smart Lookup, and Quick Analysis.
Section 3: Backstage View (File Menu)
In this section, we will address the capabilities in the File Tab (also called the Backstage View), along with the following concepts: New Workbook, Template, Save, Save As Type, Open, Close, Dual Monitors, Exit Excel, Recent, Pinning Files, Compatibility Checker, Properties, Protect Workbook, Check For Issues, and PDF Creation Techniques.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
274
views