Analyzing Data in Excel Bootcamp: Analyzing Data in Excel Bootcamp
Analyzing Data in Excel:
- 4 Courses | 7h 5m 1s
- 7 Books | 38h 31m
- 35 Courses | 31h 58m 34s
In this bootcamp, using their own licensed version of Excel, learners will discover why this tool is one of the most-used by professionals and analysts in today's workplace. After an initial introduction to Excel's basic features, learners will, clean, explore, and manipulate data. By the end of this program, students will be able to outline use cases for Excel, wrangle data, build static and interactive data visualizations, and solve optimization-related problems.
COURSES INCLUDED
Analyzing Data in Excel Bootcamp 2023: Session 1 Replay (December 2023)
This is a recorded Replay of the Analyzing Data in Excel Bootcamp session that ran on Dec 4, 2023 11:00 AM - 2:00 PM ET.
4 videos |
1h 38m
Badge
Analyzing Data in Excel Bootcamp December 2023: Session 2 Replay
This is a recorded Replay of the Analyzing Data in Excel Bootcamp session that ran on Dec 5, 2023 11:00 AM - 2:00 PM ET.
3 videos |
1h 37m
Badge
Analyzing Data in Excel Bootcamp 2023: Session 3 Replay (December 2023)
This is a recorded Replay of the Analyzing Data in Excel Bootcamp session that ran on Dec 6, 2023 11:00 AM - 2:00 PM ET.
3 videos |
1h 47m
Badge
Analyzing Data in Excel Bootcamp 2023: Session 4 Replay (December 2023)
This is a recorded Replay of the Analyzing Data in Excel Bootcamp session that ran on Dec 7, 2023 11:00 AM - 2:00 PM ET.
3 videos |
2h 1m
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Adding & arranging data in Excel 365
In Excel 365, it is easy to add new content to workbooks and change how values are arranged. This course demonstrates how to add and manage content in your worksheets, including how to insert columns and rows, and data into cells. You will begin by learning how to fill cells using the AutoFill feature; as well as how to insert columns and rows into a worksheet. Next, you will observe how to paste copied data using the Paste Special tools; how to align values in cells; as well as how to freeze rows or columns to avoid unnecessary scrolling. Finally, you'll explore how to select cells and ranges; and how to merge content across various cells or unmerge if necessary. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
13 videos |
44m
Assessment
Badge
Applying custom formatting in Excel 365
To customize data even further, you can create your own conditional formatting in Excel 365. In this course, you will observe how to create and use conditional formatting, work with intelligent data types, and convert values from the default base-10 number system into binary and hexadecimal. To start, you will discover how to apply advanced conditional custom formatting to data values and create conditional formatting rules to enhance how your data values display. You will also delve into managing conditional formatting rules and using intelligent data types that can be mapped automatically to existing values in a data range, thereby enriching your worksheets and reports. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
6 videos |
19m
Assessment
Badge
Collaborating effectively in Excel 365
With Excel 365's sharing and collaboration tools, working as a team has never been easier. To facilitate efficient collaboration, see how to keep track of workbook versions, track changes, and comments. Excel 365 also enables one to easily share workbooks via email or upload them to OneDrive and SharePoint. In this course, you will explore how to collaborate with other users on an Excel workbook; how to edit a workbook's properties; track any changes made to your workbook data; and learn how to manage a workbook's version history. You will also discover how to protect Excel workbooks from unwanted edits, and manage a workbook's comments. Furthermore, you will discover how to manage your Excel 365 account and the services you have connected to it and how to save your workbooks to OneDrive. Explore how to use the integrated email function to send your Excel workbook to other users via email. You will discover how to share workbooks via a link. And manage link access and permissions, so you can change link editing permissions to be more restrictive or open. Finally, you can choose the format for the workbook, send it as a PDF, and view a workbook's statistics. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
14 videos |
49m
Assessment
Badge
Complete Guide to Excel 365: Getting Started
Microsoft Excel has many potential applications, offering extensive, customizable features to suit virtually all tasks and workflows. At first, Excel can be intimidating, but the benefits of knowing how to eke out every bit of this tool's productivity far outweigh the slight learning curve. In this course, you'll learn how to set up Excel, identify and choose an Excel template, locate and recognize the purpose of each primary menu item group in the Quick Access Toolbar, and apply customization to this toolbar. Next, you'll execute basic cell operations, such as copy-pasting data and inserting and deleting rows and columns. You'll and apply a range of cell formatting options, such as alignment, font, and currency formats. Finally, you'll import delimited and fixed-width data and work with Excel's Flash Fill functionality.
10 videos |
1h 13m
Assessment
Badge
Complete Guide to Excel 365: Linking, Printing, & Protecting Workbooks
Some of the core benefits of working with data in Excel include connecting data combined from different workbooks and controlling how it's presented and who has access to it. In this course, you'll begin by linking data in different Excel workbooks, before editing, testing, and cleanly breaking those links. Next, you'll work with an often-ignored but powerful aspect of Excel - precise control over how a workbook is laid out and printed. You'll configure headers, footers, page numbers, background, images, and the views used to print only parts of a workbook. Finally, you'll use Excel's protection features for individual cells and cell ranges, worksheets, and workbooks. This includes setting roles and passwords, working with read-only workbooks, and utilizing editable cell ranges.
11 videos |
1h 20m
Assessment
Badge
Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
In this course, you'll recognize how relational data - data with schema and clearly-defined column names - can be imported into Excel as a set of data tables. This data can be sliced-and-diced using classic Excel pivot tables or the more robust PowerPivot add-in. Now a standard part of Excel, this add-in vastly expands the tool's capabilities with some serious entity-relationship modeling and big data analysis. Excel has powerful capabilities to detect relationships across models and infer foreign key relationships between parent and child tables. Creating, visualizing, and modeling such relationships is an important aspect of working with relational databases. As you'll recognize, you can now accomplish much of that from within Excel using PowerPivot. In this course, you'll use some classic yet powerful worksheet functions that have ensured Excel's use in Wall Street for decades. These functions can be used to compute the yield of a bond and the present and future values of a set of cash flows. They can also be used to perform complex operations on settlement dates and compounding rates of financial instruments.
9 videos |
1h 14m
Assessment
Badge
Complete Guide to Excel 365: Using Formatting, Styles, & Themes
Conditional formatting is a significant and powerful feature in Excel. In this course, you'll begin by using some of the more straightforward types of conditional formattings, such as those based on specific values or ranking. You'll then use the more visually appealing types of conditional formatting, such as data bars, icon sets, and color scales, before advancing to more complex custom formatting rules using worksheet functions and a cell's row and column information. Additionally, you'll distinguish the purpose of notes versus comments and how to work with them both. Finally, you'll learn to use built-in styles and themes, create custom styles and themes and export them for use in other Office 365 products, such as PowerPoint, to apply a uniform look-and-feel to all your spreadsheets and presentations.
11 videos |
1h 17m
Assessment
Badge
Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Excel is not only used for aggregating and analyzing data, but also for data cleansing. There are several data cleaning, validation, and checking techniques available, some of which are among Excel's most well-known and widely-used functions. In this course, you'll start by using various string and data manipulation functions to clean data and fill in missing values. Next, you'll perform simple data validation based on specific numeric thresholds and text lengths, before moving on to validation using lists. You'll then combine data validation to implement a formidable, dynamic data validation mechanism using named ranges and the INDIRECT formula. Finally, you'll use one-dimensional lookups - the classic HLOOKUP and VLOOKUP worksheet functions - as well as more complex, two-dimensional lookups utilizing a combination of INDEX and MATCH.
13 videos |
1h 29m
Assessment
Badge
Complete Guide to Excel 365: What-If Analysis, Solver, & Analysis ToolPak
Excel's Scenario Manager allows you to create named scenarios with different values for key variables. These scenarios can be quickly examined and summarized using the What-If Analysis tool. In this course, you'll use GoalSeek and Solver, both of which are mathematical tools. Goal Seek comes in handy when solving quadratic, cubic, or other equations. Solver is much more powerful and allows complex constrained optimization problems to be easily defined and addressed. As you'll recognize, Solver's interface, used for specifying objective functions and constraints, is intuitive and easy to use. Next, you'll use several heavy-duty statistical techniques in Analysis ToolPak. These range from the creation of correlation and covariance matrices, hypothesis testing, and F-test and T-test interpretations to ANOVA, random and periodic sampling, and the construction and analysis of linear regression models.
12 videos |
1h 35m
Assessment
Badge
Complete Guide to Excel 365: Working With Charts & Sparklines
One of the primary purposes of using Excel is to analyze and present data in a focused, accessible, and accurate way. A great way to do this is with charts and sparklines. In this course, you'll create basic chart types, such as line, bar, and pie charts, as well as more advanced charts, like treemaps and sunburst charts. In doing this, you'll work with the different aspects of Excel's chart customization capabilities, from chart element transparency to the orientation and exploding out of slices in a pie chart. Next, you'll advance to use more statistically-oriented chart types, including histograms, scatter plots, and box-and-whisker plots. Finally, you'll learn to create, customize, and work with Excel's sparklines, which are lightweight visualizations usually contained within a single cell.
11 videos |
1h 16m
Assessment
Badge
Formatting cells and ranges in Excel 365
Excel 365 contains several features to aid in data formatting and manipulation. In this course, you will explore various ways to format your data by type, which serves as a way of classifying the data. Learn how to create drop-down menus, fill cells using the Flash Fill feature, and how to create an automatic data series. Next, you will discover how to create an automatic data series using the advanced Fill Series options and how to format data, including options to configure its size or apply font effects such as bold, italic, and underline. Then you'll also see how to apply cell styles; how to format cells with the Format Painter tool; how to create customized number formats; how to apply custom cell formats; and how to clear all formatting from cells. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
42m
Assessment
Badge
Finding and grouping data in Excel 365
Excel 365 includes several methods for locating and arranging data entries into groupings. In this course, you will learn how to use the Find and Replace tools when working with specific-data, and use the Group and Outline tools to manipulate data. To start, you will explore how to jump to specific locations in a worksheet and find items with basic search queries using the Find tools. Then you will learn how to use the advanced Find tools to customize and refine search queries, including how to use the Find and Replace tools when working specifically with formulas. Finally, you will explore how to replace cell contents and formats using the Replace tools, observe how to group rows and columns in a worksheet, control their display, and use the Group tools to create outlines. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
7 videos |
23m
Assessment
Badge
Finding and analyzing data with formulas in Excel 365
A wide variety of Excel 365 tools can be used to retrieve, return, and calculate data. In this course, you will explore how to use formulas to retrieve specific types of information as well as how to automate and simplify calculations with lookup tools. Key concepts covered include how to automate formulas using the Fill Down tool, how to use formulas to extract date values, and perform calculations by using dates. Next, you will learn how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to find a value in a double-entry table; and how to create automatic reports summarizing a data table with the SUMPRODUCT formula. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
36m
Assessment
Badge
Filtering and sorting data in Excel 365
Excel 365 includes various sort and filtering tools, which you can use to analyze the data in a worksheet. You can use these tools to organize and choose what values are shown in a range. The key concepts in this course include how to use filter tools and how to remove duplicate values in a data range. See how to use column filters to filter data and apply multiple filters to values in a worksheet. Create filter arguments using text and number data types to show values that meet defined filter criteria. Finally, you will learn how to sort and filter data according to their background fill color; sort data in a worksheet according to a specific data type; customize the sort options; apply multiple criteria and sort levels, and create and use custom sort lists. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
34m
Assessment
Badge
Customizing text & number formats in Excel 365
To configure how your data displays, you can use the various built-in formatting options in Excel 365, or create your own. In this course, you will learn how to use formulas to separate data entries into various cells as well as to modify the case of your text. In addition, you will find out how to create custom formats for text and date or time values - including how to create custom color formatting for data entries. You will explore how to create randomized values, rank values; and round numbers up or down. Finally, you will explore how to use formulas to make substitutions or replacements for values. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
41m
Assessment
Badge
Customizing charts in Excel 365
You can analyze and present your Excel 365 data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to customize individual chart elements, including customizing chart axes, moving or combining two types of chart, and customizing the chart's titles, labels, and axes. You will also explore how to insert and customize trendlines that can be used for data ranges, movements, or correlations; as well as how to add and modify Sparklines, which are at-a-glance visualizations. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
9 videos |
31m
Assessment
Badge
Creating PivotTables and PivotCharts in Excel 365
Excel 365 includes powerful tools to summarize data. In this course, you will learn how to create, edit, and format PivotTables and PivotCharts; and how to use slicers. Key concepts covered in this course include how to use a PivotTable to find trends in data, and how to add extra levels of detail and multiple value fields in a single table. Because a PivotTable is highly customizable, you will observe how to configure and customize its display and control settings. Next, you will examine how to use label and value filters to analyze data, how to use a slicer to filter data, and how to customize the appearance of a slicer. Finally, you will explore how to use data from a PivotTable to create a PivotChart and then customize and format the PivotChart. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
37m
Assessment
Badge
Creating advanced charts in Excel 365
Analyze and present your Excel data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to edit a chart's data series and customize the chart's titles, labels, and axes. You will also see how to save a chart type or chart formatting choice as a template to make it easier to use and include in future spreadsheets. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
29m
Assessment
Badge
Manipulating PivotTable data in Excel 365
Once you have created your Excel PivotTables, you will need to know how to manage and work with the data contained in them. In this course, you will learn how to analyze, calculate, compare, and work with Excel PivotTables as well as use the timeline. Key concepts covered in this course include how to edit the source data and field setup in a PivotTable; how to organize data logically by creating data groups within a PivotTable; and how to incorporate data from external sources to analyze in an Excel 365 PivotTable. You will also learn how to use sort tools to change the display of data; use filter tools to show and hide data, and work with values for comparison calculations. Finally, you will discover how to troubleshoot common PivotTable issues in Excel 365. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
39m
Assessment
Badge
Performing data calculations using formulas in Excel 365
The power of Excel 365 lies in the support given when using formulas with your data, which automatically update when the underlying data changes to ensure your calculations are always up to date. In this course, you will observe how to perform simple and more advanced calculations with formulas, including the use of built-in formulas such as SUM and COUNT, as well as working with formulas that include IFS, SWITCH, MAXIFS, MINIFS, COUNTA, OFFSET, COUNTIFS, MOD, QUOTIENT, and AVERAGEIFS. You will start by discovering how to perform simple calculations within an individual cell; then explore how to use formulas to create automated cumulative totals in a table and insert subtotals. Following this, you will learn how to use different formulas to count cells in a range. Learn how to perform logical operations such as IFS and SWITCH, MAXIFS, and MINIFS, and keep your data up to date with COUNTA and OFFSET formulas. Finally, you will explore how to configure default formula options, find data with multiple conditions, factorize the results of a division, and calculate average values under different criteria. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
10 videos |
31m
Assessment
Badge
Solving data problems in Excel 365
Discover how to go further with your Excel 365 content by understanding the potential for formula errors. See how to use error checking and formula auditing tools, use the Goal Seek tool to let Excel 365 update variables for a formula to meet a specific outcome, and use the Watch Window tool to monitor data entries stored in different locations. Key concepts in this course include how to identify formula errors and understand the wide range of error messages. You will also learn how to check for and evaluate formulas in a workbook and how to use the Goal Seek tool to change constraints and variables to optimize your data values accordingly. Finally, you will explore how to use the Watch Window tool to monitor specific data entries, even from other workbooks. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
6 videos |
16m
Assessment
Badge
Ten common tools in Excel 365
To make the most out of working in Excel 365, you need to know your way around the interface as well as understand some of its frequently-used features. This course will explore how to use the Zoom tools, make selections in your worksheet, and use the various view modes. You will also explore how to navigate between worksheets. In addition, you'll learn how to use the spellcheck tool, and learn more about the AutoCorrect and Smart Lookup features. Finally, you will explore how to translate text and create an accessible document. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
37m
Assessment
Badge
Using macros in Excel 365
If you are using your Excel worksheet to input data, you can create forms to quickly fill out your worksheets. With the VBA editor, you can insert, edit, and customize your forms to make inputting data easier for your users. Excel 365 also makes it possible to use macros within formulas to format text, perform calculations, and even export charts to easily share or present the data to others. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
9 videos |
31m
Assessment
Badge
Using visual elements in Excel 365
An Excel 365 worksheet can contain more than just numbers and text. In this course, you will discover how to make your worksheets more visually appealing using hyperlinks, images, screenshots, shapes, icons, special characters, as well as colors and themes. Start by learning how to insert an image or photograph, which can be used to illustrate your data, and then learn how to insert a screenshot. Discover how to edit an image once it has been inserted into your Excel spreadsheet. You will then explore how to adjust an image's brightness, contrast, saturation levels, apply a variety of artistic effects and even add a border. You can also create diagrams using shapes and insert icons to help illustrate a worksheet. You will explore the different types of links and hyperlinks you can insert into your document. You will learn how to insert special characters into a cell and see how to use colors and themes to help data stand out and make a table easier to read. Also, you will discover how to create and edit clean, professional-looking titles with WordArt. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
12 videos |
39m
Assessment
Badge
Working with tables in Excel 365
Tables are a useful tool for quickly managing, analyzing, and manipulating data as a range in Excel 365. In this course, you will discover how you can easily create tables from a data range; insert borders, and change the appearance and formatting of a table. You will start by learning how to insert a table, and convert a data range into a table. In addition, you'll learn how to transpose a data range, which means inverting the columns and rows. You will see that tables are highly customizable, as you learn how to use the formatting tools and styles to change the appearance of a table. Also, see how to use the Border tool to make the data in your table stand out more. You will learn how to use slicers to filter and manipulate data in a table; and how to resize and format a slicer tile. Finally, you will explore how to add subtotals to your data tables and how to manipulate the table date in other ways. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos |
36m
Assessment
Badge
Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
Once you grasp how to work with the scope of standard Excel chart types, you can expand into more complex visualizations. For example, you can use box-and-whisker plots to convey a wealth of information about the statistical distribution of a variable and identify outliers in a data series. You can use sunburst charts to visualize hierarchical data with differing levels of detail, waterfall charts to show the cumulative effect of positive and negative values, and Gantt charts to illustrate progress toward a goal involving multiple parallel tasks. Additionally, you can avail of band charts to quickly eyeball the trend in a line chart, scatter plots to uncover the relationship between two variables, and waffle charts to visualize progress towards KPIs. In this course, you'll create all of these charts either via Excel's built-in tools or by building them manually using nifty workarounds.
11 videos |
1h 39m
Assessment
Badge
Excel Visualization: Building Column Charts, Bar Charts, & Histograms
Data visualizations in Excel reveal the insights uncovered by your data in easy-to-consume representations. You can identify categorical values, recognize how parts sum up to a whole, see percentages rather than absolute values, discretize continuous variables, and approximate the probability density function of variables. In this course, you'll build charts to uncover all of this information. You'll start by working with column and bar charts. You'll then create and differentiate between clustered and stacked column charts. You'll move on to formatting and customizing bar and column charts before working with 2D and 3D chart types and customizing them in various ways. Lastly, you'll work with histograms, examining how they work, what they're used for, and how to customize them to your needs.
10 videos |
1h 17m
Assessment
Badge
Excel Visualization: Getting Started with Excel for Data Visualization
Excel charts can be used for a myriad of data visualizations, including categorical data and continuous data, like time-series data. In this course, you'll learn how to bring data into Excel and build and customize various charts. You'll start by importing data from an existing workbook into a new spreadsheet. You'll then import data from CSV and JSON file formats and Microsoft Access database files. Next, you'll use the Power Query editor to perform various operations. Moving on, you'll create column and clustered column charts and perform various formatting operations on the clustered column chart, such as adding data labels, error bars, axis titles, and trendlines. Lastly, you'll create a simple line chart, formatting various aspects, such as the line, background, title, legend, axes, and position of charts relative to each other.
9 videos |
1h 11m
Assessment
Badge
Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
Data visualization options in Excel are vast. You should choose your visualization type based on the data and what you want to show from it. For example, using High-Low-Close and Open-High-Low-Close charts (also called candlestick charts), you can summarize several stock performance aspects. Excel also lets you build radar charts - great for visualizing multivariate ordinal data, such as ratings or scores, to spot strengths or spikes. In this course, you'll not only learn how to build and customize the charts mentioned, but you'll also create treemaps to visualize hierarchical data and pie charts to display parts of a whole. You'll then generate pie-of-pie and bar-of-pie charts, both of which use a secondary visualization to complement a pie chart. Finally, you'll create donut charts to visualize composition using multiple concentric donut rings to represent points in time.
10 videos |
1h 18m
Assessment
Badge
Excel Visualization: Visualizing Data Using Line Charts & Area Charts
Line charts are possibly the most common type of visualization for time-series data, enabling you to see time trends at a glance. These can be augmented with trendlines, used to visualize time trends in data. Stacked area charts are a powerful type of visualization, combining information about trends over time with information about composition and parts of a whole. In this course, you'll learn how to create and customize all of the visualization types above. You'll begin by exploring the purpose of line charts before moving on to formatting and customizing them. You'll then practice using trendlines to evaluate different regression models on data in a line chart. You'll also customize and format these trendlines. Following this, you'll work with area charts and stacked area charts, examining, in detail, the several types of stacked area charts in Excel and customizing their appearance.
13 videos |
1h 38m
Assessment
Badge
Analyzing & Manipulating Data Entries in Excel for the Web
Excel for the Web includes a wide variety of options for locating, displaying, and analyzing data entries. To start working with the data in a worksheet, use the sorting and filtering options for choosing what is the data displayed. You can also use the grouping tools to create groups and subgroups within a worksheet. In this course learn how to use the Find and Replace tools to quickly locate and change data values in a data range or worksheet. Another option to easily insert values in a cell is using dropdown menus. The power of Excel for the Web is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM, CHOOSE, and INDEX to quickly get totals or reference data and values. Also discover how to insert cell references to use data across multiple worksheets.
10 videos |
37m
Assessment
Badge
Analyzing Data with Tables & Charts in Excel for the Web
Analyze and present your data in a visually attractive manner in Excel for the Web. Learn how to prepare your data to insert your charts. Discover also how to change the appearance of your charts by changing the chart type or formatting different elements as titles, legends, and axis. Excel for the Web includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables. You can also sort and filter your data with labels, values, or even slicers. Even if Excel for the Web does not have an option to insert PivotCharts, you will see how to insert one from the Recommended Charts options and the Ideas tool.
9 videos |
39m
Assessment
Badge
Excel with Python: Constructing Data Visualizations
This course explores how to use Python's openpyxl library to build visualizations such as line, bar, and bubble charts in Excel. In its 11 videos, you will examine how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation, before learning how to create line and bar charts in Excel, and learning how to use Python to control several properties of those charts, including line weights and style, data for the reference axes, formatting, and the position of ticks on those axes. Learners will observe how to construct data visualizations in Excel using Python. This course then demonstrates common types of visualizations that are supported in Excel, and how to programmatically replicate those visualizations from within Python. Finally, learners will observe demonstrations of the use of bubble charts to display three dimensions on a two-dimensional chart as well as stock charts to represent the opening, high, low, and closing prices of stocks in a single data visualization for the financial markets.
11 videos |
1h
Assessment
Badge
Excel with Python: Performing Advanced Operations
Learners can explore complex operations in Microsoft Excel workbooks, including the use of conditional formatting, named ranges, and merged cells, in this 17-video course. Microsoft Excel is the best prototyping tool for data analysis, an interactive functional programming environment, and a forerunner of Python. Begin by exploring how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation. Then observe the formatting, alignment, and other aesthetics in Python. You will work with the Python library openpyxl; examine data analysis, the use of pivot tables, and the locking of cell references by using the $ operator; and learn how to perform complex data analysis operations using pivot tables, sorting and filtering, and formulae with both absolute and relative cell references to enable efficient copy paste. You will learn to control the workbook appearance using conditional formatting and styles. Finally, this course demonstrates how to leverage the Python Pandas library to read a spreadsheet, to group and analyze data.
17 videos |
1h 29m
Assessment
Badge
Excel with Python: Working with Excel Spreadsheets from Python
This 13-video course explores how Microsoft Excel spreadsheets can be created, opened, and modified programmatically from within Python. Learners will review the Microsoft Excel object model, the attributes of the worksheet cell object which can be leveraged to create and modify workbooks programmatically. First, you will review VBA (Visual Basic for Applications) technology, before exploring how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation. Then you will learn how to use openpyxl (open pixel library) to manipulate Excel's object model programmatically from within Python. Continue by learning how to write spreadsheets by using openpyxl, and examining how existing Excel workbooks can be opened, as well as how new spreadsheet files can be created, and written out to disk. Finally, you will learn how Python iterators and indexing can be used to access and manipulate individual cells, ranges consisting of many cells, as well as entire rows and columns.
13 videos |
1h 16m
Assessment
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, DashboardsNo matter what your professional or academic status is, if you often engage in data analysis, summary creation, and report writing, this book is for you.
2h 42m
By Dr. Isaac Gottlieb
Book
Mastering Advanced Excel - With ChatGPT Integration: Learn Formulas and Functions, Advance Pivot Tables, Macros, VBA Coding, ChatGPT Integration with ExercisesThis book is a comprehensive guide that explores the advanced features of Microsoft Excel.
2h 26m
By Ritu Arora
Book
Make Your Data Speak: Creating Actionable Data through Excel For Non-Technical ProfessionalsThe information in this book is presented in an accessible and understandable way for everyone, regardless of the level of technical skills and proficiency in MS Excel.
2h 15m
By Alex Kolokolov
Book
Excel 2021 / Microsoft 365 Programming By ExampleUpdated for Excel 2021 and based on the bestselling editions from previous versions, Excel 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface.
14h 38m
By Julitta Korol
Book
Microsoft Excel Functions and Formulas, Sixth Edition: With Excel 2021 / Microsoft 365In this completely updated edition covering Excel 2021, Microsoft 365, and previous versions, Microsoft Excel Functions & Formulas Sixth Edition demonstrates the secrets of Excel through the use of practical anduseful examples in a quick reference format.
4h 8m
By Bernd Held, Brian Moriarty, Theodor Richardson
Book
Advanced Excel Formulas: Unleashing Brilliance with Excel FormulasThe book covers all the most popular functions in Excel including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT and so much more. You will learn how to return multiple results with a single formula.
7h 8m
By Alan Murray
Book
Microsoft Excel Professional 2021 Guide: A Complete Excel Reference, Loads of Formulas and Functions, Shortcuts, and Numerous Screenshots to Become an Excel ExpertStudents, recent graduates, and professionals, such as Accountants, Retail Managers, Sales Executives, Business Analysts, Administrative Assistants, and HR Professionals who want to boost their day-to-day data management and analytical skills, will find this book to be an invaluable resource.
5h 14m
By CA Manmeet Singh Mehta
SHOW MORE
FREE ACCESS
