Stride
Home
More
Login/Register
Stride
Login
Sign up!
support@peritumagri.com
×
Login to your account
Don't have an account?
Sign up!
Remember username
Lost password?
Log in
Global searching is not enabled.
E/LMS 714 Excel Basic
Home
Courses
E/LMS 714
Lesson 10 - Formatting of Cells
Autosum, Custom Format Values
Skip to main content
File
Autosum, Custom Format Values
Completion requirements
View
Click
Autosum custom format values.mp4
link to view the file.
◄ Format Overview
Jump to...
Jump to...
Instructions
Quick Access Toolbar
Menu Tabs
Groups
Ribbon Display Options
Formula Bar
Name Box
Select All
Scroll Bars
Sheet Tabs and Control Buttons
Status Bar
Page Views
Zoom
Number Of Sheets
R1C1 Reference Style
After Pressing Enter, Move Selection
Formula Bar, Sheet Tabs, Row And Column Headers
Dealing With Zero Values
Mouse Pointer Shapes
Working File: Mouse Pointer Shapes
Mouse Selection Technique 1
Mouse Selection Technique 2
Working File: Mouse Selection Techniques
Entering Data In a Cell
Edit Using The Formula Bar
Edit Cell Content Directly In a Cell
Inserting a Note in a Cell
Inserting a Comment in a Cell
Delete Note and Comment
Working File: Entering and Editing of Data
Rename a Sheet
Hide and Unhide Sheets
Deleting a Worksheet
Selecting Different Sheets
Copy a Sheet (Method 1)
Copy a Sheet (Method 2)
Copy a Sheet (Method 3)
Working File: Working With Sheets 1
Working File: Working With Sheets 2
Hide and Un-hide Rows
Hiding and Un-Hiding of Columns
Insert and Delete Columns
Inserting and Delete Rows
Resizing Columns
Row Height
Working File: Working With Rows and Columns
Copy and Paste
Moving and Insertion of Text
Working File: Copy, Paste and Insertion of Text
Autofill
Custom list
Working File: Autofill
Wrap Text
Format Cells Currency
Working File: Format Cells Currency
Merge and Centre
Working File: Merge and Centre
Format Cells Font
Working File: Format Cells Font
Format Cells Time
Format Cells Text
Format Borders and Fill
Format Cells Accounting
Custom Format
Working File: Custom Format Example 1
Working File: Custom Format Example 2
Format Overview
Format Painter
Working File: Format Painter
Adding Non Consecutive Cells
Addition Method 1
Addition Method 2
Addition Method 3
Division
Multiplication
Subtraction
Working File: Operators
Average
Max
Min
Working File: Min, Max And Average Function
Sorting 1
Sorting 2
Sorting 3
Sorting 4
Sorting 5
Working File: Sorting
Value
Comment
Paste Link
Multiply
Transpose
Working File: Paste Special
Post-Assessment
Participant Feedback
Format Painter ►
Stride
Copyright © 2024 Peritum Agri Institute. All Rights Reserved.