Excel Basics
· 👇👇👇👇👇👇👇👇👇👇👇
Getting Started with Excel
Learn your way around the Excel environment.
·
Understanding OneDrive
: Learn all about working with your Microsoft account and OneDrive.
·
Creating and Opening Workbooks
: Learn how to create and open Excel workbooks.
·
Saving and Sharing Workbooks
Learn how to save and share Excel workbooks.
Working with Cells and Sheets
·
Cell Basics Learn
how to insert and delete cells and cell content, drag and drop cells, use the
fill handle, and use the cut, copy, and paste functions.
·
Modifying Columns, Rows, and
Cells Learn how to modify rows, columns, and cells in Excel.
·
Formatting Cells
Learn all about formatting text in Excel.
·
Understanding Number Formats
Learn all about formatting numbers in Excel.
·
Working with Multiple
Worksheets Learn how to add, delete, copy, and move worksheets,
as well as group and ungroup worksheets.
·
Using Find & Replace
Learn how to use Excel's Find and Replace features to search for specific data.
·
Checking Spelling
Learn how to use Excel's spell check feature.
·
Page Layout and Printing
Learn how to use Excel commands that let you control the way your content will
appear on a printed page.
Formulas and Functions
·
Intro to Formulas
Learn how to use cell references to create a simple formula in Excel.
·
Creating More Complex Formulas
Learn how to create a complex formula in Excel.
·
Relative and Absolute Cell
References Learn all about absolute and relative cell references
and how they're used in Excel.
·
Functions Learn
the different parts of a function and how to create arguments to calculate
values and cell references.
Working with Data
·
Basic Tips for Working with
Data Learn these basic tips for working with data to help you
organize it and find what you need.
·
Freezing Panes and View Options
Learn how to freeze panes and split your worksheet so you're only seeing
certain parts of your worksheet.
·
Sorting Data : Learn
how to sort data to better view and organize the contents of your spreadsheet.
·
Filtering Data : Learn
how to filter the data in your worksheet to display only the information you
need.
·
Groups and Subtotals : Learn
how to organize data in groups, summarize different groups using the Subtotal
command, and create an outline for your worksheet.
·
Tables : Learn how
to use styles to format tables in Excel.
·
Charts : Learn how
to insert and modify Excel charts to visualize comparisons in your data.
·
Conditional Formatting : Learn
how to apply, modify, and delete conditional formatting rules in Excel.
Doing More with Excel
·
Comments and Co-authoring : Learn
how to use Excel's track changes and comments features when proofreading
workbooks.
·
Inspecting and Protecting
Workbooks : Learn how to inspect and protect your Excel workbook.
·
Intro to PivotTables : Learn
how to use PivotTables in Excel for stronger data analysis.
·
Doing More with PivotTables : Learn
how to do more with PivotTables to better summarize data.
·
What-if Analysis : Learn
how to use what-if analysis to answer different types of questions.
Thanks For Visit Our Site
