Excel Graphical user interface and its components

This video describes each element or component of user interface of excel 2016.
Customization of Excel Quick Access Tool Bars (QAT):https://youtu.be/1aK3EZ6XLeM
Customization of Microsoft Excel Ribbon: https://youtu.be/g81CyFk8EY4
Excel user interface has below, not limited to, components or elements:
1. Ribbon: Tab or Menu, group, command, dialog box launcher
2. Quick Access Toll Bars
3. Title Bar
4. Window Controls: minimize, restore down, close
5. File Button
6. Select all Box
7. Cell Name Box: Reference of active cell
8. Formula or editor bar
9. Column Header/Column letter: letters from A to XFD, total of 16384 columns available.
10. Row header/Row number: numbers from 1 to 1048576, total of 1048576 rows available.
11. Cell
12. Active Cell: Active cell inside Excel Worksheet has thick border outline around the cell.
13. Worksheet tab scroll/page scroller
14. Worksheet tab
15. Add worksheet button/icon
16. Horizontal (left & right) scrollbar and Vertical (up & down) scrollbar:
17. Page view: Normal, Page Layout, Page Break
18. Zoom Bar: used to zoom in or zoom out of Excel worksheet
19. Status: Ready, Enter, Edit, Point
00:01:24 Excel Ribbon,
00:05:26 Excel Quick Access Tool Bar,
00:06:04 Excel Title Bar
00:07:10 Excel Ribbon Display Options
00:07:45 Excel Window Controls
00:09:55 Excel Worksheet
00:10:26 Excel Column & Column
00:11:03 Excel Cell
00:11:27 Excel Active Cell
00:11:59 Excel Formula or editor bar
00:15:29 Excel Worksheet tab scroll/page scroller
00:16:14 Excel Worksheet tab
00:16:42 Excel left & right and up & down scrollbar
00:16:54 Excel Status
00:18:56 Excel Page view
00:19:19 Excel Zoom Bar
This channel offers videos on the three essential MS Office programs: Excel, Word and PowerPoint.
MS excel tutorials offer the basics of Microsoft Excel all the way to Excel mastery.
My Microsoft Excel Tutorials cover, but not limited to:
►Opening of Excel file on Windows 10.
►Excel start screen.
►Excel user interface and its different elements: Excel Quick Access Tool Bar, Title Bar, Window Controls, Ribbon, File Button, Select all Box, Cell Name Box, Formula or editor bar, Column, Row, Cell, Active Cell, Worksheet tab scroll/page scroller, Worksheet tab, Add worksheet button/icon, left & right and up & down scrollbar, Page view, Zoom Bar, Excel Status,
►Customization of Quick Access Toolbar
►Customization of Ribbon
►Data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.
►Rules and rules managing in Microsoft Excel Conditional formatting
►Basic Conditional formatting sets (Top 10, bottom 10, Average, date, text and etc.) in Microsoft Excel
►Conditional formatting on a whole row or column in Microsoft Excel.
►Formatting skills (different types of formatting, how to highlife and hide information by using formatting) in Microsoft Excel.
►Cell references: Relative cell references, Absolute cell references, Mixed cell reference
►Formula such as SUM, AVERAGE, RAND, MIN & MAX, SUMPRODUCT, TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID, AND & OR, IF, COUNTIF, SUMIF, TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS, VLOOKUP, HLOOKUP, INDEX, MATCH
►Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns).
►Pivot tables end-to-end.
►Charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines Bar & Column charts
►Recording a Macro, running a Macro and creating a button to run a Macro.

My tutorials include basic level, intermediate level and advanced level of MS Word.

With the PowerPoint tips you will have a comprehensive understanding of the most popular, really powerful, and dynamic presentation performing software on the market and you will be able to utilize PowerPoint to create stunning presentations. You could get your life on a new level after studying this Microsoft Power Point.
Watching my videos on freelancing you can learn how to open freelancing account specifically on Upwork and get that first job and earn excellent feedback which will help you kickstart your Freelancing career.
My tutorials cover, but not limited to:
►How to Build a freelancer Profile on Upwork Step-by-Step Instructions from Scratch
►How to set your rates
►Upwork Payment System and how to add payment method
►How to find Jobs
►How to submit proposal


#ExcelUserInterface #ExcelInterfaceComponents #ExcelInterfaceElements