Spreadsheet Mastery: Google Sheets & Excel 101

Explore the anatomy of an Excel workbook and its name box, navigate the ribbon and cells, edit data with double-click or the formula bar, and undo with Ctrl+Z.

Master basic formatting in Excel, including fonts, font sizes, styles, borders, and wrap text. Apply merge and center, currency formats, Format Painter, and conditional formatting to present data clearly.

Sort and filter data in Excel to organize insights, then create tables with headers and a total row for quick calculations like average, max, and min.

Create and customize charts in Excel to visualize data, using the insert tab, chart types, and elements like axis titles and legends, with print preview and landscape orientation.

Master data analysis in Excel by importing CSV data, using text to columns, applying filters and sorts, and building pivot tables with charts for quick visualization.

Learn to protect workbooks and sheets, share and co-author in real time with Excel 365, and print or export data as PDF, with practical print and sheet protections.

Boost efficiency with Excel and Google Sheets by mastering Mac and Windows shortcuts, table creation, data navigation, formatting, autosum, flash fill, and add-ins like maps and QR codes.

Explore advanced excel concepts like linking data across multiple sheets and using vlookup, index, match, and if, plus macros and automation for efficient data processing.

Apply everything learned to real-life projects by building an employee payroll and a gradebook in Excel, using formulas for pay, hours, min, max, and average, overtime, percentages, and conditional formatting.

Explore the basics of Microsoft Excel, including the anatomy of a spreadsheet, workbooks, sheets, cells, ranges, and the ribbon, to start working efficiently.

Master basic Excel data entry by inputting data, adjusting column width, and navigating with arrow keys, tab, and enter; double-click to edit and use the formula bar.

Learn basic Excel formatting to improve readability by adjusting fonts, font sizes, borders, and cell styles; apply wrap text, merge and center, and switch to currency or accounting formats.

Master basic Excel formulas, print preview, and formatting; insert columns, apply borders, color cells, convert values to percent, and copy formulas by dragging the fill handle for automatic updates.

Learn how formulas and functions differ, and use basic Excel functions like sum, average, min, max, and count with autosum and range concepts.

Learn to create and customize charts in Excel by selecting data, choosing a chart type, editing chart titles and axis labels, and preparing for print preview.

Explore advanced Excel functions like vlookup, hlookup, and index match to pull data between tables, and master if logic for conditional analysis.

Learn to boost data integrity in Excel with data validation rules, prevent future dates, numeric and length constraints, and apply conditional formatting to highlight duplicates, above-average scores, and outliers.

Master pivot tables in Excel to quickly summarize and analyze large data sets. Learn to drag fields, build rows and columns, apply filters, and create pivot charts for clear insights.

Master data management in Excel by applying filtering and sorting techniques to organize large datasets, perform multi-level sorting, apply criteria and advanced filters for targeted analysis.

Build dynamic and interactive charts in Excel with a year slider, linking data via index formulas, and a dynamic chart title for clear, engaging data visualization.

Master advanced Excel charting with line graphs, trend lines, forecasting options, and sparklines to create dynamic, compact data visualizations.

Explore advanced data visualization in Excel, using data bars, heat maps, color scales, and icon sets to transform data into interactive visuals; build dynamic dashboards with pivot charts and slicers.

Master macros and Visual Basic for Applications in Excel to automate repetitive formatting and data tasks, and customize workflows with the VBA editor.

Record macros and write VBA to automate repetitive Excel tasks and streamline workflows; learn to enforce numerical input via input boxes and handle errors with debugging and message boxes.

Master conditional logic and nested formulas in Excel using if statements and logical functions to assign grades based on student marks through complex nested formulas.

Master Excel's analysis Toolpak to perform descriptive statistics and regression. Output can appear on a worksheet; set Y and X ranges, ensure adjacent variables, and interpret residuals and confidence levels.

Explore what-if analysis and scenario planning in excel using scenario manager and goal seek to forecast december sales, adjust changing cells, and optimize the grand total.

Explore Power Query and Power Pivot in Excel to import, clean, transform, and load data from multiple sources, build data models, and perform advanced analysis.

learn to install and use power pivot in excel, build data models with relationships, write dax measures, and create pivot tables and charts for advanced data analysis.

Learn to share and collaborate on Excel workbooks in real time using sheet view, co-authoring, comments, and show changes across desktop and web with OneDrive or SharePoint.

Protect Excel workbooks and worksheets with passwords and encryption, learn to set read-only modes, lock cells, and save or print as PDF to secure data.

Explore customizing Excel with add-ins and advanced settings, install tools like QR for office, Wikipedia, Bing Maps, a web video player, date pickers, and colorizers to boost productivity.

Apply advanced Excel techniques to real-world business data by cleaning datasets, removing duplicates, organizing with age brackets, and building dynamic dashboards with filters and charts for data-driven insights.

Learn to present findings with advanced Excel features by building professional reports and dashboards using pivot tables, charts, slicers, and report connections to visualize average income by gender, commute distance.

Plan and execute an Excel project with data cleaning, analysis, and visualization, create a pivot table of expenses and a city-filtered dashboard, and present for peer feedback.

Present your Excel analyses with a structured presentation, design principles, and clear communication. Gather instructor or peer feedback to refine slides and highlight key findings.

Discover how data driven decision making uses Excel to manipulate, analyze, and visualize data for business analytics, from basic functions to macros and scenario analysis.

Master data cleaning in Excel by addressing duplicates, inconsistencies, and missing data; standardize data with trim, proper, and case functions, and use find and replace.

Master data transformation techniques in spreadsheets by applying text to columns, splitting departments and cities, and cleaning data with missing value handling, deduplication, and error-proofing for analysis.

Learn to use Excel's data analysis toolpak for descriptive statistics, computing central tendency, dispersion, quartiles, and percentiles on GDP, population, and mortality data, with visualization planned for next module.

Explore skewness and kurtosis to assess data distribution, and build effective visualizations with histograms, bar graphs, and line charts in Google Sheets or Excel.

Explore exploratory data analysis in Excel to uncover patterns, outliers, and summary statistics in a sample HR dataset using the data analysis toolpak.

Use pivot tables to support exploratory data analysis by calculating the average salary per department and creating pivot charts for clear visualization.

Learn hypothesis testing in Excel with t tests and z tests to compare means, define H0 and Ha, set alpha at 0.05, and interpret p-values and rejection regions.

Explore time series analysis in Excel, identifying trend, seasonality, and noise in quarterly sales data. Learn how to visualize data with a line chart and prepare for forecasting techniques.

Learn to forecast time series in Excel by smoothing data with a centered moving average, extracting seasonal indices, deseasonalizing data, and using regression to project future trends and quarterly forecasts.

Explore scenario analysis and sensitivity modeling in Excel using scenario manager and goal seek to compare baselines, optimistic and worst cases, and chase a target grand total.

Master sensitivity analysis and goal seeking in spreadsheet modeling using data tables to optimize operating profit by varying price and units sold, with what-if analysis and scenario analysis.

Explore Power Query in Excel to import, transform, and load data from multiple sources, using the Query Editor to clean data, split columns, promote headers, and automate refresh.

Explore the data analysis toolpak in Excel to perform advanced statistical tools, including anova single factor, chi-square tests, descriptive statistics, correlation, histogram, and regression.

Apply pivot tables in Excel to analyze sales by zone, city, division, and distributor; identify top contributors and price range impact, then build an executive dashboard.

Create a dynamic sales dashboard in Google Sheets or Excel with pivot tables and donut charts for total sales per channel, using slicers and a timeline tied to invoice date.

Apply pivot tables to analyze sales data by zone, city, division, and distributors; identify top contributors and price range impact, then build an interactive dashboard with slicers and timelines.

Explore ethical handling of business data, emphasizing privacy, security, integrity, and compliance, while fostering transparency, consent, governance, and trust in data-driven analysis.

Explore emerging trends in business analytics, including AI and ML, predictive analytics, real-time insights, and customer personalization, and learn to adopt data-driven culture while upskilling teams for ethical, privacy-conscious analytics.

Apply your data cleaning, analysis, and visualization skills to a capstone coffee sales dashboard using Xlookup, pivot tables, and slicers to reveal top customers, sales by country, and monthly trends.

discover how ChatGPT enhances data analysis in Excel, guiding you from basic concepts like cells and formulas to Power Query, VBA automation, and sample data generation for practice.

Explore using ChatGPT with Excel to learn Vlookup, Power Query, and Power Pivot, and apply a three-step prompt pattern: introduce yourself, describe your data, and ask a question.

Learn to integrate chatgpt with excel using simple prompts without prompt engineering, create custom lists and use flash fill patterns, and paste chatgpt results as tables for quick insight.

Explore how to use ChatGPT prompts with Excel to build and verify formulas and functions (index match) and apply conditional formatting, enabling lookup of student numbers by course and section.

Explore how to use chatgpt to master power query in excel, including web data import, loading vs transforming data, and editing m code to transform dates.

Learn data modeling in Excel with ChatGPT: organize data into tables, naming ranges, relationships, and pivot tables; convert pivot values from average to sum using stepwise prompts.

Learn to automate Excel with VBA using ChatGPT, from generating basic macro code to debugging runtime errors in the Visual Basic Editor.

Create and tailor dummy data sets in Excel using ChatGPT to generate CSV output, then split with text-to-columns, build at least 100 records for practice dashboards and data analysis.

Use advanced conditional formatting in Excel with ChatGPT to highlight whole records by Po date, enabling faster budgeting and planning.