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: | 605 |
| Created: | 2020-08-24 |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others related eBooks about Excel Fundamentals
Office 365Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....
PowerPoint 2010 AdvancedDownload advanced tutorial in PDF about PowerPoint 2010, free course under 201 pages by Stephen Moffat....
Beginning Microsoft® Excel®This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and...
Evaluating Information Retrieval and Access TasksDownload free course Evaluating Information Retrieval and Access Tasks, pdf file on 225 pages by Tetsuya Sakai, Douglas W. Oard, Noriko Kando....
VBA API TutorialDownload VBA API Tutorial on 24 pages intended to advanced level users. Free training document in PDF....
Excel Basics: Microsoft Office 2013This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system....
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....
Basic Formulas in ExcelDownload basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....
Microsoft Excel 2007 Advanced - TutorialDownload free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners....
Introduction to Excel VBA Macro programmingIntroduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface...