Name: Excel and PowerPoint 2021
Brand: LIBRAIRIE COREENNE
SKU: 114694
Price: 41.00 EUR
Availability: InStock

Excel and PowerPoint 2021

€41,00

Excel and PowerPoint 2021

Description

Book Introduction

Core features of Excel and PowerPoint
Learn properly and apply it in practice!

"Excel and PowerPoint 2021" is aimed at readers who want to learn the core functions of Microsoft Office programs.
Part 1 covers everything from basic number entry methods to data analysis features in Excel spreadsheets, while Part 2 introduces various audiovisual effects that enhance the communication power of PowerPoint documents.
By following the practical examples provided in this book—basic examples, comprehensive examples, and practice problems—you can develop the ability to quickly select the most appropriate function for office work.

※ This book was developed as a textbook for university lectures, so it does not provide answers to practice problems.

You can preview some of the book's contents.
Preview

index

Part 01 Excel

Chapter 01 Excel Overview and Basic Functions
01 Introducing Excel
02 Getting Started with Excel
03 Handling Worksheets
04 Handling Cells
05 Data Entry and Autofill
Comprehensive example
Practice problems

Chapter 02 Formulas and Display Formats
01 Entering a formula
02 Creating a formula with the AutoSum tool
03 Understanding Relative and Absolute References
04 Defining a Name
05 Using the display format
Comprehensive example
Practice problems

Chapter 03 Basic Functions
01 Understanding the Basics of Functions
02 Using Mathematical and Statistical Functions
03 Using text functions and date/time functions
04 Using logical functions
Comprehensive example
Practice problems

Chapter 04 Advanced Functions
01 Finding values that meet the conditions
02 Using the Find and Reference Functions
03 Using financial functions
Comprehensive example
Practice problems

Chapter 05 Data Management
01 Managing Data
02 Sorting data
03 Using filters
04 Finding partial sums
05 Specifying Conditional Formatting
Comprehensive example
Practice problems

Chapter 06 Data Analysis
01 Using Table
02 Creating a Pivot Table
03 Using Virtual Analysis
Comprehensive example
Practice problems

Chapter 07 Chart
01 Creating a chart
02 Editing the chart
03 Creating Sparklines
Comprehensive example
Practice problems

PART 02 PowerPoint

Chapter 08 PowerPoint Basic Functions
01 Overview of the presentation process
02 Getting Started with PowerPoint
03 Handling PowerPoint Documents
Comprehensive example
Practice problems

Chapter 09 Text Utilization
01 Handling Text
02 Using Word Art
Comprehensive example
Practice problems

Chapter 10 Shapes and SmartArt
01 Using shapes and icons
02 Using Smart Art
Comprehensive example
Practice problems

Chapter 11 Tables and Charts
01 Create a table
02 Using the Table Tool
03 Creating a Chart
04 Setting up the chart design
Comprehensive example
Practice problems

Chapter 12 Multimedia
01 Inserting and Editing Pictures
02 Using pictures
03 Using Media
Comprehensive example
Practice problems

Chapter 13 Animations and Slideshows
01 Using animation
02 Using Links
03 Using screen transitions
04 Running the slide show
Comprehensive example
Practice problems

Chapter 14 Slide Master and Print Settings
01 Using the Slide Master
02 Using the Flyer Master
03 Setting print options
Comprehensive example
Practice problems