In learning Excel 2019 is taught the following topics:
Section I: Office inauguration and recognition Excel (free)
Install the program
Delete and add in the installation program
How to Open Excel 2019
How to open a Workbook
Learn about the Excel environment
Identify the Ribbon
Zoom in and out of the page
Move between pages
Save a workbook
Closing a workbook
Open a workbook that was used recently
Use Assistant (Help)
Closure
Section II: how to use the Works Workbook (Free)
Create a workbook
Trivhedjal data
Identify equations
Add a new line or column
Sum function
Delete the line or column
Transfer line or column
Identify the Cut, Copy and Paste
Undo and Redo commands
Find and Replace commands
Manage Pages Sheet
save the file
Section III: Using formatting or Format Workbook (Free)
Organize the size of lines and columns
Merge Cells
Number Format
Format text
Use the Style or ready method
Using the Spell Checker
Identify the automated debugger (AutoCorrect)
Use the AutoFill tool
Use the Conditional formatting tool
Use a tool Quick Analysis
Section IV: Types of interfaces and print pages
Views work pages
Order Split
Order Freeze
Auto Filter tool
Add a foreground and margin title
Page format using Page Setup
Choose the area for printing
Print preview and organize
Section V: Equations and Functions (Part I)
Identify functions and equations
Copy the equation
Plug the content of a cell
Using the AutoCalculate
Sum function
Triggers
Minimum, Maximum, Count, and Rate functions
AutoSUM tool
Use the Manual Calculation property
Section VI: equations and functions (Part II)
FV function
PMT function
Use the IF conditional function
Use history in functions.
The use of statistical functions
Selection function T
Automatic correction function for the entrance
Pearson function
Section VII: Sports curves, images and special effects
Create a curved
Set the curved shape
Change the curve data
Change the curved type
Virtual change the shape of the curve
Curved title
Place Help
Use special effects
Ready to draw shapes
Insert a picture
Curves Sparklines
Section VIII: Macro and VBA
Create a new macro
Use the macro
Macro window
Change the column coordinate
Learn about the Visual Basic Editor
Forms design process in VBA
Identify the VBA commands
Save as PDF
Dear user, in teaching Excel for beginners the first three sections are taught.