, EXCEL 2023
CRASH COURSE
Master Excel 2023 With This Complete
Crash Course In 7 Days
CARTY BINN
,Copyright © 2023 CARTY BINN
All Rights Reserved
This book or parts thereof may not be reproduced in
any form, stored in any retrieval system, or
transmitted in any form by any means—electronic,
mechanical, photocopy, recording, or otherwise—
without prior written permission of the publisher,
except as provided by United States of America
copyright law and fair use.
Disclaimer and Terms of Use
The author and publisher of this book and the
accompanying materials have used their best efforts
in preparing this book. The author and publisher
make no representation or warranties with respect to
the accuracy, applicability, fitness, or completeness of
the contents of this book. The information contained
in this book is strictly for informational purposes.
Therefore, if you wish to apply the ideas contained in
this book, you are taking full responsibility for your
actions.
Printed in the United States of America
, CONTENTS
CONTENTS
CHAPTER ONE
INTRODUCING EXCEL
UNDERSTANDING WHAT EXCEL IS USED FOR
LOOKING AT WHAT’S NEW IN EXCEL 2022
UNDERSTANDING WORKBOOKS AND WORKSHEETS
MOVING AROUND A WORKSHEETS
Navigating with your keyboard
Navigating with your Mouse
USING THE RIBBON
Customizing the Ribbon
Ribbon Tabs
Inserting a new tab
Creating a new group
Adding a command
Changing the names of ribbon tabs, groups, and commands
Changing the position of tabs, groups, and instructions
Contextual Tabs
Types of Command on the Ribbon
Accessing the Ribbon by using your Keyboard
USING SHORTCUT MENUS
Shortcuts for formatting data
Data entry shortcuts
Data View and Navigation
Data selection
CUSTOMIZING YOUR QUICK ACCESS TOOLBAR
WORKING WITH DIALOG BOXES
USING TASK PANES
CREATING YOUR FIRST EXCEL WORKBOOK
Getting Started on Your Worksheet
Filling in the Month Names
Entering The Sales Data
Summing the Values
Making Your Worksheet Look a bit Fancier
Creating a Chart
Formatting the Numbers
Printing your Worksheet
Printing from a Selection
Using a Print Area
Saving Workbook
CHAPTER TWO
ENTERING AND EDITING WORKSHEET DATA
CRASH COURSE
Master Excel 2023 With This Complete
Crash Course In 7 Days
CARTY BINN
,Copyright © 2023 CARTY BINN
All Rights Reserved
This book or parts thereof may not be reproduced in
any form, stored in any retrieval system, or
transmitted in any form by any means—electronic,
mechanical, photocopy, recording, or otherwise—
without prior written permission of the publisher,
except as provided by United States of America
copyright law and fair use.
Disclaimer and Terms of Use
The author and publisher of this book and the
accompanying materials have used their best efforts
in preparing this book. The author and publisher
make no representation or warranties with respect to
the accuracy, applicability, fitness, or completeness of
the contents of this book. The information contained
in this book is strictly for informational purposes.
Therefore, if you wish to apply the ideas contained in
this book, you are taking full responsibility for your
actions.
Printed in the United States of America
, CONTENTS
CONTENTS
CHAPTER ONE
INTRODUCING EXCEL
UNDERSTANDING WHAT EXCEL IS USED FOR
LOOKING AT WHAT’S NEW IN EXCEL 2022
UNDERSTANDING WORKBOOKS AND WORKSHEETS
MOVING AROUND A WORKSHEETS
Navigating with your keyboard
Navigating with your Mouse
USING THE RIBBON
Customizing the Ribbon
Ribbon Tabs
Inserting a new tab
Creating a new group
Adding a command
Changing the names of ribbon tabs, groups, and commands
Changing the position of tabs, groups, and instructions
Contextual Tabs
Types of Command on the Ribbon
Accessing the Ribbon by using your Keyboard
USING SHORTCUT MENUS
Shortcuts for formatting data
Data entry shortcuts
Data View and Navigation
Data selection
CUSTOMIZING YOUR QUICK ACCESS TOOLBAR
WORKING WITH DIALOG BOXES
USING TASK PANES
CREATING YOUR FIRST EXCEL WORKBOOK
Getting Started on Your Worksheet
Filling in the Month Names
Entering The Sales Data
Summing the Values
Making Your Worksheet Look a bit Fancier
Creating a Chart
Formatting the Numbers
Printing your Worksheet
Printing from a Selection
Using a Print Area
Saving Workbook
CHAPTER TWO
ENTERING AND EDITING WORKSHEET DATA
