Do you desire to take your knowledge of Excel to another level?
Do you wish to gain proficiency in the use of Excel?
Are you one of those people who think Excel is too hard to understand?
Guess what? This user guide is meant for you.
The user guide EXCEL 365 FOR BEGINNERS AND ADVANCED LEARNERS is designed to help beginners and experts have an in-depth knowledge on the fundamentals of Excel. This user guide contains a well detailed information with pictorial illustrations on how use Excel.
With this user guide, you will be learning a whole lot, however, I will be listing just a few of the topics to prepare your mind as regards what you get to gain by picking up this user guide
- Excel’s Start Screen
- Excel’s Workbook User interface
- Navigating Through the Excel Ribbon
- Common of Excel Ribbons
- Customizing the Quick Access Toolbar
- Understanding the workbook, worksheet, rows, columns, and cells.
- The Fill Command
- The Auto Fill Command
- Learning Data Validation
- Filtering Data in Excel
- Grouping data in Excel
- Number and Text Alignment
- Merging Cells
- Freezing and Splitting Rows and Columns
- Getting Familiar with the Formula Bar
- Inserting Formulas into your worksheet
- Editing the Formula
- Understanding the Formula Operators
- Cell Referencing
- Excel Formula Error
- Understanding the Function arguments
- Creating Tables and Charts
- Solving Common Printing Problems
- Excel Shortcuts, tips and tricks, and many other.
With all these being mentioned, I know you won’t waste this golden opportunity to harness your skills in Excel.
LEGAL NOTICE INTRODUCTION CHAPTER ONE INTRODUCTION TO OFFICE 365 Why Should You Use Office 365? Versions of Microsoft Office 365 CHAPTER TWO INTRODUCTION TO MICROSOFT EXCEL 365 What is Excel 365? Features of Excel 365 Importance of Using Excel 365 CHAPTER THREE GETTING FAMILIAR WITH EXCEL SCREEN INTERFACE Excel’s Start Screen Excel’s Workbook User Interface Navigating Through the Excel Ribbon Components of Excel Ribbons Customizing the Quick Access Toolbar CHAPTER FOUR UNDERSTANDING THE BASICS OF EXCEL What is a workbook What is a Worksheet Understanding Columns, Rows, and Cell Address. The Kinds of Data a Worksheet Accepts Hints to Observe Before Entering Data Entering Data into the Cells Editing Your Worksheet Data Copying and Moving Data in a Worksheet Cells Moving Around in a Worksheet Applying Formatting to Numbers Displaying Numbers with a Thousand Separator (Comma) Displaying Numbers with Currency Symbols Displaying Numbers as Percentage Changing the Date Format in your Cell Changing the Time Format in your Cell The Flash Fill Command Combining Data Using the Flash Fill Extracting Data with Flash Fill The AutoFill Command Entering a Series of Value Using AutoFill Copying Data Using the AutoFill Saving a File Saving a File for the First Time The Document Auto Recovery Command Learning Data Validation Applying the Data Validation to Cells Transferring the Data Validation to Other Cells in the Worksheet Removing the Data Validation From your Cells Filtering Data in Excel Grouping of Data in Excel CHAPTER FIVE FORMATTING AND MANAGING THE WORKSHEET Numbers and Text Alignment in Rows and Columns The Vertical Alignment The Horizontal Alignment Changing Text and Number Orientation Wrapping Text in Your Worksheet Merging Cells Inserting Rows and Columns Inserting a Row Inserting a Column Deleting Rows and Columns Adjusting Rows and Columns Size Adjusting the Height of the Row Adjusting the Column Width Changing the Column Width to Automatically Fit the Contents Changing the Row Height to Automatically Fit the Contents Resizing All Columns and Rows to Fit the Data or Content Freezing and Splitting Rows and Columns Freezing Your Rows and Columns Unfreezing Panes Rows and Columns Splitting in Worksheet Hiding and Unhiding the Rows and Columns Hiding the Columns Unhiding the Columns Hiding the Rows Unhiding the Rows Managing Your Worksheet Renaming Your Worksheet Selecting Worksheets. Rearranging Worksheets Inserting a New Worksheet Copying a Worksheet Deleting a Worksheet Adding Color to the Worksheet Tab Using the Comments in Your Worksheet Adding Comment to Your Worksheet Viewing the Comment on the Your Worksheet Editing a Comment in Your Worksheet Deleting a Comment Showing or Hiding All Comments Showing or Hiding Comments Individually Hiding Your Worksheet Protecting Your Worksheet CHAPTER SIX CUSTOMIZING THE WORKSHEET Changing the Worksheet Theme Changing the Theme Color Changing the Theme Fonts Changing the Theme Effects of Your Worksheet Changing the Font, Font Style, and Font Size Changing the Font of Your Worksheet Changing the Font Style of Your worksheet Changing the Font Size of Your Worksheet Changing the Font Color of Your Worksheet Changing the Cell Background Color of Your Worksheet Applying Borders to Your Worksheet Removing Border from Your Worksheet Removing Gridlines From Your Worksheet Changing the Color of Gridlines in a Worksheet Using the Cell Styles in Your Worksheet Applying Cell Styles to Your Worksheet Creating a Custom Cell Style Creating a Cell style by Modifying an Existing cell Style Duplicating an Existing Cell Style Removing Cell Styles from a Worksheet Deleting a Cell Style from a Worksheet CHAPTER SEVEN THE EXCEL FORMULA AND FUNCTIONS What is a Formula What is a Function Getting Familiar with The Formula Tab Categories of Data Excel’s Formula Accepts Inserting Formulas into your Worksheet Editing the Formula Understanding the Formula Operators The Order of Operator Precedence in Excel Formulas Manipulating the Order of Precedence Using the Parentheses Cell Referencing Types of Cell References Relative References Absolute Cell Reference and Multiple cell Reference REFERENCING OTHER WORKSHEETS IN A WORKBOOK How to Copy Formula from One Cell to Another Copying Formula Down a Column Copying a Formula Down a Column Without Copying the Formatting Copying Formula to the Entire Column Copying Formula to Non-adjacent Cells/Range Entering a Formula into Multiple Cells with a Single Key Stroke Copying Excel Formula Without the Formatting Using the Copy & Paste Features Dealing with Errors in Your Formula Excel Formula Error Messages Using the Error Checker Button Tracing Cell References Tracing Precedents Tracing Dependents Working with a Function UNDERSTANDING THE FUNCTIONS ARGUMENTS Locating the Arguments in a Function Taking a Look at Commonly Used Functions in Excel SUM for Adding Up Data AVERAGE for Averaging Data Deriving the function of a Cell Using FORMULATEXTS Counting the number of Data Items Using COUNT Counting All Data Type Using the COUNTA Counting Blank Spaces Using COUNTBLANK CONCATENATE for Combining Values Finding the Lowest Number Using MIN Finding the Highest Number Using MAX Counting Text Characters with LEN Function Changing the Orientation of the Cells With TRANSPOSE Capitalizing the First Letter of your Text String with PROPER Removing Spaces With TRIM Finding the Position of a Substring in a Text String Using the SEARCH Function Finding the Position of a Substring in a Text String Using the FIND Function Making Logical Comparison with Values Using the IF Functions Checking the Current Date and Time with TODAY and NOW CHAPTER EIGHT TABLES AND CHARTS IN EXCEL Creating a Table Changing Your Table Style Removing the Table Renaming a Table Filtering the Data in Your Table Grouping of Data in Your Table Sorting Out Data in Your Table Adding Slicer in Your Table Creating Pivot Table Inserting Recommended PivotTable in Your Data Working with Charts in Excel Types of Charts Creating a Chart with Your Data Changing the Chart Styles Changing the Chart Layout Changing the Chart Types Switching the Rows and Columns in Your Chart Moving Your Charts from One Worksheet to Another Creating Pivot Chart CHAPTER NINE SOLVING COMMON PRINTING PROBLEMS IN EXCEL Changing the Excel Worksheet Orientation Before Printing Printing One or Several Worksheets Printing an Entire Workbook Printing a Selection Printing Excel Tables Printing Charts Without Worksheet Data in Excel Printing Formula in Excel Printing Gridlines in Excel Worksheet Printing Out Comment in Excel Setting the Print Area Before Printing Inserting the Page Break Before Printing Excel Worksheet Using the Preview Option Before Printing Your Worksheet Scaling to Fit Before Printing Your Worksheet CHAPTER TEN EXCEL SHORTCUTS Editing Shortcut Navigation shortcuts File shortcuts Formula shortcuts Paste special shortcuts Ribbon Navigation shortcuts Clear shortcuts Selection shortcuts Data editing shortcut Data editing (inside a cell) shortcuts Other shortcuts CHAPTER ELEVEN TIPS AND TRICKS Removing Duplicates Values from Your Worksheet Deleting Error Cells Changing Negative Values to Positive Values in Your Worksheet Disabling the Excel Start Screen How to Make Excel Show leading Zero? Changing the Screen Background of Your Excel Environment Locking a File with a Password Saving Excel File as a PDF CONCLUSION INDEX
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.