19/12/2019
0
Views
Excel simulator - course RUB 11,288. from Moscow Digital School, training 1.5 months, Date: December 1, 2023.
Miscellaneous / / December 03, 2023
Why learn Excel?
Knowledge of Excel can make working with data much easier. This tool has long become an indispensable assistant for anyone who works with numbers. When hiring, employers take into account a potential employee's ability to use Excel. There are about 20,000 vacancies on the labor market for specialists who know how to use Excel in their work.
We offer you 1.5 months of pure practice. You will master Excel functions that will be useful to you in your work.
Learning outcomes
Income increase
By becoming an Excel expert, you can easily increase your salary or find a better paying job
Process optimization
You will automate routine tasks and speed up working with tables by at least 2 times
Career development
Knowing how to use Excel will help you increase efficiency, save time, and show your employer that you are capable of more.
Useful acquaintances
We study with marketers, entrepreneurs, businessmen, accountants, artists and others. All of them are united by the desire for self-development and access to a closed community
Advantages
Together we will take care of your professional future
Comfortable learning
Study in a schedule that is convenient for you, track your progress in your personal account on the MDS platform, discuss topics in the chat with other students and curators
Unlimited access to materials
After completing the course you will have access to all lectures and materials
Support and care
We help at every stage of training and with solving your questions
Quality assurance
We are completely confident in our product. If you do not like the program within three days, we will refund your money
Community
You become part of the large Moscow Digital School community, where you will gain new connections and opportunities
Module 1. Excel Basics
1. Why do you need EXCEL?
2. Versions
3. Creating and saving files
4. Getting to know the interface
5. Working with sheets
6. Working with rows, columns, ranges
7. Data input
Module 2. Data manipulation
1. Data selection
2. Copy, cut, paste, delete
3. Named Ranges
4. Table ranges
Module 3. Data formatting
1. Basic Formatting Elements
2. Font formatting
3. Alignment
4. Colors and fills, borders and lines
5. Styles and themes
6. Data formats
7. Conditional Formatting
Module 4. Design and printing
1. Page layout
2. Orientation
3. Scale
4. Fields
5. Through rows and columns
6. Headers and footers
7. Printing options
8. Freeze rows
Module 5. Formulas and functions
1. Why are formulas and functions needed?
2. Entering functions
3. Tools for working with functions
4. Absolute and relative links
5. Aggregate functions
6. Mathematical functions
7. Logic functions
8. Substitution functions
Module 6. Diagrams
1. Why are diagrams needed?
2. Diagramming Basics
3. Histograms
4. Charts
5. Scatter plots
6. Waterfall charts
7. Pie and tree charts
8. Combination charts
9. Sparklines
Module 7. Pivot tables
1. Why are Pivot Tables needed?
2. Building Pivot Tables
3. Slices
4. Timelines
5. Calculations in Pivot Tables
Module 8. Data Tools
1. Filtration
2. Sorting
3. Dividing text into columns
4. Grouping, ungrouping
Module 9. Data Analysis Tools
1. Status bar
2. Subtotals
3. Consolidation
4. Quick analysis
5. Parameter selection
6. Finding a solution
Module 10. Power Query Basics
1. Why do you need Power Query?
2. Connect to Excel
3. Connecting to Internet sources
4. Connecting to Google Sheets
5. Connecting to databases
6. Useful data manipulation
7. Collecting data from many files in a folder
Module 11. Data protection
1. Sheet protection
2. Protection of structures
3. Book protection
Module 12. Additional features
1. Review
2. Comments
3. Additional settings
4. Productivity increase
5. Additional features of Google Sheets
Subscribe
YOU MIGHT ALSO LIKE
