Creating More Complex Formulas

Course Content

المحتوى

0/47

Introduction to Excel

Getting Started with Excel

Creating and Opening Workbooks

Saving and Sharing Workbooks

Cell Basics in Excel

Modifying Columns, Rows, and Cells

Formatting Cells

Understanding Number Formats

Working with Multiple Worksheets

Using Find and Replace

Page Layout and Printing in Excel

Introduction to Formulas

Creating More Complex Formulas

Relative and Absolute Cell References

Using Functions in Excel

Solving Real-Life Problems in Excel

Freeze Panes and View Options

Sorting Data in Excel

Using Groups and Subtotals

Creating Tables in Excel

Creating Charts

Applying Conditional Formatting

Using Comments and Co-authoring

Inspecting and Protecting Workbooks

Introduction to PivotTables

Advanced PivotTable Techniques

What-If Analysis in Excel

Quick Tip: Add the Current Date to a Cell

Quick Tip: A Faster Way to Use the Fill Handle

Quick Tip: Two Ways to Use the Format Painter

Quick Tip: A Shortcut to AutoSum

Quick Tip: Quick Access Toolbar Shortcuts

Quick Tip: How to Quickly Duplicate a Sheet

Quick Tip: Jump to Any Sheet with a Shortcut

Quick Tip: Select an Entire Row or Column

Quick Tip: Find a Sum Without Using a Formula

Quick Tip: Why You Should Avoid Merging Cells

Quick Tip: Using the Quick Analysis Tool

Quick Tip: How to Make Charts Auto Update

Quick Tip: Use Transpose to Flip Data

Quick Tip: Absolute References with the F4 Key

Quick Tip: Add a New Row with a Shortcut

Quick Tip: Use an Entire Column as a Cell Range

Quick Tip: What are Named Ranges

Quick Tip: A Trick for Finding Inconsistent Data

Final Exam - Introduction to Excel: A Beginner’s Guide

Introduction to Excel: A Beginner’s Guide

Build on your knowledge to create more advanced formulas for intricate calculations.

0% Complete

Sign inSign up

Sign in

Don’t have an account? Sign up

Remember meLost your password?

Sign up

Already have an account? Sign in