Microsoft Excel Fundamentals

Explore building a simple spreadsheet by entering data, applying number formats, using functions and formulas, and formatting with borders, shading, and conditional formatting, plus leveraging Excel tables for organization.

Enter names, dates, and scores to build a simple scoring sheet in Excel fundamentals; bold headings, rotate text, resize columns, and auto-fill weekly dates using the fill series.

Explore how Excel number formats control how data is displayed without changing values. Discover customizable formats such as general, currency, accountancy, fractions, dates, times, percentages, scientific notation, and text.

Explore how formulas operate on cell values and ranges in Excel, using cell references to keep totals updated, and apply functions such as sum, average, min, and max.

Use the countif function to tally wins by counting cells equal to 21 in the score range. Insert the function, set the range and criteria, and copy the formula down.

Learn how to use Excel's count function to tally games played by counting numeric cells in a range, create a played column, and replicate the formula down the column.

Master vlookup to search the first column of a table and return the adjacent cost, using an exact match example with shipping options.

Practice what you learned in the Excel fundamentals course by downloading the PDF in resources, completing the tasks, and reviewing earlier lectures to apply the techniques.

Explore relative, absolute, and mixed cell references to control how formulas adjust when copied, using the dollar sign to lock columns or rows.

Learn how to add and delete rows and columns in Excel to organize data, create space for headers and formulas, and categorize data using right-click insert and delete.

Learn how to merge cells in Excel to create headers and improve layout, using merge and center, merge across, and unmerge cells to control alignment.

Freeze the top row or first column to keep headers visible while scrolling. Split panes let you view different parts of a worksheet at once from the View tab.

Sort data in Microsoft Excel fundamentals by arranging records alphabetically or numerically, ascending or descending. Use custom sort with multiple levels—last name then hire date, oldest to newest.

Learn to filter data in Excel by displaying only rows that meet a criterion, such as department equals marketing, using the filter controls in the home ribbon.

Learn how to use cell borders and shading to organize and highlight data in Excel, apply outside borders or all borders, and remove borders for cleaner spreadsheets.

Apply conditional formatting to cells based on criteria, using data bars, color scales, and icon sets to visualize totals and identify trends, including top and bottom rules.

Explore how to save workbooks in different formats, print, and share them. Learn how to prepare your spreadsheet for printing.

Save workbooks in excel by using save as, choosing OneDrive or this PC, adding locations, naming the file, and enabling Auto Save for cloud access.

Open workbooks in Excel by using the recents list, choosing open, or browsing locations like OneDrive or your computer, then navigate to the saved folder and open.

Adjust page margins in Excel by selecting the page margin icon at the bottom right, then use the double-sided arrow to set left, right, top, bottom, and footer margins.

Select the cell range you want to print, then switch the print settings from print active sheets to print selection and view the preview. Print the selected range when ready.

Export your workbook as a pdf to share a non editable version, using file export, create pdf document, and publish after naming the file.

Explore how to visualize data in Microsoft Excel with line, pie, and bar charts, choosing the right chart to reveal trends, proportions, and group comparisons.

Explore how to plot a line chart in Microsoft Excel by selecting a data range, inserting the chart, and customizing axis titles, data labels, and legend with styles and filters.

Practice what you learned by completing the pdf exercises in the resources. Download the document, apply the techniques from the lectures, and review earlier lessons if you get stuck.

Explore data validation techniques to protect the integrity of data entered into a spreadsheet, learn various rules, and minimize errors while maintaining consistency.

Apply data validation rules in Excel to enforce whole-number inputs between 100 and 999, and use a drop-down list sourced from a cell range to restrict item categories.

Engage with Microsoft Excel fundamentals by completing assignment 5: download the PDF in resources, tackle the questions, review earlier lectures, and apply the demonstrated skills.

Explore data analysis and its application to spreadsheets to make decisions and extract information, using goal seek, scenario manager, and pivot tables to analyze data.

Explore data analysis by transforming and modeling raw data to inform decisions, using filtering, sorting, functions, goal seek, scenario manager, pivot tables, and charts for insights.

Learn how goal seek uses what-if analysis to find the required units sold to reach a 10,000 profit, by setting the target cell and changing the unit sold in Excel.

Download the pdf in the resources section to complete the assignment, practice the techniques covered in the lectures, and review previous lectures if you need help.

Use scenario manager to perform what-if analysis by creating multiple value sets for sales volume, price per unit, and cost per unit, then compare profits without altering your data.

Learn to use pivot tables to summarize large data sets, dynamically rearrange by sales channel and title, filter and sort data, and analyze revenue with no formulas.

Download the resources pdf document, complete the questions and tasks to practice the techniques covered in the lectures, and review previous sessions if needed to apply the demonstrated skills.

Enable real-time collaboration by sharing and saving Excel workbooks to OneDrive or SharePoint, so multiple users work from any location, with cell comments for direct feedback, via Microsoft 365.

Save the workbook to OneDrive, share it with colleagues, and set permissions (can edit or can view); send the link by email and see markers with initials where recipients edit.

Record actions to automate operations in Excel, including formatting, data manipulation, and calculations. Save them as macros and play back with a click, noting harmful code from an unknown source.

Record a macro in Excel to format sales data by setting column widths, bold headings, date formats, and currency alignment, then stop and view macros.

Execute a previously recorded macro to format the current sales report, using the view macros menu to select the macro and click run on the worksheet.

Master Excel fundamentals, from interface navigation and workbooks to data entry, formulas, sorting, charts, validation, pivot tables, sharing, and macros.

Explore the course textbook, linked resources, and a regularly updated blog to deepen your Excel skills with practical tips and tutorials.