Creating Formula in MS Excel | Operators In MS Excel | Rules For Creating Formula | Example | Part-8
#techniboat #formulaexcel #operatorsexcel
How to create formula in excel, rules for creating formula in excel, operators used in excel, creating formula example
=========================================
Topics Covered
=========================================
What is formula?
Operands in excel
Operators in excel
Arithmetic operator in excel
Comparison operator in excel
Range operator in excel
Rules for creating formula in excel
Example of creating formula in excel
Find total of given numbers in excel
Find average of given numbers in excel
========================================
Useful Links to Learn More
========================================
For New and Latest Videos Check This
/ @techtipnow
Programming In C
• C Programming Language
Programming In C++
• C++ Programming Language
Programming Approaches And Concepts • Programming Approach Concept
Pointer In C/C++
• Pointer In C/C++
Examples of Pointers In C/C++
• Example Program of Pointers in c/c++
Computer Awareness and GK
• Computer Awareness GK
Python Programming
• Python Programming
Python Examples
• Python Program Examples
Interesting Facts of Computers
• Intresting Facts
========================================
Excel Full Course (Syllabus)
========================================
CHAPTER 1- GETTING STARTED WITH EXCEL
About Excel
The Excel Environment
The Title Bar
The Ribbon
Scroll Bars
The Formula Bar
The Status Bar
The Zoom Slider
CHAPTER 2- CREATING BASIC WORKBOOKS
Creating New Workbooks
Saving Workbooks
Closing Workbooks
Opening Workbooks
CHAPTER 3- CREATING FORMULAS
Ranged Formula Syntax
Simple Formula Syntax
Writing Formulas
Using AutoSum
Inserting Functions
AutoCalculate
CHAPTER 4- COPYING & PASTING FORMULAS
Relative References and Absolute References
Cutting, Copying & Pasting Data
AutoFilling Cells
CHAPTER 5- COLUMNS & ROWS
Adjusting Column Width and Row Height
Hiding and Unhiding Columns and Rows
Inserting and Deleting Columns and Rows
CHAPTER 6- FORMATTING WORKSHEETS
Formatting Cells
The Format Cells Dialog Box
CHAPTER 7- WORKSHEET TOOLS
Moving between Worksheets
Inserting and Deleting Worksheets
Renaming Worksheets
CHAPTER 8- SETTING WORKSHEET LAYOUT
Using Page Break Preview
Using the Page Layout View
The Page Setup Dialog Box
CHAPTER 9- 3D FORMULAS
Creating 3D Formulas
Creating 3D Range References
CHAPTER 10- NAMED RANGES
Naming Ranges
Creating Names from Headings
Using Named Ranges in Formulas
Naming 3D Ranges
Managing Named Ranges
CHAPTER 11- CONDITIONAL FORMATTING AND CELL STYLES
Conditional Formatting
Finding Cells with Conditional Formatting
CHAPTER 12- PASTE SPECIAL
Using Paste Special
Pasting Linked Formulas
CHAPTER 13- SHARING WORKBOOKS
Sharing Workbooks
Reviewing Changes
Using Comments
Compare and Merge Workbooks
CHAPTER 14- SORTING DATA
Sorting Data
Custom Sort Orders
CHAPTER 15- FILTERING DATA
Using AutoFilters
Applying a Custom AutoFilter
Creating Advanced Filters
Applying Multiple Criteria
Using Database Functions
CHAPTER 16- USING WHAT-IF ANALYSIS
Using Data Tables
Using Goal Seek
CHAPTER 17- SECURITY FEATURES
Unlocking Cells
Worksheet Protection
Workbook Protection
CHAPTER 18- MAKING MACROS
Recording Macros
CHAPTER 19- CREATING WORKSHEET CHARTS
Creating Charts
Selecting Charts and Chart Elements
Moving and Resizing Charts
Changing the Chart Type
Changing the Data Range
Switching Column and Row Data
Choosing a Chart Layout
CHAPTER 20- EDITING AND FORMATTING CHARTS
Formatting Chart Objects
Changing Chart Labels
Changing Axes Display
Changing the Chart Background
CHAPTER 21- PIVOTTABLES
Creating PivotTables and PivotCharts
Setting PivotTable Options
Sorting and Filtering PivotTable Data
========================================
Support Me By (It’s Free)
========================================
Comment – If you have any query
Like – If this video is helpful
Share – if anyone wants to learn
Subscribe – Help & Motivate Me to Do Well
========================================
Get In Touch
========================================
My Youtube Channel - / techtipnow
My Facebook Page - / techtipnow-389499145023520
My Twitter
My Instagram
My Pinterest
========================================
Thanks For Watching and Appreciation…..