Microsoft has released its latest stand-alone Excel version, which
opens up many of the features and functionalities that are available
only in Excel 365 through a subscription.
In the first section, we study some basics about how to use Excel 2021
and become familiar with what’s new in it. We will first navigate
the Excel 2021 interface and create our first Excel spreadsheet. You
will learn some useful keyboard shortcuts to increase productivity,
learn how to effectively apply formatting to cells and use conditional
formatting, learn how to use basic and intermediate Excel formulas and
functions, and more.
Then, in the second section, you will learn how to create
intermediate-level formulas, prepare data for analysis using
PivotTables and Pivot Charts, make use of WhatIf analysis tools, learn
how to use validation rules to control data input, and explore the
fundamentals of spreadsheet design.
In the final section, we will build on the skills learned in the
beginner and intermediate sections and fast-track our way to being an
Excel power user. This section covers the latest updates from
Microsoft, including the LET and LAMBDA functions, which allow us to
create our own variables and even Excel functions.
By the end of this course, you will be able to use Excel skills
confidently.
All the course demo files, and exercise files are available at:
https://github.com/PacktPublishing/Microsoft-Excel-2021-365---Beginner-to-Advanced
Les mer
Produktdetaljer
ISBN
9781804612262
Publisert
2023
Utgave
1. utgave
Utgiver
Packt Publishing
Språk
Product language
Engelsk
Format
Product format
Digital bok
Forfatter