Excel 2016 core - part oneseeders: 0
leechers: 12
Excel 2016 core - part one (Size: 15.09 MB)
Description
Description
This user guide will take you through all the things you need to know when using Excel at a simple level. You will learn how to: Get around Excel 2016 Add text and numbers to spreadsheets Use Autofill to copy formula and create series Create a basic formula Use Average Minimum and Maximum Work with Worksheets And much more Content First things first Starting Excel The Excel Window The Ribbon Customizing the Quick Access toolbar Customizing the Ribbon Using Zoom Assigning shortcut keys using The Alt Key Adding values to workbook properties The Advanced Properties Dialogue box Saving Saving a Workbook for the First Time Saving Your Workbook Once It Has A Name Save as different file formats Saving Files to remote locations Maintaining backward compatibility Backstage view The Backstage View Excel Options Share the workbook with others Share with People Share with People via File Menu Share with People from within the workbook Share Via Email Open a Shared Workbook Create Worksheets and Workbooks Creating new blank workbooks Creating New Workbooks Using Templates Changing worksheet order Move or copy to a different workbook Set how many worksheets you start with Importing a .CSV file Adding data Adding Text Adding Numbers Moving Around a Spreadsheet Cursor Shapes (Mouse Shapes) Selecting Data in a Worksheet Navigating your Workbook Searching for data within a workbook Inserting hyperlinks Using Go To Using the Name Box to Navigate Workbook Views Introduction to Views Page Breaks Creating Custom Views Working with Data Cut and Paste Using Paste Special Formatting Cells and Worksheets The Font Group The Alignment Group The Number Group Wrapping Text in a Cell Format Painter Merge or Split Cells Merging Cells Merge Across Un merge Cells Headers and Footers Headers and Footers Printing Headings Print Titles Hide and Unhide Rows and Columns Hiding Columns Un hide Columns Hiding Rows Unhide Rows Page Setup Options for Worksheets Page Orientation Changing the Header and Footer Size Setting Print Scaling Print a Worksheet or a Workbook Printing Printing individual worksheets Cell Styles Apply Cell Styles Create Cell Styles Autofill Copy Data using Autofill Fill Series using Autofill Copy Formatting using Autofill Flash Fill Flash Fill Formulas Formulas Introduction How is a formula made up? Create Formulas Add, Subtract, Multiply, Divide Make Changes to Formulas in a Cell Make Changes to Formulas in the Formula Bar Using Autofill to Copy Formulas Enforce Precedence Order of Evaluation (Order of Precedence) (BODMAS) Absolute Cell References Absolute Cell References How to Create an Absolute Cell Reference Relative Cell References Basic Functions Basic Functions Using Basic functions via the Auto sum Button Managing Worksheets and Workbooks Introduction Worksheets Create and format worksheets Adding worksheets to existing workbooks Delete Worksheets Copying and moving worksheets Rename a Worksheet Grouping Worksheets Changing worksheet tab colour Hiding worksheets Sum across Worksheets Manipulate window views Splitting the window Open Two Copies of the Same Workbook Related Torrents
Sharing Widget |