Category - Excel Tutorials

How to Create Pivot Tables in Excel

How to Create Pivot Tables in Excel

Creating a pivot table in Excel allows the user to quickly and easily summarize and arrange large amounts of data, and then pull certain details …

Read More

Calculating Averages in Excel Tutorial

Along with basic math formulas, Excel also has the ability to calculate averages. Since solving averages by hand is boring and tedious, let a computer …

Read More

Basic Math in Excel

Basic math in Excel

One of Excel’s most fundamental utilizations is its ability to formulate and solve basic math for the user. Basic math in Excel is done through …

Read More

Formatting Data in Excel Spreadsheets

Formatting Data in Excel Spreadsheets

Excel allows the user the ability to customize their spreadsheet to their own aesthetic. Changing elements such as fonts, borders, and colors is all done …

Read More

How to Use Cell References

How to Use Cell References

Excel offers another function for users who facilitate the program for formula creation: Cell Reference Formulas. There are two types, Absolute and Relative. Learn how …

Read More

Adding a Header and Footer in Excel

Just like any document, adding a header and footer in Excel is good way to make a presentation or chart look clean, professional, and easy …

Read More

Adding Columns and Rows in Excel

Adding Rows and Columns to Excel

Adding additional rows and columns in a table in Excel is needed when updating and adding onto an existing Excel sheet. The process is quick and …

Read More

How to Change a Cell’s Movement

After you’ve already entered a cell and clicked “enter”, you can still change the cell’s movement. Here is how to adjust it: Click the “File” …

Read More
Page 5 of 5