Excel Fundamentals
Contents
- Understanding Workbooks
- Navigating in a File
- Typing Text or Numbers Into A Worksheet
- Typing Simple Formulas In A Worksheet
- Filling A Series.
- Inserting And Deleting Worksheets
- Copying A Worksheet
- Renaming A Worksheet
- Moving or Copying A Sheet To Another Workbook
- Changing Worksheet Tab Colours
- Grouping Worksheets
- Freezing Rows And Columns
- Selecting Ranges
- Selecting Rows
- Selecting Columns
- Understanding Formatting
- Applying General Formatting
- Changing Fonts
- Changing Font Size
- Understanding Borders
- Applying A Border To A Range
- Wrapping And Merging Text
- PRACTICE EXERCISE
- Understanding Functions
- Using The SUM Function To Add
- Calculating An Average
- Finding A Minimum Value
- Common Error Messages
- PRACTICE EXERCISE
- Understanding Quick Analysis
- Quick Formatting
- Quick Charting
- Quick Totals
- Quick Sparklines
- Quick Tables
- Practice Exercise
- Printing A Worksheet
| Size : | 7199.48 Kb |
| File type : | |
| Downloads: | 603 |
| Created: | 2020-08-24 |
Others related eBooks about Excel Fundamentals
Excel 2016 ShortcutsWith this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners....
Download Publisher 2016 PDF tutorialDownload Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners....
Introduction to VBA in Excel - PDF TutorialThis is a tutorial showing how to use the macro facility in Microsoft Office—Visual Basic for Applications—to simplify analytical tasks in Excel....
Excel Data Analysis, 2nd EditionThis book offers a comprehensive and readable introduction to modern business and data ana..., download free Excel Data tutorial in PDF (358 pages) created by Hector Guerrero ....
Pivot Tables in Microsoft ExcelThe following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners....
Excel 2016 PivotTables and PivotChartsLearn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download....
Microsoft PowerPoint 2007This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher....
PowerPoint 2013 courseDownload Microsoft powerpoint 2013 courses for student, free training document in PDF designated for brginners....
VBA Excel 2010, 2013 and 2016 Tutorial in PDFDownload VBA Excel 2013 Tutorial in PDF, free training document intended to beginner users on 10 pages....
Formulas & Functions in Microsoft ExcelDownload Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott....